Valuing a Teardown Before the Paperwork Is Sorted

The inventory list arrives as a spreadsheet on a Thursday. A regional jet teardown, a little over 3,100 line items. Part number, description, serial number where there is one, a condition column that says “AR” on almost every line, and a records column that’s blank on half of them. The trucks deliver the parts the following week in crates, and the records come in a box behind them.

Your buyer opens the list and starts scrolling. He knows the high-value rotables on sight. He’ll find those by the end of the day. The other 2,900 lines are the problem. Some are worth an overhaul and a tag. Some will sell as removed to a shop that does its own repair. Some are worth more as scrap than as anything else. Sorting them by hand takes weeks, and while it happens, repair budget goes to whatever the buyer recognized first.

I’ll be clear about my limits here. I’ve never worked in stores, run a quality department or signed for a part. I spent almost 18 years running a digital agency, Infographic World, and now I use AI to fix real problems inside businesses. What I understand is how a big pile of work gets sorted in an office, and how often the order it gets sorted in decides the outcome more than anyone’s judgment does.

Where the weeks actually go

Valuing a teardown or a consignment lot isn’t one decision. It’s three thousand small ones, each with the same steps.

• Identify the part. Read the part number, catch the superseded and alternate numbers, and confirm what it actually is.
• Check what the records say. Back-to-birth trace, removal tag and last operator only, a work order with no release, or nothing. In a teardown, these arrive in mixed order and often after the parts.
• Check demand. Has anyone asked you for this part lately? How many different buyers? Did they want it overhauled with a release, serviceable, or as removed?
• Check recent sales. What did this part sell for the last time you sold one, in what condition, and how long did it sit first?
• Decide. Repair and tag, sell as removed, hold, or scrap. Then route the repair candidates to the right shop.

The first four steps are reading and matching. The fifth is judgment. In most teardowns, the judgment waits weeks for the reading to finish.

What the AI-assisted version looks like

It reads the list and cleans it

The system reads the inventory list, normalizes part numbers, and expands each to its known alternates and superseded numbers from your own cross reference data. Lines it can’t identify get flagged for a person, not guessed.

It sets each line against your own demand and sales

Every part is matched against your request history and your recent sales. The demand side works the same way it does everywhere else in this business: count requests by part over 90 days and set them against the shelf. A part asked for by eight buyers last quarter sits near the top. A part nobody asked for in a year sits near the bottom. The condition each buyer asked for travels with the count, because a request for an overhauled unit with a release isn’t demand for an as-removed one.

It groups by records status

As the records get scanned, the system reads what each document says is present and files the line into a group: full trace on file, partial trace, records pending, no records found. It doesn’t decide what any document permits. It sorts, so your quality team reviews the most promising lines first instead of in crate order.

It ranks what deserves repair spend

Put demand, recent sales and records status side by side, and a short list falls out: parts with real demand, records that look complete enough for quality to review, and a sales history that suggests they move once tagged. That list goes to the buyer and the quality team. They decide what goes to the repair station. The system’s job ends at the list.

For more on why the same part is worth different amounts depending on its paperwork, see the 8130 and the same ladder.

Run the numbers

There are two parts to this.

The formula in words for time: line items, times minutes to evaluate each by hand, divided by 60, gives the hours a teardown takes to sort.

The formula in words for repair spend: the repair budget for a teardown, times the share that historically went to parts that didn’t sell within a year, gives the money that could have gone to parts with demand.

Say, for the sake of the math, with numbers I made up:

• A teardown has 3,000 line items. Evaluating each by hand (identity, records, demand and recent sales) takes 6 minutes on average. That’s 300 hours, or close to eight working weeks for one buyer.
• The repair budget for the teardown is $250,000.
• Looking back at your last few teardowns, 30 percent of the repair spend went to parts still on the shelf a year later.

That’s $75,000 of repair money tied up in parts nobody was asking for. If ranking by demand redirects even half of it toward parts with buyers, $37,500 moves from the shelf toward something that sells. And if the sorting drops from eight weeks to two, the parts that do have buyers reach them a month and a half sooner.

To run it for real, pull three numbers from your own business:

1. Line count of your last teardown or consignment lot, and how many weeks it took to reach a sale-ready list.
2. Repair spend on that lot, in total.
3. Share of repaired parts still unsold after 12 months. This is the number that tells you how much the order of work has been costing you.

Picture a Monday, before and after

This scene is made up.

Before. The teardown list has been open for two weeks. The buyer has sent the obvious rotables for repair and is working down the list alphabetically. The quality manager is opening records boxes in the order they came off the truck. A part with nine requests last quarter is on page 47 of the list and in the fourth box. Nobody gets to it for another month.

After. Same Monday, two days after the list arrived. The buyer opens a ranked view: 140 lines with demand from three or more buyers, grouped by records status. The quality manager starts on the 60 with records on file, in rank order. By Friday, 25 parts are approved to go to the repair station, and the buyer has a short list of as-removed parts to offer the shops that asked for them.

What has to be in place first

• Request history from every channel, at least one quarter, with the condition each buyer asked for.
• Sales history with condition, price and days on shelf.
• Your own cross reference data for alternates and superseded numbers.
• A written rule from your quality system on what records it accepts at each condition, so the groups mean something.
• Repair station cost and lead time for your common parts, so the buyer can judge whether a repair makes sense.

Guardrails worth keeping

• The quality system decides. What a record supports and what a part can become isn’t the system’s call, or mine.
• Records stay with the part. Physically and in the system, from the day the box arrives.
• No sale on a sort. A records group is a review order, not a representation to a buyer.
• Consignment terms rule. Who approves repair spend on a consigned part is set by the agreement with the owner.
• Log every decision and the reason, so the next teardown starts from evidence.

How you’ll know it’s working

• Days from list received to first repair order sent.
• Share of repaired parts sold within 12 months, teardown over teardown.
• Hours spent sorting per hundred line items.
• Quality team hours per teardown, and how many of them went to lines that ended up sold.
• For consignment lots, days from receipt to the owner’s first approved repair list.

Where I’d start

Take your last teardown. Match its list by hand against one quarter of requests, and compare which parts you repaired with which parts had demand. If the overlap is weak, you’ve found where the repair money has been going. Do the matching first on the next one, before anything goes to the repair station.

If this sounds like your week, send me a note through the contact page.