N130DL, cancelled May 9, 2017
Service difficulty reports · 60
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 = 'N130DL' AND deregistration_id = 'N130DL-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 = 'N130DL' AND deregistration_id = 'N130DL-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 DALA2016022501589Support · damagedRT WING, FLAP, OTBD, NR 7 SUPPORT, 1-2-3 BEAM, FASTENER HOLE, TOOLING DAMAGE. C/W ERA 544013-14.SDR DALA2014111106252Power Supply · inoperativeAFT EMERGENCY CEILING LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE M734 POWER SUPPLY AND BATTERY AT SEAT 45. SYSTEM OPS NORMAL.SDR DALA2014100605476Skin · damagedLIGHTNING STRIKE ON SKIN BS 654+44 AND TWO INCHES BELOW S24R. REPAIRED IAW SRM 53-00-01.SDR DALA2014100605475Skin · damagedLIGHTNING STRIKE ON SKIN AT BS 721 S24R. REPAIRED IAW SRM 53-00-01.SDR DALA2014091505098Charger · inoperativeEMERGENCY LIGHTS AT ROWS 25-34 ARE INOPERATIVE. MAINTENANCE REPLACED BATTERY PACK AND CHARGER. SYSTEM OPS ARE NORMAL.SDR DALA14034490130Frame · crackedINNER ANGLE CRACKED ON FWD SIDE OF FRAME BS 859.5 BELOW WL 200 . REPAIRED IAW WC 5311-01195-09-01A.SDR DALA14020070130Skin · damagedFOUND RT INBD T/E FLAP PUNCTURED AND GOUGED ON TOP SURFACE. DAMAGE LOCATED UNDER OTBD SECTION OF NR 7 SPOILER. TIME LIMITED REPAIR IAW ERA 524625-14.SDR DALA14004250130Charger · inoperativeEMERGENCY ESCAPE PATH LIGHTS FIRST 6 ROW ON RT SIDE ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY CHARGER. SYSTEM OPS ARE NORMAL.SDR DALA13071450130Battery Pack · inoperativeEXIT LIGHT ABOVE 1L DOOR AND 1R DOOR HANDLES NOT OPERATING DURING EMERGENCY LIGHT TEST. REPLACED BATTERY PACK IN CHARGER M1208.SDR DALA13030170130Skin · damagedFOUR LIGHTNING STRIKES ON SKIN BETWEEN BS 604 -610 STRINGERS 34 - 35L. DRILLED OUT DAMAGE ON UPPER TWO STRIKES AND CUT OUT DAMAGE ON LOWER TWO STRIKES. C/W HFEC INSPECTION OF UPPER TWO STRIKES IAW SRM 53-00-01, REPAIR 8, SECTION 1. NO DISCREPANCIES. C/W PRISDR DALA1312550130Slide · unknownOVERWING SLIDES DISARMED. REARMED SLIDES. SYSTEM CHECKS NORMAL.SDR DALA1310930130Power Supply · inoperativeFOUND ONE EXIT EMERGENCY LIGHT INOPERATIVE. R & R POWER SUPPLY AND BATTERY, OPS CHECKED OK IAW AMM 33-.SDR DALA2015040507863Floorbeam · damagedELONGATED HOLES AT BS 287 FLOORBEAM TO FRAME INTEGRATION AT RBL 85. REPAIR IAW ER/A 00-512821.SDR DALA1308210130Longeron · damagedTEN FASTENER HOLES FOUND WITH SHORT EDGE CONDITION ON RT LONGERON, BS 783. ACCOMPLISHED IAW ER/A 511858-14AD, REV ORIGINAL.SDR DALA1308180130Structure · corrodedCABIN - STA 852, RBL 77-88 FOUND CORRODED ON CENTER WING SECTION UPPER SURFACE AND REPAIR CARRIED OUT IAW ER/A 511834-14, REV O.SDR DALA1308170130Longeron Fitting · crackedRT UNDERWING LONGERON FITTING ROUND CRACKED AND REPLACEMENT CARRIED OUT IAW EA 01-499898-03AD.SDR DALA1308160130Floorbeam · crackedCABIN STA 303,LBL 33 FLOORBEAM WEB FOUND CRACKED AND REPAIRED CARRIED OUT IAW ER/A 511855-14, REV 0.SDR DALA1308150130Floorbeam · corrodedCABIN-FWD GALLEY STA 287 RBL 11-77 FLOORBEAM UPPER TEE CORROSION. REPAIRED IAW ERA 512480-14, REV. ORG.SDR DALA1308140130Floorbeam · corrodedCABIN-FWD GALLEY STA 287, RBL 11-77 FLOORBEAM UPPER TEE FOUND CORROSION WITH ELONGATED HOLES IN FRAME. REPAIRED IAW ERA 512821-14, REV ORG.SDR DALA1308200130Skin · corrodedLWR FX-REPAIR DOUBLER AT STA 1197+110 - 1219 STR 37L - 37R EXTERNAL SURFACE CORRODED. COMPLIED WITH ER/A 512461-14, REV O.SDR DALA1308190130Skin · corrodedDURING STRINGER REPAIR FOUND CORROSION ON FX SKIN FROM STA 1197 TO STA 1197+22 STR 36R. REPAIR IAW ERA 512462-14, REV ORIGINAL.SDR DALA1307020130Structure · crackedCRACKED LOCATION ON STRIP AT STR 7R, TRIMMED OFF IAW SRM 53-80-01, REPAIR 5, FIG 201. REV 91.02. REPAIR PARTS FABRICATED IAW SRM 53-80-01, FIG 201, REPAIR 5. REV 91.02 REPAIR PARTS AT BS 1725.5, STR 7R INSTALLED IAW SRM 53-80-01 FIG 201. REPAIR 5. REV 91.0SDR DALA1225800130Wire · cutEMERGENCY FLOOR LIGHTING DAMAGED LEFT SIDE ROW 11-20/35-46. RIGHT SIDE ROW 1-11/25-34. RT FWD COAT CLOSET RED LIGHT INOP. WIRE BEHIND SEAT 5A NEEDS SPLICE INSTALLED. WIRE WAS CUT. REPAIRED WIRING BEHIND SEAT 5A. FOUND WIRES SHORTED AT SEAT 17AB. REPAIRESDR DALA1219190130Power Supply · inoperativeEMERGENCY LIGHTS AT SEATS 35-46 LEFT ARE INOPERATIVE. MTC REPLACED THE POWER SUPPLY M9010. SYSTEM OPERATION IS NORMAL.SDR DALA1212210130Charger · inoperativeMAINTENANCE FOUND EMERGENCY LIGHTS INOPERATIVE AT ROWS 39-46 RT SIDE AND 25-32 LEFT SIDE. THE BATTERY CHARGER WAS REPLACED. SYSTEM OPERATION IS NORMAL.SDR DALA1171270130Power Supply · inoperativeEMERGENCY LIGHTS AT SEATS 25-34FG AND ROWS 35-44ABC ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY AND POWER SUPPLY PER AMM. SYSTEM OPERATION IS GOOD.SDR DALA1165040130Charger · inoperativeSEAT MOUNTED EMERGENCY LIGHTS ROWS 25-34FG AND 34-46AB ARE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY CHARGER M9010 SYSTEM OPERATION IS NORMAL.SDR DALA1125330130Light · inoperativeDURING OP 2525 FOUND EMERGENCY LIGHT INOPERATIVE FROM ROWS 1-12 RIGHT SIDE AND 13-21 LEFT SIDE. MAINTENANCE REPLACED M9008 AND M9009 PER AMM. SYSTEM OPERATION IS NORMAL.SDR DALA1108800130Charger · inoperativeEMERGENCY LIGHTS AT ROWS 1-12 RT SIDE AND 13-21 LT SIDE ARE INOPERATIVE. MX REPLACED THE BATTERY CHARGER AND BATTERY ASSY, M9009. SYS OPS IS NORMAL.SDR DL76S091543Control Rod · lack of lubeRTB DUE TO ON TAXI OUT AILERONS BINDING. DURING FLT CONTROL CHECK BINDING OCCURRED 1/2 WAY THRU LEFT ACTUATION. MULTIPLE OCCURRENCES BOTH SIDES LT AND RT BIND INTERMITTENTLY. T/S PER FIM 27-11-00-101. REMOVED, CLEANED, LUBRICATED AND REINSTALLED CONTROL ROSDR DL76S081642Target · unserviceableAFTER TAKEOFF APPROX 200FT AGL, THE STICK SHAKER ACTIVATED. AIRSPEED WAS NML AND FLAPS 15DEG. DURING FLAP RETRACTION RECEIVED LEADING EDGE SLAT ASYM CAUTION MSG. PERFORMED QRH PROCEDURE. FOUND DAMAGED TARGET AT NR 10 SLAT INBD TRACK. REPLACED SAME. REPLASDR DL76S070964Skin · corrodedDURING HMV3 AT MOBILE AEROSPACE ENGINEERING, FOUND AFT PIT AT S36R OTBD LOWER FLANGE EXFOLIATED BS 1175 TO BS1197. REMOVED DAMAGED AREA AND INSTALLED REPAIR STRINGER AND FUSE DOUBLER REF SRM 53 00 01 FIG 201 REPAIR 12.SDR DL76S070931Bulkhead · puncturedDURING HMV AT MOE, THE AFT PRESSURE BULKHEAD SUSTAINED TOOLING DAMAGE WHICH RESULTED IN A PUNCTURE IN THE WEB.SDR DL76S070925Frame · crackedDURING HMV3, THE LT BS 903.5 INBOARD CHORD WAS FOUND CRACKED AT WL 190.SDR DL76S070962Skin · damagedDURING HMV3 AT MOBILE AREOSPACE ENGINEERING, FOUND LT FUSELAGE STA 785.9-915, S2L, S8L HAS LIGHTNING STRIKES. REMOVED DAMAGE AND FAB`D DOUBLER REF SRM 530001 REPAIR 4.SDR DL76S070963Skin · damagedLT FUSE STA 915-1065, S4-7L HAS LIGHTNING STRIKE DAMAGE. REMOVE DAMAGED AREA INSTALLED DOUBLER REF SRM 530001 REPAIR 4.SDR DL76S070938Floorbeam · corrodedDURING HMV3 FOUND AFT PIT STA 1219 UPPER CHORD CORRODED OUT OF LIMITS AT LBL 23 TO LBL 30. REMOVED DAMAGE SECTION AND REPAIRED PER SRM 53-00-07 REPAIR NR 4.SDR DL76S070937Floorbeam · corrodedDURING HMV3 AT MOBILE AEROSPACE ENGINEERING, FOUND MAIN CABIN FLOORBEAM T-CAP EXFOLIATED AT RBL 26, STA 287. REMOVED DAMAGED SECTION OF T-CAP AND REPAIRED PER SRM 53-00-51D.SDR DL76S070936Skin · dentedDURING HMV3 AT MOBILE AEROSPACE ENGINEERING, FOUND LWR FUSELAGE HAS DENT WITH OVER BURNISHED FASTENERS AT S26L STA 1562. REMOVED DAMAGE AND REPAIRED PER SRM 53-00-01 LAP SPLICE REPAIR.SDR DL76S070731Structure · corrodedDURING HMV 3 AT MAE, FOUND AFT PIT STA 1197+66 LBL 36 T CHORD CORRODED. REMOVED CORROSION FOUND TO BE OUT OF LIMITS PER SRM 53-00-07. REPAIRED PER SRM 53-00-07 REPAIR 4.SDR DL76S070589Pump · leakingRT HYD EICAS MSG RT HYDS DROPPED TO .016 THEN R HYD PUMP MSG CAME ON. OPENED UP RT ENG. FOUND RT ENG HYD PUMP LEAKING. SUSPECT ENG HYD PUMP FAILURE. PULLED RT T HANDLE. FOUND EDP CASE SEAM LEAKING. NO METAL IN CASE DRAIN OR PRESSURE FILTERS. FILTERS REPSDR DL76S061037Battery Pack · dischargedEMERGENCY PATH LIGHTS AT SEATS 13FG - 17FG DIM, 18FG, 19FG, AND 20FG INOP. REMOVED AND REPLACED BATTERY PACK ASSY.SDR DL76S060070Housing · crackedAFTER LANDING, RT HYD SYSTEM QUANTITY DROPPED TO 0, FOUND HOUSING ON BRAKE FUSE P/N V6-4360-2, RT WING BRAKE MODULE, CRACKED. REPLACED HOUSING.SDR DL76S050420Projector · odorFLT 683 ATL - MBJ DIVERSION TO MCO, STRONG ODOR MID CABIN. ELECTRICAL SMELL. FOUND MID CABIN MOVIE PROJECTOR SOURCE OF SMELL. REPLACED PROJECTOR. ALL CKS OK. NO FURTHER SMELL NOTED.SDR DL76S050419Bolt · looseRT ENG FIRE IND INTERMIT DURING CLM. S/D ENG AND ATB TO ATL.C/A FOUND 4 BOLTS LOOSE ON HPT NOZZLE COOLING DUCTS AT HPC CASE 230 AND 330 POSITION. TIGHTENED SAME. REINSTALLED RMVD LOOPS. CKD SECURITY OF ALL LOOPS. RAN ENG AT 90 PCT FOR 5 MIN AND 103 PCT FRO 5 MSDR DL76S050418Ball Joint · unknownON TAKEOFF GOT VERY RAPID INTERMITTENT R ENG FIRE WARNING. ALSO, GOT INTERMITTENT R ENG FIRE LOOP 1 STATUS MSG. FIRE WARNING GOES AWAY WHEN BELOW ABOUT 85 PERCENT N1. T/S PER FIM. FIRE AND O/H LOOP RESISTANCE VALUES NORM. RAN ENG TO TAKEOFF POWER PER PFHSDR DL76S030454Connector · damagedUPON TOUCHDOWN - NORMAL RATE APP 140 KTS. AUTOBRAKES DISARMED, AUTO SPEEDBRAKE DID NOT EXTEND UNTIL T/R EXTENDED,WHEEL BRAKES LEFT SIDE NEVER GOT ABOVE 0 INDICATION;RT SIDE BRAKES UP 5 & 6. EXITED AT EOR DUE TO BRAKING. REPLACED WHEEL ASSY 1,2,5,& 6. PERFORMSDR DL76S020544Apu · malfunctionedAFTER APU WENT TO RUN, APU ANNUNCIATED FAULT AND SHUT DOWN (ACCOMPANIED BY ACRID SMELL MOMENTS LATER). RESET APU ECU, RAN APU UNDER LOAD NO FAULTS.SDR DL76S020096Battery Pack · dischargedDURING S/C FOUND FWD RIGHT CEILING EMERGENCY LIGHTS INOP. REPLACED BATTERY PACK.SDR DL76S010172Harness · burnedON L/O FOUND SEVERAL CIRCUIT BRAKERS POPPED. T/S AND FOUND WIRE BUNDLE SHORTED AND BURNT ABOVE C-1 CARGO DOOR CEILING. REPLACED/REPAIRED APPROX 80 WIRES. INCIDENT UNDER INVESTIGATION.
Back to N130DL, cancelled May 9, 2017