N972EV, cancelled Jul 22, 2024
Service difficulty reports · 84
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 = 'N972EV' AND deregistration_id = 'N972EV-2024-07-22' 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 = 'N972EV' AND deregistration_id = 'N972EV-2024-07-22' 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 ASOA2013082308903Lamp · burned outLEFT AFT EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP IAW AMM 33-51-21. OPS CHECKED GOOD.SDR ASOA2013071208628Light · brokenEMERGENCY FLOOR LIGHT AT PAX DOOR BROKEN. R & R EMERGENCY FLOOR LIGHT AT PAX DOOR IAW AMM 33-51-19.SDR ASOA2013061803827Lamp · burned outLEFT FWD OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP IAW AMM 33-51-21. OPS CHECKED OK.SDR ASOA2013050603475Bulkhead · crackedLEFT SIDE FS 202 PRESSURE BULKHEAD CRACKED AT PARKING BRAKE CABLE HOLE. REPAIRED IAW REO 601R-53-11-563.SDR ASOA2012122002686Engine · malfunctionedRT ENGINE VIBRATION, ITT SPIKE, AND LOOSE OF POWER AT ROTATION. FOLLOWED QRH AND RETURNED FOR LANDING. EMERGENCY DECLARED, ACFT RETURNED. R & R NR 2 ENGINE.SDR ASOA2012081002055Lamp · burned outNR 3 CABIN CEILING EMERGENCY FLOOD LIGHT INOP. RELAMPED NR 3 CABIN EMERGENCY FLOOD LIGHT IAW AMM 33-51-16, OPS CHECKED GOOD.SDR ASOA2012072701986Control Unit · failedFLAPS FAILED AT ZERO DEGREES, PRECEDED BY FLAPS HALF SPEED IN ROUTE. EMERGENCY DECLARED. R & R FECU IAW AMM 27-51-05. FLAPS OPS TESTED GOOD IAW AMM 27-54-00. NO FURTHER DEFECTS NOTED.SDR ASOA201201546Engine · failedLEFT ENGINE FAILED ON DESCENT, ATTEMPTED ONE RESTART, WOULD NOT RESTART. COMPLIED WITH WO 246732, LEFT ENGINE CHANGE. ACFT RETURNED TO SERVICE.SDR ASOA201201291Battery · dischargedEMERGENCY LIGHTS DO NOT COME ON. FOUND F/A EMERGENCY LIGHT SWITCH IN THE ON POSITION. RECHARGED BATTERIES USING WITH A/C ELEC SYSTEM. SYSTEM RESET. IAW MCC, NO FURTHER ACTION REQUIRED AT THIS TIME.SDR ASOA201200514Charger · malfunctionedLEFT OVERWING EMERGENCY LIGHT IS ON ALL THE TIME. FOUND NR 2 BATTERY CHARGER DEFECTIVE AND BLEEDING THROUGH TO THE LT O/W EMERGENCY LIGHT. REPLACED THE NR 2 CHARGER ASSY IAW AMM TASKS 33-51-05-000-801 AND 33-51-05-400-801. TESTED GOOD IAW AMM TASK 33-51-04-7SDR ASOA201200554Floorbeam · corrodedFLOORBEAM AT FS 349.00 RT SIDE OF FUSELAGE RBL 36.0 IS CORRODED BEYOND LIMITS. REPAIRED IAW SRM.SDR ASOA201200494Bulkhead Web · crackedFOUND REAR PRESSURE BULKHEAD WEB HAS A CRACK INDICATION NOTED AT LBL 27.50, WL 130 APPROX .3 INCHES IN LENGTH 100 PERCENT FSH, FAILED NDT INSPECTION. REPAIRED IAW REO 601R-53-61-1541.SDR ASOA201200427Angle · corrodedANGLE CORRODED. REPAIRED IAW REO 601R-53-11-136.SDR ASOA201200425Floorbeam · corrodedREMOVED FLOORBEAM CAP ANGLE OTBD SIDE OF FLOORBOARD SUPPORT STRUCTURE OF FS 349.00. RBL 36. REINSTALLED FLOORBEAM STRUCTURE AT FS 349, RBL 36.0 IAW SRM 51-42-06 AND 51-42-21.SDR ASOA201200462Angle · corrodedSERVICE DOOR LOWER SILL ANGLE CORRODED. REMOVED SERVICE DOOR SILL ANGLE ASSY IAW SRM 51-42-06 & 51-42-21. DRILLED & LOCATED NEW SERVICEABLE ANGLE IAW SRM 51-42-06 & 51-42-21. INSTALLED SERVICE DOOR LOWER SILL ANGLE IAW SRM 51-42-06, 51-41-21 & 51-42-36.SDR ASOA201200451Attach Fitting · corrodedSERVICE DOOR SILL PLATE ANGLE ATTACHMENT FITTING AT FS 319.70 IS CORRODED. REPLACED SILL PLATE ANGLE 601R3669-49.SDR ASOA201200449Floor Support · corrodedCABIN FLOOR SUPPORT AND SILL PLATE RT SIDE BETWEEN FS 310.00 AND FS 319.70 IS CORRODED AT RBL 42.0. REMOVED CABIN FLOOR SUPPORT AND SILL PLATE IAW SRM 51-42-06 AND 51-42-21. DRILLED & LOCATED NEW SERVICEABLE FLOOR SUPPORT 601R31148-79 AND ANGLE 601R3669-49 ISDR ASOA201200447Nut · missingPANEL 272 BRW LAVATORY SEAT HINGE MISSING NUT & MISSING 3 STUDS & HARDWARE. INSTALLED SERVICEABLE TOILET SEAT NUT IAW CMM 25-40-01. INSTALLED SERVICEABLE BALL STUDS 3 EA AND HARDWARE IAW CMM 25-40-01.SDR ASOA20120206429Seat Track · corrodedCABIN FLOOR FWD SEAT TRACK AT RBL 9 CORRODED AT FS 364.00. REMOVED CORRODED SEAT TRACK AND INSTALLED NEW SERVICEABLE SEAT RAIL IAW AMM TASKS 53-01-11-000-802 AND 53-01-11-400-802.SDR ASOA20120206427Floorbeam · corrodedFS 280.00 FWD AND AFT "J" ANGLES ARE CORRODED BETWEEN LBL 9 AND RBL 9. (SDR OPEN)SDR ASOA20120206425Floorbeam · corrodedFLOORBEAM SUPPORT STRUCTURE AT FS 349.00 RT SIDE OF FUSELAGE, RBL 36.0 IS CORRODED BEYOND LIMITS. (OPEN)SDR ASOA2012020600423Intercostal · crackedFS 621.00 TO FS 625.00 INTERCOSTAL ANGLE CRACKED AT RBL 45 AND LBL 45 AT STR 14 WL 97.5. REMOVED INTERCOSTAL ANGLE. INSTALLED INTERCOSTAL ANGLE IAW SRM 51-42-21.SDR ASOA201200421Bracket · brokenBROKEN ISOLATOR BRACKET ON FWD SIDE OF FS 621 BULKHEAD. R & R ISOLATOR IAW SRM 51-42-06.SDR ASOA201200419Floorbeam · crackedRT FS 484.00 FLOORBEAM REPAIR ANGLE AT RBL 36.0 IS CRACKED. REPAIRED FLOORBEAM ANGLE IAW REO 601R-53-41-059.SDR ASOA201200417Angle · crackedFS 280.00 ANGLE OTBD OF RBL 9 IS CRACKED. LOCATED FASTENER HOLES IN NEW FS 280, RBL 9.0 OTBD ANGLE. INSTALLED ANGLE IAW SRM 51-42-06 & 51-42-21.SDR ASOA201200445Support · crackedAFT EQUIPMENT COMPARTMENT, RT HEAT EXCHANGER SUPPORT STRUCTURE UNDER ACM CROSSBEAM ANGLE CRACKED. FIT, DRILLED & INSTALLED NEW BEAM, IAW SRM 51-42-06, 51-40-11.SDR ASOA201101019Ecu · failedFLAPS FAIL CAUTION MESSAGE, FLAPS AT 0 DEGREES, 12000' IN CLIMB, 290KTS. (DECLARED EMERGENCY AS A PRECAUTION) COMPLIED WITH EC/TC AD 2009-06-12 AND RESET FECU IAW FIM 27-51-05. SYS OPS CK GOOD AT THIS TIME. (CLOSED)SDR ASOA201100452Light · malfunctionedEMERGENCY LIGHTS WILL NOT GO OUT. CYCLED SWITCH SEVERAL TIMES, OPS CK GOOD IAW AMM 200 33-51-00. (CLOSED)SDR ASOA201100271Sensor · out of adjustGEAR DISAGREE JUST AFTER T/O NOSE GEAR REMAINED DOWN & GREEN, MAINS RETRACTED AS NORMAL. EMER DECLARED, RETURNED TO DEPARTURE. (ACFT RETURNED TO DEPARTURE AFTER T/O -- DECLARED EMERGENCY) ADJUSTED NLG (WOFW) SENSORS IAW AMM 32-61-05. OPS CHECK GOOD. (CLOSESDR ASOA201100255Placard · deterioratedPLACARD ABOVE DOOR OPENING IN FRONT ENTRY WAY IS BLANK. REPLACED MISSING PLACARD IAW SUPPLIMENT 11-30-00.SDR ASOA201001850Lamp · burned outNR7 LT AFT EXTERIOR EMERGENCY LIGHT INOP. RELAMPED NR7 LT AFT EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-21, OPS CHECK GOOD. RELAMPED NR7 LT AFT EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-21, OPS CHECK GOOD.SDR ASOA201001694Bleed Air Sys · odorON APPROACH, HAD A BURNING ODOR IN FRONT OF ACFT. SWAPED BLEEDS TO APU ODOR WAS DIMINISHED IMMEDIATELY. C/W OPS CHECK OF BOTH ENGINES IAW AMM 71-00-00. OPS CK GOOD. NO DEFECTS NOTED. (CLOSED)SDR ASOA201000746Wire · misinstalledGALLEY EMERGENCY "EXIT" LIGHT SIGNS INOP. FOUND SVC DOOR PROX. EXIT SIGN AND SVC DOOR EXIT SIGN WIRES SWAPPED. INSTALLED CORRECTLY IAW AMM 33-61-05. OPS CK GOOD.SDR ASOA201000628Light · brokenFLOOD LIGHT, FLOOR LEVEL EMERGENCY AT PAX DOOR DOOR BROKEN. FLT 5156, DEL 26 MINS. R & R LIGHT BACKING HSG IAW AMM 33-51-19. (CLOSED)SDR ASOA201000519Cargo Track · corrodedNR 4 FLOOR TRACK IN AFT CARGO AREA HAS SPOTS OF CORROSION. R & R NR 4 FLOOR TRACK CORRODED SECTION IAW AMM 53-01-11. (CLOSED)SDR ASOA201000518Cargo Track · corrodedNR 3 FLOOR TRACK IN AFT CARGO AREA HAS SPOTS OF CORROSION. R & R CORRODED SECTIONS OF NR 3 CARGO FLOOR TRACK IAW AMM 53-01-11. (CLOSED)SDR ASOA201000517Cargo Track · corrodedNR 2 FLOOR TRACK PUCS IN AFT CARGO AREA HAS SPOTS OF CORROSION. R & R BULKHEAD ATTACH FITTING IAW AMM 53-01-11.SDR ASOA201000516Cargo Track · corrodedNR 2 FLOOR TRACK IN AFT CARGO AREA HAS SPOTS OF CORROSION. R & R CORRODED SECTIONS OF NR 2 CARGO FLOOR TRACK IAW AMM 53-01-11. (CLOSED)SDR ASOA201000515Cargo Track · corrodedNR 1 FLOOR TRACK PUCS IN AFT CARGO AREA HAS SPOTS OF CORROSION. R & R PUCKS IAW SRM 51-40-00.SDR ASOA201000514Floor Support · corrodedNR 1 FLOOR TRACK IN AFT CARGO AREA HAS SPOTS OF CORROSION. R & R NR 1 FLOOR TRACK CORRODED SECTION IAW AMM 53-01-11. (SDR CLOSED)SDR ASOA201000491Frame · crackedSTA 718 BETWEEN STR 10 AND 11 RT, FRAME FLANGE IS CRACKED. REPAIR TO BE C/W ON CARD S/B 601R-53-055.SDR ASOA201000480Attach Fitting · crackedBS 280 FRAME CLIP AT RBL9 IS CRACKED. REMOVED CRACKED FRAME CLIP & REPLACED WITH NEW AT STA 280, RBL 9, IAW SRM 53-21-43.SDR ASOA201000479Attach Fitting · crackedBS 280 FRAME CLIP AT LBL9 IS CRACKED. REMOVED CRACKED FRAME CLIP & REPLACED WITH NEW AT STA 280, LBL 9 IAW SRM 53-21-43.SDR ASOA201000478Bracket · crackedANGLE BRACKET CRACKED AT FS625.30 AND S14L. R & R ANGLE BRACKET AT FS 625.30 & STR 14L IAW SRM 51-40-11.SDR ASOA201000424Bulkhead · crackedREAR PRESSURE BULKHEAD IS CRACKED AT LINTEL FITTING. ACCOMPLISHED LINTEL FITTING/ AFT PRESSURE BULKHEAD REPAIR IAW PL601R-53-61-1230, C/W RII OF REAR PRESSURE BULKHEAD LINTEL FITTING.SDR ASOA201000412Attach Angle · crackedPAX DOOR ATTACH ANGLE CRACKED AT BELL CRANK. HFEL INSP VERIFIED ONLY PAINT CRACKED, NO EXISTING CRACK IN ANGLE IAW NDTM PT. 6, 51-20-06.SDR ASOA201000379Battery Pack · inoperativeSEVERAL LIGHTS FROM NR 3 EMERGENCY BATTERY PACK NOT FUNCTIONING . R & R NR 3 EMERGENCY BATTERY PACK IAW AMM 33-51-04. OPS CHECK GOOD. R & R NR 3 EMERGENCY BATTERY PACK IAW AMM 33-51-04. OPS CHECK GOOD.SDR ASOA201000164Sensing Element · failedANTI ICE DUCT WARNING ILLUMINATED IN FLIGHT. (EMERGENCY DECLARED). REMOVED AND REPLACED SENSING ELEMENT A40WK IN RT WHEEL BIN IAW AMM 36-21-04. OPS CK GOOD.SDR ASOA200901469Placard · missingEXIT SIGN ON BOARDING STAIRS MISSING.SDR ASOA200901031Thrust Reverser · warning lightL REV UNLOCKED CAUTION MSG AFTER T/O NO CHANGE NOTICIED IN ACFT PERFORMANCE [EMERGENCY DECLARED -- ACFT RETURNED TO DEPARTURE AFTER T/O]( THRUST REVERSER SYSTEMS ).
Back to N972EV, cancelled Jul 22, 2024