N794AN
Service difficulty reports · 276
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 = 'N794AN' 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 = 'N794AN' 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 AALA200802131Wire · disconnectedORD EMERGENCY LIGHT AT SEAT 13D INOPERATIVE. REPAIRED WIRE PULLED FROM CONNECTOR FOR EMERGENCY LIGHT AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802132Lens · missingORD EMERGENCY LIGHT AT SEAT 24C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200801987Lamp · inoperativeDFW EMERGENCY LIGHT AT OVERHEAD SEAT 1D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT 1D. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200801118Battery Pack · dischargedJFK - EMERGENCY LIGHTS IN COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801102Battery Pack · dischargedJFK - EMERGENCY LIGHTS IN COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800618Lens · brokenDFW - EMERGENCY EXIT LIGHT AT OVERHEAD LEFT NUMBER THREE DOOR HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD LEFT NUMBER THREE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800620Lens · damagedDFW - EMERGENCY EXIT LIGHT AT OVERHEAD LEFT SEAT ROW 11 HAS DAMAGED LENS. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD LEFT SEAT ROW 11. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800619Light · brokenDFW - EMERGENCY EXIT LIGHT AT LEFT NUMBER ONE COAT CLOSET HAS BROKEN LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE COAT CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800268Bypass Valve · inoperativeLHR INFLIGHT T131/08FEB - NOSE LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF. RETURNED TO LHR AND LANDED WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR SELECTOR BYPASS VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800049Lens · missingDFW - EMERGENCY LIGHT AT SEAT 23G HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072164Lens · inoperativeORD - EMERGENCY LIGHT AT RIGHT AISLE SEAT ROW 38 MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT RIGHT HAND AISLE SEAT ROW 83. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072077Light · inoperativeDFW - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR AT PARTITION INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR AT PARTITION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071808Lens · missingJFK - EMERGENCY LIGHT AT SEAT ROW 35G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 35G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071807Lens · missingJFK - EMERGENCY LIGHT AT SEAT ROW 20C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071350Bulb · inoperativeJFK - EMERGENCY LIGHT AT SEAT 21G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071351Lens · missingJFK - EMERGENCY LIGHT AT SEAT 21G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061141Light · missingMIA - EMERGENCY LIGHT AT AFT GALLEY LOWER RIGHT CENTER BROKEN AND LIGHT ASSEMBLY IS MISSING. REPLACED EMERGENCY LIGHT ASSEMBLY AT AFT GALLEY LOWER RIGHT HAND CENTER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060706Light · inoperativeLHR - EMERGENCY ESCAPE PATH LIGHTING IN FIRST CLASS GALLEY ADJACENT TO RIGHT NUMBER ONE DOOR HAS BROKEN LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY FOR EMERGENCY ESCAPE PATH LIGHTING IN FIRST CLASS GALLEY ADJACENT TO RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED SDR AALA20060441Battery Pack · inoperativeDFW - EMERGENCY LIGHTING BATTERY PACK ABOVE RIGHT NUMBER 3 DOOR INOPERATIVE. REPLACED FORWARD EMERGENCY LIGHT BATTERY PACK ABOVE RIGHT NUMBER 3 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050105Wire · brokenMIA - EMERGENCY LIGHT IN FIRST CLASS AT COAT CLOSET FLOOR INOPERATIVE. REPAIRED BROKEN WIRE AND REPLACED SOCKET FOR EMERGENCY LIGHT IN FIRST CLASS AT COAT CLOSET FLOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040610Light · inoperativeDFW - EMERGENCY LIGHT ON RIGHT HAND SIDE AT AFT FIRST CLASS GALLEY INOPERATIVE. REPLACED EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT RIGHT HAND SIDE AT AFT FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040515Light · brokenLHR EMERGENCY LIGHT AT FIRST CLASS GALLEY BROKEN. REPLACED EMERGENCY LIGHT UNIT AT FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20030985Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, TECHNICIAN OBSERVED EMERGENCY ESCAPE PATH LIGHTING INOPERATIVE AT THE AFT GALLEY FORWARD WALL LEFT MOUNTED LIGHT ASSEMBLY. REPLACED LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20030659Wire · inoperativeDURING OVERNIGHT MAINTENANCE, LEFT FORWARD FIRST CLASS GALLEY EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED LEFT FORWARD FIRST CLASS GALLEY EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROND CHECKED NORMAL OPERATION. (M)SDR AALA20011464Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, RIGHT FORWARD G3 GALLEY EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED RIGHT FORWARD G3 GALLEY EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20011442Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, LEFT FORWARD EMERGENCY EXIT LIGHT AT G3 GALLEY INOPERATIVE. REPLACED LIGHT ASSEMBLY AT G3 GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N794AN