N913DE
Service difficulty reports · 185
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 = 'N913DE' AND registry_match = 'registration' 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 = 'N913DE' AND registry_match = 'registration' 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 DALA2017051803984Cusp Web · corrodedCORROSION ON THE CUSP WEB UPPER & LOWER SURFACE RBL 54 - 60, BETWEEN BS 739 - 769, IN THE PAX CABIN. THE CUSP WEB WAS REPLACED IAW SRM 53-14-3, AND 53-05, FIG 131, A-24.SDR DALA2017051803983Cusp Web · corrodedCORROSION ON CUSP WEB UPPER & LOWER SURFACE LBL 54 TO 60 BETWEEN BS 518 - 541, BS 553 - 556, AND BS 573 - 579 IN THE PAX CABIN. THE CUSP WEB WAS REPLACED IAW SRM 53-14-3, AND 53-05, FIG 131, A-24.SDR DALA2017051803982Cusp Web · corrodedCORROSION ON CUSP WEB UPPER & LOWER RBL 54 TO 60 BETWEEN BS 503 & 604. THE CUSP WEB WAS REPLACED IAW SRM 53-14-3, AND 53-05 FIG 131 A-24.SDR DALA2017051803981Angle · corrodedCORRODED ANGLE ON THE CARGO DOOR FRAME BS 1212, LONGERON 22R IN THE AFT CARGO BAY. THE ANGLE WAS REPLACED IAW DWG 4912817, ITEM 503, REV C.SDR DALA2017051803980Floor Panel · crackedCRACK ON FLOOR PANEL 200F. THE FLOOR PANEL WAS REPAIRED IAW SRM 53-05, FIG 131B, PAR 145.SDR DALA2017051603907Seat Track · corrodedCORROSION OUT OF LIMITS AT BS 671 - 672 ON SEAT TRACK PLUG LBL 54. THE PLUG WAS REPLACED IAW SRM 53-05, FIG 4A.SDR DALA2017051603906Doubler · debondedDISBONDED PREVIOUS REPAIR DOUBLER AND IMPROPERLY DISTANCE OF FASTENER TO EDGE ON RH CUSP WEB BTW BS 427-434 RBL 54 TO 60 AT PAX CABIN. THE REPAIR DOUBLER WAS FABRICATED AND WAS INSTALLED IAW SRM 51-30-2, 51-05, FIG 131A, AND 51-30-5.SDR DALA2017051503876Cusp Web · corrodedCORROSION ON CUSP WEB, BS 1222 - 1224, LBL 54 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-6.SDR DALA2017051403875Spacer · corrodedCORROSION ON PREVIOUS REAPAIR SPACER AND ON BEAM BETWEEN BS 636 - 693, LONGERON 28R. REPAIRED IAW SRM 53-05, FIG 123.SDR DALA2017051403874Doubler · debondedDISBONDED REPAIR DOUBLER BS 294, BETWEEN LONGERONS 17 & 18L. THE DOUBLER WAS REPLACED IAW SRM 53-04-3, FIG 2, & 51-30-2.SDR DALA2017051303872Longeron · crackedCRACK ON LONGERON 12L, BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2017051303871Cusp Web · crackedCRACKED RT CUSP WEB BS 885 BETWEEN LBL 54 AND 60. DOUBLER AND FILLER FABRICATED AND INSTALLED IAW SRM 53-05, FIG 131A-3.SDR DALA2017051203824Longeron · corrodedCORROSION ON LONGERON 24L, BS 1170. THE LONGERON WAS REMOVED AND REPLACED IAW SRM 51-30-02, SRM 51-10-4, AND SRM 51-30-5.SDR DALA2017051203823Fitting · crackedCRACK ON FITTING BS 655 BETWEEN BEAM 1 AND LWR EDGE AT MID CARGO DOOR. FITTING REPLACED IAW SRM 51-30-5 AND 51-30-2. (LP0016410)SDR DALA2017051203821Pan · crackedCRACKED L1 DOOR FWD & AFT PAN BETWEEN BEAM 1 AND TOP. THE PAN CORNERS WERE REPAIRED IAW SRM 52-05, FIG 18A.SDR DALA2017051203820Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 160 - 200, RBL 44. FLOOR SUPPORT REPLACED IAW SRM 51-30-2, 51-30-5, AND 51-10-3, PAR 26.SDR DALA2017060604495Skin · dentedSEVERAL DENTS ON OTBD VANE AT RT INBD FLAP. DUE TO SEVERAL DENTS ON OUTBD VANE AT RT INBD FLAP. WILL BE REPLACED IAW SRM 57-04, PARAGRAPH. 5. C. (1).SDR DALA2017051103765Vane · delaminatedDELAMINATION ON INBD VANE OF THE OTBD FLAP. THE VANE WAS REPLACED IAW SRM 57-03 D, PARAGRAPH 11 B.SDR DALA2017051103757Beam · crackedCRACKED R1 DOOR NR 1 BEAM FWD SECTION. THE BEAM WAS REPLACED IAW SRM 51-30-1, 51-30-2, AND 51-30-5.SDR DALA2017051103756Cusp Web · crackedCRACK ON CUSP WEB BETWEEN BS 844, RBL 57. DAMAGE AREA WAS REPAIRED IAW SRM 53-05, FIG 131A-3.SDR DALA2017051103755Floorbeam · corrodedCORROSION ON FLOORBEAM BS 200, RBL 47 TO 58. THE FLOORBEAM WAS REPLACED IAW SRM 51-30-5 AND 51-10-4.SDR DALA2017051103754Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 210, RBL 12, IN THE PAX CABIN. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-5, AND 51-10-4.SDR DALA2017051103752Access Panel · corrodedCORRODED ACCESS PANEL 1303C ON LT WING. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A, PAR 6, CONDITION III.SDR DALA2017051103751Channel · crackedCRACKED CHANNEL ON RT FWD EMERGENCY EXIT DOOR BELOW STOP FITTING NR 1. THE CHANNEL WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2017051103750Beam · crackedCRACKED L1 DOOR BEAM NR 7 AFT SECTION. THE DOOR BEAM WAS REPAIRED IAW SRM 52-05, FIG.109.SDR DALA2017051003734Doubler · crackedCRACK ON DOUBLER REPAIR BETWEEN BS 905, LBL 56 IN THE PAX CABIN LT SIDE. THE DOUBLER WAS REPLACED IAW SRM 53-05, FIG 131A-12.SDR DALA2017051003733Spar Cap · crackedCRACK ON UPPER INBD HOLE ON THE HORIZONTAL STABILIZER RT REAR UPPER SPAR CAP. REPAIRED.SDR DALA2017051003732Skin · crackedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND ON THE LOWER SKIN BETWEEN XRS 163 - 168, REAR SPAR ON RT WING. REPAIRED IAW ER/A 556412-14AD, REV.ORIGINAL.SDR DALA2017051003731Skin · crackedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND ON LOWER SKIN BETWEEN XRS 163 - 168, REAR SPAR. REPAIRED IAW ER/A 556412-14AD, REV ORIGINAL.SDR DALA2017051003728Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 160 - 200 LBL 54. FLOOR SUPPORT STA Y=160-169 X=44 WAS REMOVED; DRILLED; ADJUSTED; TREATED AND PAINTED; AND INSTALLED PER DC9/MD80 SRM 51-30-2; 51-30-5; 51-10-4; 51-10-3 PAR 14 AND 21/FLOOR SUPPORT STA Y=186-195 X=44 CORRSDR DALA2017051003727Doubler · wornWEAR ON LWR AFT/FWR DOUBLER CORNERS AT FWD CARGO DOOR. REPAIRED IAW ER/A 486624-14 MA, REV ORIGINAL.SDR DALA2017050903697Skin · wornWEAR ON HOOK DOUBLER AT L1 DOOR EXTERNAL SKIN. DOUBLER WAS REPLACED PER DC-9/MD-80 ER/A 486216-14MA REV. A. (LP0012218)SDR DALA2017050903686Support · crackedCRACKED SYNCRONIZER ACTUATOR SUPPORTS AT LT ENGINE. SUPPORTS THREE EAS WERE REPLACED IAW DWG 5938303 REV E AND SRM 51-30-1.SDR DALA2017050903685Floor Support · corrodedCORROSION ON FLOOR SUPPORT BETWEEN BS 160 - 200, LBL 44. A NEW FLOOR SUPPORT WAS INSTALLED IAW SRM 51-30-2, AND 51-30-5.SDR DALA2017050903684Skin · damagedSUNKEN FASTENERS ON REPAIR DOUBLER ON THE SKIN AT BS 200 AND 218, LONGERON 26L. THE REPAIR WAS REPLACED IAW SRM 53-04-3, FIG 10.SDR DALA2017060604496Tab · damagedPRESENCE OF WATER WAS FOUND ON LEFT ELEVATOR ANTI-FLOAT TAB HONEYCOMB STRUCTURE. LEFT ELEVEATOR ANTI FLOAT TAB WAS REMOVED PER MD 88 AMM 27-30-14, WAS REPLACED.SDR DALA2017050803628Floor Support · crackedCRACKED FLOOR SUPPORT AT BL 0 BETWEEN BS 1287 AND 1309. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-2, AND 51-30-5.SDR DALA2017050803626Bushing · corrodedCORROSION ON BUSHINGS AFT AT RT HEATER BLANKET. DAMAGED BUSHINGS WERE REPLACED IAW SRM 51-30-10.SDR DALA2017050703621Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT BS 200, LBL 56. THE FLOOR SUPPORT WAS REMOVED IAW SRM 51-30-2, AND 51-30-5. A NEW FLOOR SUPPORT WAS FABRICATED IAW SRM 51-10-2, AND DWG 9910078, REV JC. TREATED AND PAINTED IAW SRM 51-10-3, PAR 21, AND 14 AND INSTALLED IAW SRMSDR DALA2017050703620Cusp Web · wornWEAR ON CUSP WEB, BS 1000, RBL 56 IN THE PAX CABIN. DOUBLER WAS FABRICATED IAW SRM 53-05 FIG.131A-13. AREA WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 21, AND 14, THE DOUBLER WAS INSTALLED IAW SRM 53-05, FIG 131A-13.SDR DALA2017050703619Seat Track · corrodedCORROSION OUT OF LIMITS ON THE SEAT TRACK RBL 22, BS 203 - 205. THE SEAT TRACK WAS REPLACED IAW SRM 53-05, FIG 4F, CONF. 7001.SDR DALA2017050603616Cusp Web · corrodedCORROSION ON CUSP WEB RBL 54 TO 60 BETWEEN BS 470 TO 474. DAMAGED AREA WAS REPAIRED IAW SRM 53-05, FIG 131A-14.SDR DALA2017052604242Tab · dentedDENTS ON RT CONTROL TAB, THE TAB WAS REPLACED IAW SRM 55-04 PAR 2.SDR DALA2017052604241Tab · delaminatedDELAMINATED CONTROL TAB AT LT ELEVATOR. LT CONTROL TAB REPLACED IAW SRM 55-04 PAR 2.SDR DALA2017050503588Pan · crackedCRACKED FWD/UPPER CORNER RING PAN LT BS 927. REPAIRED IAW SRM 53-05 FIG 122.SDR DALA2017050503587Pan · crackedCRACKED LWR /FWD CORNER RING PAN LH SIDE STA Y=1041. REPAIRED IAW SRM 53-05, FIG 122.SDR DALA2017050503586Pan · crackedCRACKED RT WINDOW RING PAN UPPER /AFT CORNER BS 1136. REPAIRED IAW SRM 53-05 FIG 122.SDR DALA2017050503585Pan · crackedCRACKED ON LWR/AFT ,FWD/UPPER CORNER RING PAN LH SIDE BS 845. REPAIRED IAW SRM 53-05 FIG 122.SDR DALA2017050503583Pan · crackedCRACKED LT WINDOW RING PAN UPPER AFT CORNER BS 1250. REPAIRED IAW SRM 53-05, FIG 122.SDR DALA2017010500128Frame · crackedTAIL CONE GUIDE PIN 12 O’CLOCK FRAME CRACKED. INSTALLED REPAIR AS PER ERA 497316-14MA SEC 1 REV ORIGINAL.
Back to N913DE