N829AS, cancelled Feb 20, 2015
Service difficulty reports · 134
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 = 'N829AS' AND deregistration_id = 'N829AS-2015-02-20' 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 = 'N829AS' AND deregistration_id = 'N829AS-2015-02-20' 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 ASOA200900512Pressure Panel · crackedFS 460 PRESSURE FLOOR HAS MULTIPLE CRACK INDICATIONS NOTED FWD AND AFT SIDE FS 460 RBL 9 AND LBL 9. TEMP REPAIR COMPLIED WITH IAW REO 601R-53-41-884A. THIS SDR WILL REMAIN OPEN PENDING MTC DETERMINATION OF AN APPROPRIATE CORR ACTION.SDR ASOA200900499Floor Support · corrodedRT AFT FUSELAGE, FS 559.00+80 FLOOR SUPPORT PLATE CORRODED BETWEEN RBL 9 AND RBL 27.SDR ASOA200900498Seat Track · corrodedRIGHT AFT SEAT TRACK AT FS 559.00 - 559.00+80 RBL 9 CORRODED.SDR ASOA200900403Bulkhead · damagedREAR PRESSURE BULKHEAD WEB THAT SURROUNDS THE LINTEL ATTACHMENT FITTING HAS AN INDICATION NOTED APPROX .2 INCH IN LENGTH 90 PERCENT FSH. FAILED NDT INSPECTION. REPAIRED PRESSURE BULKHEAD IAW REO 601R-53-61-1230.SDR ASOA200900402Bulkhead · damagedREAR PRESSURE BULKHEAD HAS AN INDICATION NOTED AT RBL 9.5, WL 84 APPROX .2 INCH IN LENGTH 50 PERCENT FSH. FAILED NDT INSPECTION. REPAIRED IAW SRM 51-41-02SDR ASOA200900401Pressure Panel · damagedFS 460 PRESSURE FLOOR HAS MULTIPLE INDICATIONS NOTED BETWEEN FWD AND AFT SIDE OF FS 460 BL 0.0 AND RBL 9.0 AND BETWEEN FWD SIDE OF FS 460 BL 0.0 AND LBL 9.0. MULTIPLE INDICATIONS IN ALL THREE AREAS APPROX 3.0 INCH IN LENGTH 90 PERCENT, 50 PERCENT AND 30 PERCENSDR ASOA200900400Intercostal · crackedPRESSURE BULKHEAD INTERCOSTAL FS 621-625 STRINGER 14L IS CRACKED APPROX 1 INCH L.SDR ASOA200900399Angle · crackedLT 621 TO 625 OBLIQUE ANGLE IS CRACKED APPROX .5 INCH L AT STR 14L.SDR ASOA200900464Drag Angle · crackedVERTICAL STAB DRAG ANGLE DIAPHRAGM CRACKED 1.1 INCH LONG ON RT AFT SIDE UNDER RUDDER.SDR ASOA200900391Skin · damagedLT WING LOWER PLANK ACCESS HOLE 540CB HAS MULTIPLE HFEC INDICATIONS 0.1 INCH IN LENGTH, 50 PERCENT 80 PERCENT FSH ON THE FWD CRITICAL AREA OF THE LANDING. INDICATIONS ARE MARKED ON THE ACFT. FAILS NDT AT THIS TIME. C/W EC/TC EO 600-57-81 & C/W IAW REO 601R-SDR ASOA200900390Skin · damagedLT WING LOWER PLANK ACCESS HOLE 540DB HAS MULTIPLE HFEC INDICATIONS 0.1 INCH IN LENGTH, 50 PERCENT 80 PERCENT FSH ON BOTH FWD AND AFT CRITICAL AREAS OF THE LANDING. INDICATIONS ARE MARKED ON THE AIRCRAFT. FAILS NDT AT THIS TIME. C/W EC/TC EO 600-57-81 C/W SDR ASOA200900389Skin · damagedRT WING LOWER PLANK ACCESS HOLE 640CB HAS MULTIPLE HFEC INDICATIONS NOTED ON THE O/B NON-CRITICAL AREA OF THE LANDING. INDICATIONS ARE APPROX 0.1 INCH LONG WITH 50 PERCENT 80 PERCENT FSH SIGNALS. AREAS ARE MARKED ON THE AIRCRAFT. FAILS NDT AT THIS TIME. C/SDR ASOA200900388Skin · damagedRT WING LOWER PLANK ACCESS HOLE 640DB HAS MULTIPLE HFEC INDICATIONS NOTED ON BOTH FWD AND AFT LANDINGS IN THE CRITICAL AREAS. INDICATIONS ARE APPROX 0.1 INCH LONG WITH 50 PERCENT 80 PERCENT FSH SIGNALS. AREAS ARE MARKED ON THE AIRCRAFT. FAILS NDT AT THIS TISDR ASOA200900387Skin · damagedRT WING LOWER PLANK ACCESS HOLE 640FB HAS MULTIPLE HFEC INDICATIONS NOTED ON THE AFT PORTION OF THE LANDING. INDICATIONS ARE APPROX 0.1 INCH IN LENGTH WITH 50 PERCENT 80 PERCENT FSH SIGNALS. AREAS ARE MARKED ON THE AIRCRAFT. FAILS NDT AT THIS TIME. INDICATSDR ASOA200900386Pressure Panel · damagedFS 460 PRESSURE FLOOR HAS MULTIPLE INDICATIONS NOTED BETWEEN FWD AND AFT SIDE OF FS 460 BL 0.0 AND RBL 9.0 AND BETWEEN FWD SIDE OF FS 460 BL 0.0 AND LBL 9.0. MULTIPLE INDICATIONS IN ALL THREE AREAS APPROX 3.0 INCHES IN LENGTH 90 PERCENT, 50 PERCENT AND 30 PERCSDR ASOA200900385Doubler · crackedRIGHT FS 484 FLOOR SUPPORT INTERCOSTAL PREVIOUS REPAIR ANGLE AT RBL 27 CRACKED .2 INCH LONG.SDR ASOA200900377Bulkhead · damagedRT FS 559 BULKHEAD WEB HAS INDICATIONS NOTED APPROX .2 INCH IN LENGTH 70 PERCENT FSH O/B OF RBL 9.0, WL 58.70 AND WL 59.10 I/B OF RBL 18.0 APPROX. .5 INCH IN LENGTH 70 PERCENT FSH, AND LT AND RT CAP ANGLE HAS INDICATIONS NOTED AT BL 18 APPROX .2 INCH IN LENGTHSDR ASOA200900376Post · damagedFS 409.0+128 VERTICAL POST LBL 18.0 HAS INDICATIONS NOTED INBOARD AND OUTBOARD SIDES AT WL 69.0 APPROX .2 INCH IN LENGTH 50 PERCENT FULL SCREEN HEIGHT FAILED NDT INSPECTION. REMOVED DAMAGED VERTICAL POST PER SRM 51-42-06 AND 51-42-21. FABRICATED REPLACEMENT PSDR ASOA200900375Post · damagedFS 409.0+128 VERTICAL POST RBL 18.0 HAS INDICATION NOTED OUTBOARD SIDE AT WL 69.0 APPROX .2 INCH IN LENGTH 50 PERCENT FULL SCREEN HEIGHT FAILED NDT INSPECTION. REMOVED DAMAGED VERTICAL POST PER SRM 51-42-06 AND 51-42-21. 2. FABRICATED REPLACEMENT POST IAW SRMSDR ASOA200900374Post · damagedFS 409.0+128 VERTICAL POST RBL 18.0 HAS INDICATION NOTED OUTBOARD SIDE AT WL 69.0 APPROX .2 INCH IN LENGTH 50 PERCENT FULL SCREEN HEIGHT FAILED NDT INSPECTION. REMOVED DAMAGED VERTICAL POST PER SRM 51-42-06 AND 51-42-21. 2. FABRICATED REPLACEMENT POST IAW SRMSDR ASOA200900268Wire · brokenBROKEN EMERGENCY LIGHT WIRE AT FS 310 FOR WARDROBE.SDR TRAX200800755Door · stiffTHE F/A REPORT THE MAIN DOOR IS UNUSUALLY DIFFICULT TO OPEN. CYCLE PAX DOOR SEVERAL TIMES. NO DEFECT NOTED AT THIS TIME. IAW AMM 52-11-00. (B)SDR TRAX200701589Warning Message · illuminatedIN FLIGHT SHORTLY AFTER TAKEOFF, RECEIVED AT PAX OUTER DOOR CAUTION MSG FOLLOWED BY A PAX DOOR WARNING RED MSG. COMPLIED WITH QRH THIRD WRITE UP ON DOOR. A/C RETURNED TO ATL AFTER T/O. EMERGENCY DECLARED. FLT 4814 DEL 50 MINS.SDR TRAX200701583Warning Message · illuminatedPAX DOOR WARNING MESSAGE. A/C RETURNED TO YOW AFTER T/O. EMERGENCY EQUIPMENT ON STANDBY. FLT 4568 CX.SDR TRAX200701509Door · malfunctionedCABIN DOOR WON'T OPEN FROM OUTSIDE.SDR TRAX200701440Hydraulic System · leakingHYDRAULIC SYSTEM NR 1 LOST HYDRAULIC FLUID WHILE IN FLIGHT. A/C RETURNED TO ATL AFTER T/O. EMERGENCY DECLARED.SDR TRAX200701233Anchor Fitting · crackedFWD ASD ANCHOR FITTING CRACKED. REMOVED AND REPLACED FWD ASD ANCHOR FITTING IAW AMM CH 52-10-00. RII SATIFACTORY FOR ANCHOR FITTING REPLACEMENT IAW SP 607.SDR TRAX200701234Anchor Fitting · corrodedFWD ASD ANCHOR FITTING CORRODED.SDR TRAX200700918Light · inoperativeWARDROBE EMERGENCY EXIT LIGHT STRIP INOP.SDR TRAX200700873Unknown · unknownFLAPS FAIL CAUTION MSG AT CRUISE. FOLLOWED QRH (BTMS DID NOT GO RED). EMERGENCY DECLARED. FLT 4319 CX.SDR TRAX200700812Strap · out of positionUNABLE TO OPEN ASD, LCL FOUND DOOR HANDLE STRAP CLOSED IN DOOR.SDR TRAX200700652Step · corrodedLOWER STEP OF PAX DOOR STAIRCASE IS CORRODED.SDR TRAX200700651Sill · corrodedCORROSION FOUND AT SEVERAL PLACES ON PASSENGER DOOR LOWER SILL.SDR TRAX200700629Angle · corrodedANGLE FS 280 LBL 9 TO RBL 9 CORRODED. [SUP 05-15-07] OUT OF LIMITS IAW SRM 53-11-15.ANGLE AT FS 280 LBL 9 TO RBL 9. REMOVED AS PER SRM 51-42-06. INSTALLED ANGLE AT F/S 280 BL9 TO BR9 IAW SRM 51-42-21 ALSO SRM 51-42-13.SDR TRAX200700628Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN FS 559.00 + 80 TO FS 559.00 + 112 RBL 27. [SUP 05-15-07] CORROSION ON FLOOR BEAM BTWN FS 559.00 + 80 TO FS 559.00 +112 RBL 27 REMOVED AS PER 51-21-06. ALODINED, PRIMED AND PAINTED AS PER SRM 51-21-11.SDR TRAX200700627Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN FS 559.00 + 80 TO FS 559.00 + 112 RBL 9. [SUP 05-22-07] CORROSION ON FLOOR BEAM BTWN FS559.00+80 TO FS559.00+112 RBL 9 REMOVED IAW SRM 51-21-06. FOUND BEYOND LIMITS IAW SRM 53-51-43 FIG. 101. REPAIR PREFORMED IAW SRM 53-00-43SDR TRAX200700626Sill · corrodedRIGHT SILL CORRODED BETWEEN FS 559.00 + 80 TO 559.0 +112.SDR TRAX200700625Floor Support · corrodedCORROSION ON FLOOR SUPPORT STRUCTURE CAP SPLICE AT FS 559.00 + 80 FROM LBL 45 TO RBL 45. CORROSION ON FLOOR SUPPORT STRUCTURE CAP PLICE AT FS 559.00 +80 FROM LBL 45 TO RBL 45. REMOVED AS PER SRM 51-21-06 AND BLENDED AREA. TREATED AS PER SRM (51-21-11)(51-25SDR TRAX200700635Plate · corrodedCORROSION ON 3 PLATES BETWEEN FS 574.00 TO 621.00 AND 3 SEALS MISSING. [SUP 05-15-07] CORROSION REMOVED ON 3 PLATES BETWEEN FS 574.00 TO 621.00 IAW SRM 51-21-06. ALODINE APPLIED IAW SRM 51-21-11. FINISH AREA IAW SRM 51-21-16. GASKETS (3) INSTALLED ON 3 PSDR TRAX200700634Plate · corrodedFLOOR LANDING GEAR PLATE CORROSION BETWEEN FS 559.00 +112 TP 612.00 LBL 45.00 AROUND NUT PLATE HOLES.SDR TRAX200700613Intercostal · crackedCLIP ON RIGHT AFT FACE BULKHEAD INTERCOSTAL CRACKED FS 621.00. [SUP 05-17-07] REMOVED AND REPLACED IAW REO 601R-53-61-100, AND ASA EO 600-53-174C.SDR TRAX200700612Splice · corrodedCORROSION ON FLOOR SUPPORT STRUCTURE CAP SPLICE AT FS 559.00 +112 AND 589.00 FROM LBL 45 TO RBL 45. REMOVED CORROSION AS PER SRM 51-21-06. ALODINED, PRIMED AND PAINTED AS PER SRM 51-21-11. MATERIAL THICKNESS .063", MATERIAL REMOVED .005". WITHIN LIMITS PER SDR TRAX200700611Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN FS 559.00 + TO 621.00 AND LBL 2. [SUP 05-17-07] REMOVED CORROSION AND FOUND OUT OF LIMITS IAW REO 601R-53-00-005. FLOORBEAM FABRICATED AS PER SRM 51-24-36. FABRICATE FLOORBEAM INSTALLED AS PER SRM 51-42-20.SDR TRAX200700610Seat Track · corrodedSEAT RAIL CORRODED AT FS 559.00 + 80 AND RBL 27. [SUP 05-15-07] CORROSION ON SEAT RAIL AT F.S 559.00 +112 RBL 27 REMOVED AS PER SRM 51-21-06. MATERIAL THICKNESS .100, MATERIAL REMOVED .032. OUT OF LIMITS AS PER SRM 53-61-49 FIG 101. NEW SEAT RAIL INSTALLSDR TRAX200700609Floorbeam · corrodedCORROSION ON FLOORBEAM BETWEEN FS 559.00 +112 TO 621 AND LBL 9. [SUP 05-15-07] CORROSION ON FLOOR BEAM BTWN FS 559.00 +112 TO 621 AND LBL 9 REMOVED AS PER SRM 51-21-06. ALODINED AND PRIMED AS PER SRM 51-21-11. PAINTED AS PER SRM 51-21-11.SDR TRAX200700605Angle · crackedANGLE AND CLIP CRACK AT FS 484 LBL 27 AND LBL 36. [SUP 05-15-07] CUTOUT AT CRACKED ANGLE AND CLIP AT FS 484 LBL 27 AND LBL 36 WAS PERFORMED IAW REO 601R-53-41-059. HFEC PERFORMED BY HEATHAIR W/O 36306 IAW REO 601R-53-41-059. NO CRACKS FOUND. AMO 46-90 CRACSDR TRAX200700604Angle · corrodedCORROSION ON FLOOR ANGLE LT AND RT BTWN FS 409.0 + 128 TO FS 559.00. [SUP 05-15-07] ON FLOOR ANGLE L/H AND R/H. CORROSION REMOVED AS PER SRM 51-21-06. CORROSION PREVENTION AS PER SRM 51-21-11 AND PAINT AS PER SRM 51-21-11. MATERIAL THICKNESS .080, MATERSDR TRAX200700600Angle · damagedETNRTC 500-13, AT WS 178 OUTB'D FLAP ANGLE ON THE FLAP AFT SIDE ANGLE CRACKED. [SUP 05-15-07] AFTER FURTHER INVESTIGATION HOLE WAS FOUND TO BE DOUBLE HOLED THRERFORE WAS RWORKED TO INSTALL OVERSIZE FASTENER IAW SRM 51 42 20 , 51 42 06.SDR TRAX200700567Flashlight · inoperativeCAPTAIN`S FLASHLIGHT INOP.SDR TRAX200700501Flashlight · inoperativeF/A FLASHLIGHT INOP.
Back to N829AS, cancelled Feb 20, 2015