N782AN
Service difficulty reports · 219
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 = 'N782AN' 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 = 'N782AN' 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 AALA20070108Bulb · burned outMIA - EMERGENCY LIGHTS AT SEAT 3D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 3D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061069Light · brokenJFK - EMERGENCY LIGHT AT FORWARD GALLEY CLOSET BROKEN. REPLACED EMERGENCY LIGHT ASSEMBLY AT FORWARD GALLEY CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061011Light · inoperativeLHR EMERGENCY LIGHT AT FORWARD FIRST CLASS GALLEY CLOSET INOPERATIVE. REPLACED EMERGENCY LIGHT ASSEMBLY AT FORWARD FIRST CLASS GALLEY CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060649Connector · looseORD - EMERGENCY ESCAPE PATH LIGHTS IN COACH CLASS FROM SEAT ROW 34 BACK INOPERATIVE. SECURED LOOSE CONNECTOR AT ROW 35 FOR INOPERATIVE EMERGENCY ESCAPE PATH LIGHTS IN COACH CLASS FROM SEAT ROW 34 BACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060519Light · inoperativeLHR - EMERGENCY FLOOR LIGHT AT FIRST CLASS GALLEY CLOSET INOPERATIVE. REPLACED EMERGENCY FLOOR LIGHT ASSEMBLY AT FIRST CLASS GALLEY CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060410Light · damagedDFW - EMERGENCY LIGHT IN FIRST CLASS GALLEY DAMAGED. REPLACED DAMAGED EMERGENCY LIGHT IN FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050624Tire · deflatedLHR INFLIGHT T104/26SEPT - ON CLIMB-OUT, TIRE PRESSURE ADVISORY ILLUMINATED. RIGHT NOSE WHEEL INDICATED ONE PSI. LEFT NOSE WHEEL INDICATED 219 PSI. RETURNED TO LHR AND LANDED WITHOUT INCIDENT. FOUND RIGHT HAND NOSE TIRE DEFLATED. CHANGED RIGHT AND LEFT NOSDR AALA20050289Battery Pack · inoperativeDFW FIRST CLASS GALLEY EMERGENCY LIGHTS INOPERATIVE AT BULKHEAD ISLAND. REPLACED EMERGENCY LIGHT BATTERY PACK M33093 FOR FIRST CLASS GALLEY EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. CLOSED.SDR AALA20040299Compressor · stalledJFK - INFLIGHT T0167/22 AT 175K LEFT HAND ENGINE COMPRESSOR STALLED WITH LOUD BANG AND AIRCRAFT YAW. FIVE SECONDS LATER SECOND COMPRESSOR STALL AND ENGINE STARTED TO ROLL BACK. ENGINE THRUST LEFT APPEARED MOMENTARILY. THROTTLE REDUCED AND STALL CLEARED. THSDR AALA20040095Battery Pack · inoperativeDFW EMERGENCY LIGHTS AT AFT FIRST CLASS GALLEY INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT AFT FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040094Battery Pack · inoperativeDFW EMERGENCY LIGHTS AT FORWARD FIRST CLASS GALLEY INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS AT FORWRD FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040098Battery Pack · inoperativeDFW BUSINESS CLASS EMERGENCY LIGHTS ON BOTH SIDES AT ROWS 9 THROUGH 14 INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS ON BOTH SIDES AT ROWS 9 THROUGH 14. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040097Battery Pack · inoperativeDFW FIRST CLASS EMERGENCY LIGHTS ON BOTH SIDES FOR ROWS 2 THROUGH 4 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS ON BOTH SIDES FOR ROWS 2 THROUGH 4. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040096Battery Pack · inoperativeDFW EMERGENCY LIGHTS IN TOURIST CLASS ROWS 30 THROUGH 43 INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS AT ROWS 30 THROUGH 43. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20021434Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY ESCAPE LIGHT ASSEMBLY AT SEAT 39C INOPERATIVE. REPLACED EMERGENCY ESCAPE LIGHT ASSEMBLY AT SEAT 39C. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20020741Radar · malfunctionedORD - FLT 66 - WEATHER RADAR INOPERATIVE UNTIL 30 MINUTES FROM LONDON WEATHER SYSTEM ON STATUS PAGE STILL THERE. SAME PROBLEM LEAVING CHICAGO BUT AFTER IT WAS FIXED, IT WENT INOPERATIVE 20 MINUTES AFTER TO WEATHER FAIL ALSO ON NAV DISPLAY. ACCOMPLISHED SYSTESDR AALA20001158Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, LEFT FORWARD GALLEY EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. REPLACED LEFT FORWARD GALLEY EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001100Wire · brokenORD - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT ESCAPE PATH LIGHTS AT SEAT 29C INOPERATIVE. REPAIRED WIRING AT SEAT 29C. SYSTEM GROUND CHECK NORMAL OPERATION. (M)SDR AALA20001094Light · inoperativeORD - DURING OVERNIGHT MAINTENANCE, EMERGENCY LIGHT ON FORWARD GALLEY WALL INOPERATIVE. REPLACED LIGHT ASSEMBLY. SYSTEM GROUND CHECK NORMAL OPERATION. (M)
Back to N782AN