N858AS
Service difficulty reports not matched to an aircraft · 141
They name N858AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N858AS' AND registry_match IS NULL ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N858AS' AND registry_match IS NULL ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR ASOA2012012500331Angle · corrodedFWD CORNER OF ASD CORRODED ON HINGE END. R & R BOTTOM FWD CORNER OF ASD PAN. REMOVED OLD BOTTOM FWD CORNER ANGLES 2 EA DRILLED & LOCATED NEW CORNER ANGLES 2 EA IAW SRM 51-40-11. INSTALLED FWD ASD CORNER IAW SRM 51-42-06, 51-42-13. INSTALLED 3 EA FASTENER THSDR ASOA201200190Sill · corrodedCORROSION ON SERVICE DOOR SILL. REMOVED CORROSION. REMOVED .015" OF MATERIAL .048" REMAINING SILL IS OUT OF LIMITS. REPLACED SILL ANGLE. INSTALLED SILL IAW SRM 51-42-21 AND 51-42-34.SDR ASOA201200176Unknown · corrodedLBL 27 HAS CORROSION FS 605.00 TO 574.00. REMOVED CORROSION IAW SRM 51-21-06 AND FOUND TO BE OUT OF LIMITS, REMOVED FLOORBEAM TEE IAW SRM 51-42-06 & 51-42-21. INSTALLED IAW REO 601R-53-61-3778, STEPS 1-4 AND STEPS 6 THRU 9.SDR ASOA201200175Attach Angle · corrodedSERVICE DOOR SILL FWD ATTACH ANGLE CORRODED OUT OF LIMITS. REMOVED AND INSTALLED NEW ANGLE IAW SRM 51-42-21 AND DWG NR 601R38338.SDR ASOA201200174Bulkhead · crackedREAR PRESSURE BULKHEAD CRACKED AT LBL 27.50 BETWEEN WL 121.93 & WL 137.50. REPAIRED IAW REO 601R-53-61-1541.SDR ASOA201200188Track · gougedCARGO DOOR AFT GUIDE TRACK GOUGED JUST OTBD OF UP TURN. AREA MARKED. REMOVED AFT CARGO, AFT GUIDE TRACK IAW SRM 51-42-06 AND 51-42-21. DRILLED AND COUNTERSUNK NEW AFT GUIDE TRACK IAW SRM 51-40-11-00 AND ALODINED HOLES IAW SRM 51-21-11-00. INSTALL AFT CARGO SDR ASOA201200186Sill · corrodedRT FLOOR SILL BETWEEN FS 295 AND 310 IS CORRODED. REMOVED CORROSION IAW SRM 51-21-06. BLENDED AREA REQUIRES NDT THICKNESS CHECK TO DETERMINE SERVICEABILITY. PERFORMED UT THICKNESS OF BLEND AREA IAW MAC NDT INSP PROCEDURE UT-3 MIN MATERIAL REMAINING IS .061"SDR ASOA201200143Floorbeam · crackedANGLE CRACKED AT RBL 9 FLOORBEAM AT FS280. REMOVED CRACKED ANGLE IAW SRM 51-42-20. LOCATED AND DRILLED NEW ANGLE. INSTALLED ANGLE IAW SRM 51-42-20.SDR ASOA201200142Floorbeam · crackedANGLE CRACKED AT LBL 9 FLOORBEAM AT FS 280. REMOVED CRACKED ANGLE IAW SRM 51-42-20. LOCATED AND DRILLED NEW ANGLE. INSTALLED ANGLE IAW SRM 51-42-20.SDR ASOA2012011200329Panel · damagedCARGO BAY RT LOWER WALL PANEL 282ARW DAMAGED AT AFT LOWER SECTION. PICK UP FASTENER HOLES WHEN REQUESTED. DRILLED ALL REQUIRED FASTENER HOLES AS REQUIRED IAW SRM 51-40-11. THIS REPAIR REQUIRES MAJOR/MINOR CLASSIFICATION IAW ASA SOP 572. THE REPAIR IS CLASSIFSDR ASOA201200168Bracket · crackedCABLE SUPPORT BRACKET AT FS 484, LBL 27 CRACKED. REMOVED BRACKET, LOCATED AND DRILLED NEW BRACKET IAW SRM 51-42-21. INSTALLED NEW BRACKET IAW SRM 51-42-21 AND 51-23-00.SDR ASOA201200140Seat Track · corrodedLEFT SEAT TRACK AT FS 461 CORRODED. REMOVED CORROSION IAW SRM 51-21-06. PERFROMED UT THICKNESS INSP OF BLEND AREA IAW NDT INSP PROECEDURE UT-3. FOUND WITHIN LIMITS IAW SRM 53-21-49 4.SDR ASOA201200139Seat Track · corrodedSEAT TRACK CORRODED AT LBL 9, FS 559+16. BLENDED CORROSION IAW SRM 53-51-49-53-21-49. FOUND TO BE IN LIMITS IAW SRM 53-21-49.SDR ASOA201200138Seat Track · corrodedSEAT TRACK CORRODED AT RBL 9, FS 559+16, +48, +64. BLENDED CORROSION IAW SRM 53-51-49 & 53-21-49. FOUND TO BE IN LIMITS IAW SRM 53-21-49.SDR ASOA201200137Seat Track · corrodedSEAT TRACK CORRODED AT RBL 9, FS 529 - 513. BLENDED AREAS OF CORROSION IAW SRM 53-41-49 & SRM 53-21-49. PERFORMED UT THICKNESS INSPECTION IAW MAC NDT INSP PROCEDURE UT-3, WITHIN ALLOWABLE LIMITS IAW SRM 53-21-49.SDR ASOA201200136Seat Track · corrodedSEAT TRACK CORRODED AT RBL 9, FS 409.00+16 AND +64. BLENDED AREAS AND FOUND CORROSION DEPTH OF .025, OUT OF LIMITS IAW SRM 53-31-49 & SRM 53-21-49. R & R SEAT TRACK IAW AMM 53-00-47.SDR ASOA201200135Seat Track · corrodedSEAT TRACK CORRODED AT LBL 9, FS 364.00. REMOVED CORROSION IAW SRM 51-21-06, PG1, PAR 3 & SRM 53-21-49. PERFORMED UT IAW MAC NDT INSPECTION PROCEDURES UT-3, MIN MATERIAL REMAINING FOR DIMENSION U IS .359", ORIGINAL IS 370", REMOVED IS .011. FOUND WITHIN LIMSDR ASOA201200133Cargo Track · corrodedCARGO TRACK AT LBL 27 BS 559.+80 CORRODED. REMOVED AND REPLACED CARGO TRACK IAW AMM 20-21-00, TASK 20-21-00-910-801 AND SRM 53-61-49.SDR ASOA201200132Cargo Track · corrodedCARGO TRACK AT RBL 9 559.+80 CORRODED. REMOVED AND REPLACED CARGO TRACK IAW SRM 53-61-49 AND AMM 20-21-00-910-801.SDR ASOA201200131Cargo Track · corrodedCARGO TRACK AT LBL 27 559.+80 CORRODED. REMOVED AND REPLACED CARGO TRACK IAW SRM 53-61-41 AND AMM 20-21-00-910-801.SDR ASOA201200130Cargo Track · corrodedCARGO TRACK AT LBL 27 559.+80 CORRODED. REMOVED AND INSTALLED NEW CARGO TRACK IAW AMM 20-21-00, TASK 20-21-00-910-801 AND SRM 53-61-49.SDR ASOA201200127Cargo Track · corrodedCARGO TRACK AT LBL 27, FS 554.00 CORRODED. R & R CARGO TRACK IAW SRM 53-61-49 & 51-41-04.SDR ASOA201200126Cargo Track · corrodedCARGO TRACK AT RBL 27 FS 559 +112 CORRRODED. R & R CARGO TRACK IAW AMM'S 53-01-11-000-802 & 53-01-11-400-802.SDR ASOA201200125Cargo Track · corrodedCARGO TRACK AT LBL 27, FS 559 +112 CORRODED. REMOVED & REPLACED CARGO TRACK IAW SRM 53-61-49 AND 51-41-02.SDR ASOA201200124Cargo Track · corrodedCARGO TRACK AT FS 589 CORRRODED. R & R CARGO TRACK IAW AMM 20-21-00 TASK 20-21-00-910-801 AND SRM 53-61-49.SDR ASOA201200123Cargo Track · corrodedCARGO TRACK AT LBL 9 FS 605.00 CORRRODED. R & R CARGO TRACK IAW SRM 53-61-49 & 51-41-04.SDR ASOA201200122Cargo Track · corrodedCARGO TRACK BETWEEN FS 605 - 621 LBL 9 IS CORRODED. R & R CARGO TRACK IAW SRM 53-61-49.SDR ASOA201101797Lamp · burned outCEILING EMERGENCY LIGHT AT 14AB IS OUT. RELAMPED CEILING EMERGENCY LIGHT AT 14AB IAW AMM 33-51-16, OPS CHECKED GOOD.SDR ASOA201101523Bulkhead · crackedFOUND FS 559 RT SIDE BULKHEAD WEB HAS INDICATION NOTED APPROX .2" IN LENGTH 50 PERCENT FSH AT WL 59.10 INBD OF RBL 18.0. FAILED NDT INSPECTION. COMPLIED WITH EC/TC REO 601R-53-41-260 AND REO 601R-53-41-260, REV E.SDR ASOA201001872Bulb · burned outAFT EMERGENCY CEILING LIGHT IS INOP. R & R AFT EMERGENCY CEILING LIGHT BULB IAW AMM 33-51-16. OPS CHECKED GOOD/ITEM: 1/ R & R AFT EMERGENCY CEILING LIGHT BULB IAW AMM 33-51-16. OPS CHECKED GOOD.SDR ASOA201001839Placard · missingEXIT PLACARD MISSING ON AIRSTAIR DOOR. REPLACED EXIT PLACARD ON ASD IAW CRJ200AMM 11-30-02.SDR ASOA201001512Handle · seizedMAIN ASD OUTER HANDLE VERY HARD TO TURN TO UNLOCK AN OPEN DOOR. LUBED HANDLE AND DOOR SEALS INSPECTED DR OPERATION OK FOR SERVICE IAW AMM 52-11-01. (CLOSED)SDR ASOA201000459Battery Pack · inoperativeBOTH RT AND LT AFT EXTERIOR EMERGENCY LIGHTS INOP. R & R THE NR 4 BATTERY PACK (EMERGENCY LIGHT) REF: AMM TASK 33-51-04-000-801 AND TASK 33-51 04 400-801 OPS CHECKED GOOD.SDR ASOA201000438Sill · corrodedSERVICE DOOR LOWER SILL PLATE CORRODED AT AFT SECTION AT FS 347. INSTALLED FABRICATED ANGLE ALL WORK DONE IAW SRM 51-42-06. REINSTALLED PANEL 242CRF ALL WORK DONE IAW AMM 53-01-01-400-802. COMPLIED WITH EC/TC REO 601R-53-21-1105 AND REO 601R-53-21-1105 REVSDR ASOA201000396Bulkhead · crackedAFT PRESSURE BULKHEAD IS CRACKED LINTEL ATTACH BRACKET. INSTALLED LINTEL FITTING IAW STEP 5,13,14,19-24 KJ161732 INSTALLED SOLID RIVETS AROUND FILLER COMMON TO LINTEL FITTING AND SOLIDS THROUGH FUSELAGE FWD OF FS 621 IAW REO 601R-53-61-1230. INSTALLED FASTENSDR ASOA201000437Sill · corrodedSERVICE DOOR LOWER SILL PLATE CORRODED AT AFT SECTION AT FS 349. INSTALLED TWO LOCK FASTENERS ON SERVICE DOOR ANGLE, AND RESTORE FINISH PER REO601R-53-21-1105 COMPLIED WITH STEP 5. INSTALLED 3 NUTPLATES, INSTALLED NYLON DOUBLER, INSTALLED 2 BRACKETS, AND INSDR ASOA201000371Attach Bracket · crackedAFT PRESSURE BULKHEAD IS CRACKED LINTEL BRACKET. CONTINUE FAB AND DRILLING UP REPAIR PARTS IAW REO 601R-53-61-1230 REV C. PERFORMED ET INSP OF CUT LINES ON AFT PRESSURE BULKHEAD AND INTERCOSTAL IAW REO 601R-53-61-1230 STEP 7 IAW NDTM PART 1, 51-20-06 NO INDSDR ASOA201000370Attach Bracket · crackedAFT PRESSURE BULKHEAD IS CRACKED LINTEL ATTACH BRACKET AREA IS MARKED. PERFORMED CUTOUT TO AFT PRESSURE BULKHEAD IAW REO 601R-53-61-1230, FABRICATED -3 & -4 SHIMS OUT OF 2024-T3 .020 TO A RUFF CUT, MADE CUTOUT ON INTERCOSTAL IAW REO 601R-53-61-1230. LAID-OSDR ASOA201000360Attach Bracket · crackedAFT PRESSURE BULKHEAD IS CRACKED ABOVE LINTEL ATTACH BRACKET, AREA IS MARKED. REMOVED ALL ANGLES AND BRACKETS FWD OF FS 621 BULKHEAD NESSESARY FOR LINTEL FITTING REPAIR IAW SRM 51-42-21 AND 51-42-06 FOR REO 601R-53-61-1230. PARTS ORDERED FOR FWD SIDE. REMOVESDR ASOA201000331Skin · corrodedCORROSION ON AFT LOWER CONER OF PAX DOOR CUT OUT BELOW ANCHOR FITTING FS 349. BLENDED OUT CORROSION. ABOVE WORK PERFORMED IAW SRM 54-42-13 AND 51-21-06. PERFORMED UT THICKNESS MEASUREMENT OF BLEND AREA ON BEAM AT FS 349.00 BETWEEN LBL 45.00 AND LBL 27.00 IAWSDR ASOA201000330Lock Pin · lack of lubeCREW ESCAPE HATCH FUNCTIONAL TEST FAILS STEPS 1B AND 1H AND STEP I OF WC ASA-2-838008. CLEANED AND LUBRICATED CREW ESCAPE HATCH LOCK PINS IAW AMM SUB TASK 12-20-52-640-003 STEP A. COMPLIED WITH FUNCTIONAL TEST OF CREW ESCAPE HATCH AND FUNCTIONAL TEST GOOD IASDR ASOA201000315Counterbalance · out of adjustPASSENGER DOOR EXTREMELY HARD TO OPEN USING EXTERNAL HANDLE. INSPECTED AND FOUND EXTERNAL HANDLE HARD TO ROTATE NEEDS FURTHER TROUBLE SHOOTING. NEEDS MORE TROUBLE SHOOTING. UPON FURTHER TROUBLESHOOTING FOUND PAX DOOR COUNTERBALANCE OUT OF ADJUSTMENT. ADJUSDR ASOA201000219Bracket · damagedAFTER T/O RECEIVED NOSE DOOR, GEAR DISAGREE WARNING WOW INPUT AND NOSE STEERING INOP CAUTION. RAN QKH - RETURNED TO DEPARTURE, NORMAL- LANDING HELD NOSE OFF- BELOW 80 KNOTS HAD SEVERE VIBRATION FROM NOSE. ACFT RETURNED TO DEPARTURE AFTER T/O. EMERGENCY DECLSDR ASOA200901317Step · crackedASD BOTTOM STEP CRACKED.SDR ASOA200901172Angle · crackedANGLE FOUND TO BE CRACKED UPON REMOVAL. INSTALLED NEW ANGLE AT LBL36.20 ON ENG BEAM PER SRM 51-42-06 AND 51-42-21.SDR ASOA200900914Unknown · odorFLT 5142. STRONG ODOR REPORTED BY F/O WHILE HOLDING IN ATL AIRSPACE, STRONG ENOUGH TO MAKE CREW FEEL UNCOMFORTABLE. INSPECTED CARGO COMPARTMENT AND CABIN FOUND ODOR RESEMBLING FINGERNAIL POLISH AROUND ROW 1 C/D IN CABIN, ODOR DISAPEARED SHORTLY AFTER GROUND SDR ASOA200900684Flashlight · inoperativeCAPT`S FLASHLIGHT INOP.SDR ASOA200900075Light · inoperativeEMERGENCY LIGHTS DON’T COME ON.SDR TRAX200800572Light · inoperativeFWD EMERGENCY LIGHTS INOP.SDR TRAX200800317Angle · crackedPAX DOOR FWD STAIR ANGLE CRACKED IN RADIUS.
Back to N858AS