N121DE, cancelled May 9, 2017
Service difficulty reports · 71
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 = 'N121DE' AND deregistration_id = 'N121DE-2017-05-09' 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 = 'N121DE' AND deregistration_id = 'N121DE-2017-05-09' 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 DALA2016060604456Battery Pack · inoperativeAFT CABIN EMERGENCY LIGHTING IS INOPERATIVE. MAINTENANCE REPLACED THE EMERGENCY POWER SUPPLY BATTERY PACKS M9009 AND M9010. SYSTEM OPS IS NORMAL.SDR DALA2016060604455Wire · pulledEMERGENCY LIGHTS AT 19R AND 47R ARE INOPERATIVE. MAINTENANCE FOUND AT BOTH LOCATIONS WIRES PULLED OUT OF CONNECTORS SIDEWALL AND REPINED CONNECTORS. SYSTEM OPERATION IS GOOD.SDR DALA2015123007819Skin · corrodedFUSELAGE SKIN CORRODED, EXTERNAL SKIN AT LOWER CAVITY POPPET DRAIN. AT AFT END OF LT NLG W/W TUNNEL SKIN EXFOLIATED AND CRACKED. C/W ERA 54226-14, ORIGINAL, REF LP 2286535, 2286537, 2286538, 2286543.SDR DALA2015123007818Skin · corrodedFUSELAGE, SECTION 41, LT SKIN, STA 287, S-36L, CORROSION. C/W ERA 541993-14.SDR DALA2015123007817Skin · corrodedFUSELAGE 41 SECTION SKIN BS 287 S-37L CORROSION.SDR DALA2015122907813Tee Fitting · corrodedWHILE DRILLING UPPER T CHORD, 141T2938 FOR NOSE W/W REPAIR, DRILLED INTO NOSE GEAR PIVOT FITTING WEB. REPAIRED IAW ERA 542226-14.SDR DALA2015122407822Skin · corrodedCENTER WING UPPER SURFACE AT FS 883.5 AND LBL 90 HAS AREA OF CORROSION APPROXIMATELY 2" IN DIAMETER. REPAIRED IAW ERA 541299-14.SDR DALA2015122407821Fuel Tank · corrodedLAV 214 ON THE LT SIDE OF THE AIRPLANE BELOW THE CABIN FLOOR. HAS NUMEROUS AREAS OF CORROSION ON THE OUTER SKIN OF THE CENTER TANK. REPAIRED IAW ERA 541299-14.SDR DALA2014100805477Light · inoperativeFOUND EMERGENCY LIGHTS ON SEATS 19, 31, 32 LT SIDE INOPERATIVE. ROW 38 RT SIDE EMERGENCY LIGHT BRACKET BROKEN. MAINTENANCE FIXED LIGHTS AT 19 AND 32. REPLACED LIGHT COVER ASSY AT 31AB AND BRACKET ON 38 RT SIDE. SYSTEM OPERATION IS NORMAL.SDR DALA14020900121Light · inoperativeEMERGENCY LIGHTS AT 28B ARE INOPERATIVE. REPLACED SEAT BUMPER ASSEMBLY. SYSTEM OPERATION IS NORMAL, REMOVED.SDR DALA1257790121Light · inoperativeEMERGENCY FLOOR LIGHTS AT SEAT 29B ARE INOPERATIVE. MX FOUND MISSING CLIP NUTS AT BRACKET ASSY AND REPLACED. SYS OPS IS NORMAL.SDR DALA1235780121Fitting · crackedRT FUSELAGE UNDERWING LONGERON FITTING IS CRACKED AND REPLACED PER EA 01-499898-03 ME-04 REV ORIG.SDR DALA1235770121Fitting · crackedLT FUSELAGE UNDERWING LONGERON FITTING IS CRACKED AND REPLACED PER EA 01-499898-03 ME-03 REV ORIG.SDR DALA1236140121Door Frame · corrodedCARGO DOOR CUTOUT AFT FRAME WEB CORROSION BETWEEN S32L AND S33L BS 1461. REPAIRED PER ERA 502708-14 REV ORIG.SDR DALA1233520121Bolt · misinstalledDURING THE SLAT MAIN TRACK DOWN STOP ASSY INSPECTION, STOP BOLTS WERE FOUND TO HAVE INCORRECT THREAD PROTRUSION AT NUTS. BOLTS AND NUTS WERE REPLACED AS PER OPN 2201.SDR DALA1232910121Floorbeam · corrodedFORWARD CARGO, FS 654+44, RBL 39, FLOORBEAM UPPER CHORD CORRODED. REPAIRED AS PER SRM 53-00-07, REPAIR 4, FIGURE 201, DETAIL VI.SDR DALA1236130121Floorbeam · crackedMAIN DECK BS 347 LBL 8 AND RBL 9 FLOORBEAM UPPER FLANGE CRACKED. REPAIRED PER ERA 502703-14 REV ORIG.SDR DALA1232420121Floorbeam · corrodedFS 325, RBL 17 TO RBL 52, UPPER FLOORBEAM CORROSION. REPAIRED AS PER SRM 53-00-51, REPAIR 1, FIGURE 201.SDR DALA1232410121Floorbeam · corrodedFS 278, RBL 62 TO RBL 65 FLOORBEAM UPPER TEE CORROSION. REPAIRED AS PER SRM 53-00-51, REPAIR 1, FIGURE 201.SDR DALA1232400121Floorbeam · crackedFS 1000 WL199 INCH LBL33, FLOORBEAM CRACKED. REPAIRED AS PER SRM 53-00-51 REPAIR 3, FIGURE 201, DETAIL II.SDR DALA1232390121Access Panel · delaminatedRT OTBD TRAILING EDGE FLAP UPPER ACCESS PANEL 666KT DELAMINATED. REPAIRED AS PER SRM 57-53-01, REPAIR 1, FIGURE 201, SHEET 3 AND SRM 51-70-10, REPAIR 4, FIGURE 202, SHEET 3.SDR DALA1232380121Fairing · delaminatedRT WING OTBD TRAILING EDGE FLAP, LEADING EDGE FAIRING DELAMINATED. REPAIRED AS PER SRM 57-53-01, REPAIR 1, TABLE 1 AND SRM 51-70-05 PAR 5A(1), FIGURE 5.SDR DALA1232360121Fairing · delaminatedRT WING OTBD TRAILING EDGE FLAP INBOARD LEADING EDGE FAIRING DELAMINATED. REPAIRED PER SRM 57-53-01, REPAIR 1, TABLE 1 AND SRM 51-70-05 PAR 5A(1), FIGURE 5.SDR DALA1232350121Wedge · delaminatedRT WING OTBD TRAILING EDGE FLAP, LOWER SURFACE WEDGE DELAMINATED. REPAIRED AS PER SRM 57-53-01, REPAIR 1, TABLE II AND SRM 51-70-07, PAR 5A(1), FIGURE 9.SDR DALA1232340121Floorbeam · damagedAFT CARGO BS 1219 LBL 18 TO RBL 5, FLOORBEAM UPPER TEE AFT FLANGE HAS SCREW HOLES ELONGATED. REPAIRED IAW SRM 53-00-07, REPAIR 4 FIGURE 201 DETAIL VI.SDR DALA1236160121Failsafe · corrodedRT STA 955 BULKHEAD FAILSAFE STRAP REPAIR TEE FITTING CORRODED. REPAIRED PER ERA 502701-14AD REV ORIG.SDR DALA1236150121Failsafe · crackedBS 955 RT BULKHEAD FAILSAFE STRAP 1 FASTENER HOLE CRACKED. REPAIRED PER ERA 502701-14 REV ORIG.SDR DALA1136330121Failsafe · crackedDURING ULTRASONIC INSPECTION, CRACK INDICATION FOUND LT SIDE FAILSAFE STRAP OF THE REAR SPAR BULKHEAD AT STA 955. REPAIR CARRIED OUT PER PRI488814-14AD REV.0 DATED 15MAR2011 0817HRS. PRI488814-14AD REV.0 COMPARED WITH ER/A488814-14 REV.0 DATED 20MAY2011 0815HSDR DALA1136320121Skin · damagedSCIBE LINE AT STA1532 S-22L REPAIRED AS PER PRI492328-14AD REV.0 DATED 03MAY2011 1550HRS, PRI492328-14AD REV.1 DATED 06MAY2011 1713HRS, PRI492328-14AD REV.2 DATED 10MAY2011 1124HRSAND COMPLIED WITH ER/A492328-14AD REV.0 DATED 21MAY2011 0942HRS.SDR DALA1136310121Skin · corrodedCORROSION AT FUSELAGE STA 427-434 S-37L, REPAIRED AS PER PRI490913-14AD REV.0 DATED 27APR2011 1515HRS, PRI490913-14AD REV.1 DATED 03MAY2011 1015HRS AND COMPLIED WITH ER/A490913-14AD REV.0 DATED 21MAY2011 0957HRS.SDR DALA1136300121Skin · crackedNR 1 PYLON OTBD CORE COWL UPP AFT EXTERIOR CRACKED SKIN REPAIRED PER PRI490780-14 REV.0 TO REV.2 DATED 25APR2011 1117HRS. PRI490890-14 REV.0 TO REV.2 COMPARED WITH ER/A490890-14 REV.0 DATED 20MAY2011 1228 HRS FOUND IN COMPLIANCE.SDR DALA1136290121Skin · corrodedCENTER WING TANK UPPER SKIN UNDER LT MID LAVATORY AROUND LBL 90 STA 845, CORRODED SURFACE REPAIRED PER PRI488818-14 REV.0 TO REV.6 DATED 12MAY2011 1419HRS. PRI488818-14 REV.0 TO REV.6 COMPARED WITH ER/A488818-14 REV.0 DATED 24MAY2011 0819HRS FOUND IN COMPLIANCSDR DALA1136260121Skin · corrodedRT WING T/E REAR SPAR AT APPROX WS 415 UPPER CHORD OF SKIN EXTENSION, CORRODED SKIN REPAIRED PER PRI490875-14 REV.0, REV.1 AND REV.2 DATED 18APR2011 1210HRS. PRI490875-14 REV.0, REV.1 AND REV.2 COMPARED WITH ER/A490875-14 REV.0 DATED 20MAY2011 1146HRS FOUND INSDR DALA1136250121Access Panel · damagedNR 1 PYLON ACCESS PANEL NR 436AR CUTOUT REPAIRED PER PRI490910-14 REV.0 AND REV.1 DATED 28APR2011 1714HRS. PRI490910-14 REV.0 AND REV.1 COMPARED WITH ER/A490910-14 REV.0 DATED 20MAY2011 1327HRS FOUND IN COMPLIANCE.SDR DALA1136240121Skin Panel · corrodedCENTER TANK UPPER EXTERNAL SKIN AT STA 954, CORRODED SKIN REWORKED AND REPAIRED PER PRI490903-14 REV.0 DATED 13APR2011 0803HRS. PRI490903-14 REV.0 COMPARED WITH ER/A490903-14 REV.0 DATED 20MAY2011 1000 HRS FOUND IN COMPLIANCE.SDR DALA1136230121Keelbeam · corrodedFX-LT KEEL BEAM CHORD UPPER SURFACE AT STA 1014, CORRODED SURFACE REPAIRED PER PRI490885-14 REV.0 AND REV.1 DATED 18APR2011 1121HRS. PRI490885-14 REV.0 AND REV.1 COMPARED WITH ER/A490885-14 REV.0 DATED 20MAY2011 1120HRS FOUND IN COMPLIANCE.SDR DALA1136220121Keelbeam · corrodedFX-LT KEEL BEAM CHORD UPPER SURFACE AT STA 1010, CORRODED SURFACE REPAIRED PER PRI490885-14 REV.0 AND REV.1 DATED 18APR2011 1117HRS, PRI490885-14 REV.0 AND REV.1 COMPARED WITH ER/A490885-14 REV.0 DATED 20MAY2011 1130HRS FOUND IN COMPLIANCE.SDR DALA1136210121Skin · unknownMEC DOOR SKIN (P/N:141T6301-57) FABRICATED AND INSTALLED PER PRI490906-14 REV.0 DATED 21APR2011, PRI490906-14 REV.0 COMPARED WITH ER/A490906-14 REV.0 DATED 20MAY2011 1237HRS FOUND IN COMPLIANCE.SDR DALA1136200121Seat Track · unknownCABIN SEAT TRACK UNDER LT MID LAVATORY LBL 92 STA 845, SEAT TRACK FABRICATED AND INSTALLED PER PRI490882-14 REV.0 DATED 28MAR2011 0914HRS. PRI490882-14 REV.0 COMPARED WITH ER/A490882-14 REV.0 DATED 20MAY2011 1007HRS FOUND IN COMPLIANCESDR DALA1136190121Tee Fitting · unknownAROUND BS 955, T-FITTING FABRICATED AND INSTALLED PER PRI490880-14AD REV.0 DATED 25MAR2011 0907HRS, PRI490880-14AD REV.0 COMPARED WITH ER/A490880-14AD REV.0 DATED 20MAY2011 0851HRS FOUND IN COMPLIANCE.SDR DALA1136180121Skin · corrodedCORROSION AT FUSELAGE SKIN AT STA 434 S-37R REPAIRED AS PER PRI 490913-14AD REV.0 DATED 27APR2011 1515HRS, PRI490913-14AD REV.1 DATED 03MAY2011 1015HRS AND COMPLIED WITH ER/A 490913-14AD REV.0 DATED 21MAY2011 1008HRSSDR DALA1136170121Skin · crackedCRACKED SKIN AREA AT STA 654+68 S-2R ON THE LOWER SKIN OF THE LAP JOINT REPAIRED AS PER SRM 53-00-01 REPAIR 12 FIG 201 OTIS AND COMPLIED WITH PRI 492492-14AD DATED 10MAY 2011 1210HRS AND ER/A 492492-14AD DATED 20 MAY 2011 1016HRS.SDR DALA1136160121Stringer · corrodedCORRODED STRINGER AT STA 434 S38R FOUND CORRSION EXCEED LIMIT AS PER SRM 53-00-03 FIG 101 OTIS. REPAIR CARRIED OUT ON STRINGER AT STA 434 S-38R AS PER SRM 53-00-03 FIG 201 REPAIR 2 OTIS.SDR DL76S081817Skin · delaminatedDURING SHOP VISIT, SERVICE DAMAGE WAS FOUND ON THE LOWER SKIN OF THE RT WING OUTBOARD MAIN FLAP. THE DAMAGE RESULTED IN A LOWER SKIN CUTOUT OF 33.5 INCH BY 5.8 INCH. REPAIRED PER ERA HAS BEEN IN SHOP FOR SEVERAL YEARS, ONLY REMAINING A/C IN THE FLEET EFFECTISDR DL76S081112Gasket · leakingHAD FUEL IMBALANCE DURING FLIGHT. LEFT SIDE WAS 1300-1400 LBS LOWER THAN RIGHT. AFTER BALANCED TOTAL FUEL WAS LESS THAN CALCULATED. DETERMINED FUEL LEAK WAS POSSIBLE AND DIVERTED TO LAS. FOUND FUEL LINE FROM FCU TO FUEL PUMP LINE GASKET LEAKING. REPLACED SDR DL76S080764Spar · corrodedDURING SHOP VISIT, CORROSION WAS FOUND ON THE REAR SPAR OF THE RT INBOARD MAIN FLAP. THE DAMAGE WAS CUT OUT AND A REPLACEMENT SECTION WAS SPLICED IN. REPAIR WAS COMPLETED PER ERA 467064-14.SDR DL76S080647Keelbeam · corrodedLT KEELBEAM CORRODED ON OUTBD FLANGE BETWEEN FS 965-933. DAMAGE REMVOED AND A REPAIR STRAP WAS INSTALLED.SDR DL76S080644Skin · corrodedFUSELAGE SKIN CORRODED AT S-36L LAP JOINT NEAR FS 500. DAMAGED SKIN AND TEAR STRAP CUT OUT AND REINFORCED WITH DOUBLERS.SDR DALA1210380121Link · unknownLINK REPLACEMENT IAW 01-076248-12. ME07 OUTBOARD LINK REPL-OUTBOARD FLAP-LEFT P/N 113T1321-XX ME08 INBOARD LINK REPL-OUTBOARD FLAP-LEFT P/N 113T1322-XX ME09 OUTBOARD LINK REPL-INBOARD FLAP-LEFT OUTER PINS ME10 INBOARD LINK REPL-OUTBOARD FLAP RIGHT P/N 113SDR DL76S080108Floorbeam · misinstalledDURING AN IFE MOD AT BFM, AN EXISTING FLOORBEAM SPLICE REPAIR WAS FOUND TO BE INSTALLED INCORRECTLY. THE REPAIR WAS REMOVED AND A NEW SPLICE REPAIR WAS INSTALLED.
Back to N121DE, cancelled May 9, 2017