N940AN
Service difficulty reports · 170
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 = 'N940AN' 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 = 'N940AN' 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 AALA20120424005Intercostal · crackedCRACKED INTERCOSTAL FROM STATIONS 227 TO 291. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120423004Floor Support · corrodedCORROSION ON FLOORBOARD SUPPORT FROM STATION 294.5 TO 312. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05-1 AND BAC DRAWING 141A5400.SDR AALA20120420005Skin · dentedSMOOTH DENT AT AFT CARGO DOOR UPPER AFT CORNER. REMOVED AND REPLACED SKIN PER ESO 60651.SDR AALA20110331DFW01Sensor · inoperativeDFW - CREW REPORTED LEADING EDGE SLAT AMBER LIGHT DURING FLIGHT. FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED SENSOR S168. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20101021TUL04Idg · failedCMH - INFLIGHT LAX-IAD. CREW REPORTED LEFT ENGINE GENERATOR FAILED AND AUXILIARY POWER UNIT WOULD NOT START. EMERGENCY DECLARED DIVERTED CMH LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT INTEGRATED DRIVE GENERATOR AND AUXILIARY POWESDR AALA20101019LAS01Buss · failedLAS - INFLIGHT DFW-SFO. CREW REPORTED LEFT GENERATOR FAILED DURING FLIGHT AND AUXILIARY POWER UNIT UNABLE TO START. EMERGENCY DECLARED FLIGHT DIVERTED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT RIGID BUSS ASSEMBLY. SYSTEM GROSDR AALA20101016TUL04Idg · failedABQ - INFLIGHT LAS-DFW. CREW REPORTED LEFT ENGINE GENERATOR FAILED AND AUXILIARY POWER UNIT WOULD NOT START. EMERGENCY DECLARED FLIGHT DIVERTED ABQ LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED INTEGRATED DRIVE GENERATOR. SYSTEM GROUND SDR AALA20100825TUL03Floorboard · puncturedAFT CARGO HAS 1 INCH HOLE IN FLOORBOARD AFT OF DOOR. REPAIRED PER AARD 53-00-00-5.SDR AALA20090722TUL01Intercostal · crackedINTERCOSTAL CRACKED AT NUT PLATE HOLE. REMOVED AND REPLACED INTERCOSTAL PER SRM 53-10-04.SDR AALA2009060700005Battery Pack · dischargedMIA - EMERGENCY LIGHT AT ROW 15 TO ROW 21 INOPERATIVE. REPLACED BATTERY PACK 5026 AT SEAT 20F.SDR AALA2009022300512Wire · damagedDFW - RIGHT FIRST CLASS DIVIDER FLOOR PROXIMITY LIGHT INOPERATIVE. REPAIRED WIRING IN SIDEWALL.SDR AALA2009022300511Lamp · burned outDFW - EMERGENCY LIGHT AT FORWARD OVERWING 13ABC INOPERATIVE. REPLACED LAMPS AT FORWARD OVERWING 13ABC.SDR AALA2009022300510Lamp · burned outDFW - EMERGENCY LIGHT AT FORWARD OVERWING 14DEF INOPERATIVE. REPLACED LAMPS AT FORWARD OVERWING 14DEF.SDR AALA200801123Lamp · brokenDFW - EMERGENCY LIGHT AT SEAT 10D HAS BROKEN LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801122Lens · missingDFW - EMERGENCY LIGHT AT SEAT 10D MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 10D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071458Battery Pack · inoperativeTUL - EMERGENCY LIGHT IN COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT IN COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071457Battery Pack · inoperativeTUL- EMERGENCY LIGHTS IN MID COACH CABIN INOPERATIVE. REPLACED BATTERY PACK AT STATION 727 FOR EMERGENCY LIGHTS AT MID COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050339Wire Harness · inoperativeDFW - SEAT MOUNTED EMERGENCY PATH LIGHTS AT ROWS 18 AND 19 INOPERATIVE. REPAIRED DAMAGED WIRES FOR SEAT MOUNTED EMERGENCY PATH LIGHT ON SEAT HARNESS AT SEAT 18DEF AND REPINNED WIRES AND SECURED IN CONNECTOR FOR SEAT MOUNTED EMERGENCY PATH LIGHT AT SEAT 19. SSDR AALA20030701Connector · inoperativeDURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT SEAT 18D INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT CONNECTOR AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20012150Light · inoperativeSFO - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT ROW 10 INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT ROW 10. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N940AN