N778AN
Service difficulty reports · 286
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 = 'N778AN' 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 = 'N778AN' 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 AALA200800294Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 39G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 39G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800286Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 22G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800295Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 32C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 32C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800292Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 39C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 39C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800293Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 40G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 40G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800289Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 26G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800297Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 38C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 38C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800296Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 36C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 36C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800291Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 35G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 35G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800161Lens · missingDFW - EMERGENCY LIGHT AT SEAT 33G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 33G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800160Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 33G INOPERATIVE. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 33G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072505Lamp · inoperativeMIA - EMERGENCY LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072504Lens · brokenMIA - EMERGENCY LIGHT AT SEAT 23G LENS BROKEN. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072503Lamp · inoperativeMIA - EMERGENCY LIGHT AT SEAT 23G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072502Lamp · looseMIA - EXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR INOPERATIVE. RESEATED LAMP FOR EXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072092Lens · missingDFW - EMERGENCY LIGHT AT SEAT 26C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072091Lamp · inoperativeMIA - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071757Slide · dislodgedNRT - RIGHT NUMBER TWO DOOR SLIDE/RAFT INADVERTENTLY DROPPED FROM HOUSING. DID NOT DEPLOY. NRT UNABLE TO REPLACE. PLACARDED AND BLOCKED SEATS ON OUTBOUND. SLIDE REPLACED AT LAX. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071309Slide · disengagedRDU - EMERGENCY SLIDE AT RIGHT NUMBER TWO DOOR FELL OFF DOOR AND FELL SIX INCHES ONTO CATERING TRUCK. CATERING TRUCK PREVENTED SLIDE FROM DEPLOYING. REPLACED EMERGENCY SLIDE AT RIGHT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070317Lens · missingDFW - FOUND EMERGENCY LIGHTS AT SEAT 21C HAS LENS MISSING. RELAMPED AND REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070319Bulb · burned outDFW - FOUND EMERGENCY LIGHTS AT SEAT 26C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070318Lens · missingDFW - EMERGENCY LIGHTS AT SEAT 23C HAS LENS MISSING. RELAMPED AND REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070631Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK AT AFT COACH SEATS M33401 FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK AT AFT COACH SEATS M33401. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070630Battery Pack · inoperativeAFW - EMERGENCY LIGHT BATTERY PACK FOR BUSINESS CLASS SEATS M33098 FAILED FUNCTIONAL TEST. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT BUSINESS CLASS SEATS M33098. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060746Bulb · inoperativeMIA - EMERGENCY LIGHTS AT SEATS 5B, 10B, 20B, AND 35B INOPERATIVE. RELAMPED EMERGENCY LIGHTS AT SEATS 5B, 10B, 20B, AND 35B. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050716Battery Pack · inoperativeJFK - EGRESS EMERGENCY LIGHTS IN AFT CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EGRESS EMERGENCY LIGHTS IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20021292Sign · brokenDFW - DURING OVERNIGHT MAINTENANCE EMERGENCY EXIT INDICATOR LIGHT AT DOOR 1R AFT BROKEN. REPLACED LIGHT ASSEMBLY AT 1R AFT DOOR. SYSTEM GROUND CHECKED NORMAL OPERATIONS. (M)SDR AALA20021211Idg · failedDFW - RIGHT GENERATOR DRIVE SHAFT DISCONNECTED IN FLIGHT. DEFERRED RIGHT IDG DUE TO NS AT LGW OF OIL PRESS CANNON PLUGS MEL REF 24-03. RIGHT ENGINE IDG WAS REPLACED 8-16-02 LEAK AND OPS CHECKED NORMAL. (M)SDR AALA20021162Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, L1 COAT CLOSET EMERGENCY LIGHT BROKEN. REPLACED L1 COAT CLOSET EMERGENCY LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20011826Idg · failedAFTER HALF HOURS FLIGHT GOT ELEC GENERATOR OFF RIGHT, AFTER A SHORT TIME GOT ELEC GEN DRIVE RT GEN DRIVE DISCONNECTED. DEFERRED RIGHT IDG AS PER MEL 24-03 AUTH NB LGW9-67DC-A. PERFORMED MPM 24-03 PROCEDURE INSTALLED PLACARD ITEM TRANSFERRED TO MIC SHEET. RESDR AALA20002134Terminal · damagedDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT CLOSET INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT TERMINAL END AT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20002013Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, WALL MOUNTED EMERGENCY EXIT LIGHT AT LEFT SIDE DOOR BROKEN. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001711Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT CLOSET LIGHT AT L1 DOOR INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT L1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001695Oven · odorLHR - FLT 86 - EN ROUTE ORD-LHR, DETECTED ELECTRICAL SMELL NEAR G6 GALLEY AND 3R DOOR. LANDED LHR WITHOUT INCIDENT. CLEANED CABIN OVENS. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20000689Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY FLOOR PROXIMITY LIGHT ON LEFT SIDE OF FORWARD GALLEY INOPERATIVE. REPLACED EMERGENCY FLOOR PROXIMITY LIGHT ON LEFT SIDE OF FORWARD GALLEY. SYSTEM GROUND EHECK, NORMAL OPERATION. (X)SDR AALA991570Circuit Breaker · defectiveDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHTS IN FIRST CLASS ILLUMINATED WITH THE SWITCH IN THE ARMED POSITION. REPLACED EMERGENCY EXIT LIGHT CIRCUIT BREAKER FOR FIRST CLASS. SYSTEM GROUND CHECKED, NORMAL OPERATION. (X)
Back to N778AN