N973AN
Service difficulty reports · 213
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 = 'N973AN' 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 = 'N973AN' 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 AALA2009033100691Lens · missingDFW EMERGENCY EXIT LIGHT AT SEAT 17D MISSING LENS. REPLACED LENS FOR EMERGENCY EXIT LIGHT AT SEAT 17D.SDR AALA20072521Shroud · damagedDFW - EMERGENCY LIGHT AT SEAT 19D HAS DAMAGED SHROUD. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 19D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071999Overheat Loop · inoperativeDFW INFLIGHT T1847/20OCT - MASTER CAUTION AND RIGHT WING BODY OVERHEAT LIGHT ILLUMINATED. AIRCRAFT TAKEN OUT OF SERVICE FOR EVALUATION. REPLACED LOOP M1763 AT RIGHT ENGINE PYLON. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071797Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN MID CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT MID CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071796Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN MID CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT MID CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070637Battery Pack · inoperativeTUL- EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070638Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070636Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060110Compressor · stalledSERIES OF COMPRESSOR STALLS ON NR 2 ENGINE AT ROTATION THROUGH CLIMB. WOULD NOT CLEAR IN POWER REDUCTIONS. REPORTS OF ENGINE FIRE FROM AIR TRAFFIC CONTROL AND FLIGHT ATTENDANTS. ENGINE FIRE SEVERE DAMAGE CHECKLIST COMPLETED. RETURNED TO SJO AND LANDED WITHSDR AALA20060111Acquisition Unit · vibrationMIA - LEFT ENGINE VIBRATION INCREASED TO 4.3 AT 100 PERCENT N1. HIGH FREQUENCY VIBRATION FELT IN ENTIRE COCKPIT WITH LOUD HUMMING NOISE. REMOVED AIRCRAFT FROM SERVICE. ENGINEERING ORDERED FLIGHT DATA RECORDER DOWNLOAD. ACCOMPLISHED LEFT HAND ENGINE FAN BALSDR AALA20050593Battery Pack · inoperativeTUL EMERGENCY LIGHTS AT AFT LEFT GALLEY (STATION 967), FIRST CLASS SEATS (STATION 328), AND MID CABIN (STATION 727) FAILED OPERATIONAL CHECK. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN AFT LEFT GALLEY, FIRST CLASS SEATS, AND MID CABIN. SYSTEM GROUND CHECSDR AALA20041205Battery Pack · inoperativeORD - EMERGENCY LIGHT IN CABIN FAILED TEST. REPLACED FIVE BATTERY PACKS FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040427Battery Pack · inoperativeBOS - EMERGENCY LIGHTS IN FORWARD COACH SECTION INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT FORWARD COACH SECTION. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N973AN