N788AN
Service difficulty reports · 211
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 = 'N788AN' 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 = 'N788AN' 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 AALA20012042Connector · looseMIA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT 4G INOPERATIVE. RESECURED EMERGENCY EXIT LIGHT CONNECTOR AT SEAT 4G. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20012041Connector · damagedMIA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT SEAT 3G INOPERATIVE. REPAIRED EMERGENCY EXIT LIGHT CONNECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010401Lamp · malfunctionedDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT COACH CLASS DIM. REPLACED EMERGENCY EXIT LIGHT AT COACH CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010400Lamp · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT BUSINESS CLASS DIM. REPLACED EMERGENCY EXIT LIGHT AT BUSINESS CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010399Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT L1 DOOR DAMAGED. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT L1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010131Idg · failedORD - FLT 38 - ELEC GEN DRIVE L MESSAGE APPEARED FOLLOWED BY ELEC BACK UP GEN L. ONE RESET ATTEMPT, UNSUCCESSFUL. GENERATOR DISCONNECTED PER CHECKLIST PROCEDURE. REMOVED AND REPLACED NR 1 ENGINE IDG, BACKUP GEN AND GENERATOR CONVERTER PER MM LEAK AND OPS CHSDR AALA20001890Seal · failedMIA - FLT 991 - EN ROUTE MIA-EZE, DETECTED LOUD SQUEAL AT LEFT SIDE WINDSHIELD. SQUEAL INTERFERRED WITH COCKPIT COMMUNICATION AND RADIO COMMUNICATION WITH AIR TRAFFIC CONTROLLER. DUMPED APPROXIMTELY 80,000 LBS OF FUEL. RETURNED MIA AND LANDED WITHOUT FURTHESDR AALA20001753Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, GALLEY EMERGENCY EXIT LIGHT AT CORNER UTILITY CLOSET BROKEN. REPLACED GALLEY EMERGENCY EXIT LIGHT ASSEMBLY AT CORNER UTILITY CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001207Connector · looseDFW - DURING OVER-NIGHT MAINTENANCE, EMERGENCY EXIT ESCAPE PATH LIGHTS AT SEATS 2G AND 2D INOPERATIVE. RECONNECTED CONNECTOR AT SEATS 2G AND 2D. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR AALA20001166Light · defectiveTUL - DFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT ESCAPE PATH LIGHTS AT SEAT 26G INOPERATIVE. REPLACED EMERGENCY LIGHT AT SEAT 26G. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)SDR AALA20001061Inverter · malfunctionedORD - FLT 87 - ELECT BACKUP GEN L EICAS MESSAGE WOULD NOT RESET. REPLACED BACKUP GENERATOR CONVERTER PER MM 24-25-09-4. OPS TEST NORMAL. (M)
Back to N788AN