N972AN
Service difficulty reports · 207
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 = 'N972AN' 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 = 'N972AN' 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 AALA20071403Ballast · inoperativeMIA - EMERGENCY LIGHT AT SEAT 13A SIDEWALL AT OVERHEAD EMERGENCY DOOR INOPERATIVE. REPLACED BALLEST FOR EMERGENCY LIGHT AT SEAT 13A SIDEWALL AT OVERHEAD EMERGENCY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060361Battery Pack · dischargedMIA - EMERGENCY LIGHT ON THE RIGHT SIDE OVERWING POSITION AFT LOCATION INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT ON THE RIGHT SIDE OVERWING POSITION AFT LOCATION. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060244Wire · damagedMIA - EMERGENCY LIGHTS AT ROW 11 INOPERATIVE. REPAIRED WIRES AND REPLACED LENS FOR EMERGENCY LIGHTS AT ROW 11. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040529Wire · inoperativeMEX LEFT FORWARD OVERWING EMERGENCY LIGHTS CAME ON WITH NO POWER. REPLACED SPLICE SP828 CONNECTING WIRES W3142043720 WITH W3142PB AS PER STANDARD WIRING PRACTICE MANUAL. PERFORMED PROXIMITY SWITCH ELECTIC UNIT BITE FOR LEFT FORWARD OVERWING EMERGENCY LIGHTSSDR AALA20040462Slide · failedTUL - EVACUATION SLIDE AT FORWARD ENTRY DOOR FAILED TO DEPLOY AUTOMATICALLY OR MANUALLY. REPLACED EVACUATION SLIDE AT FORWARD ENTRY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040100Transmitter · inoperativeORD INFLIGHT T576/19 LEADING EDGE FLAPS TRANSIT LIGHT REMAINED ON DURING FLAP EXTENSION. TRAILING EDGE FLAP INDICATOR STUCK BETWEEN 0 AND 1. RECYCLED WITHOUT CORRECTING. LOWERED TRAILING EDGE FLAPS USING ALTERNATE MEANS. EMERGENCY DECLARED. LANDED WITHOUTSDR AALA20031168Control Unit · inoperativeON APPROACH TO DFW FLAPS FAILED TO DEPLOY HYDRAULICALLY. CREW ACCOMPLISHED NO FLAP LANDING WITHOUT INCIDENT. REPLACED FLAP/SLAT ELECTRIC UNIT. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N972AN