N420AN
Service difficulty reports · 55
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 = 'N420AN' 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 = 'N420AN' 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 AALA202210120741Clamp · looseAIRCRAFT WAS NOT GROUNDED: DURING A SCHEDULED SLIDE REPLACEMENT MAINTENANCE REMOVED THE L3 ESCAPE SLIDE PER TASK CARD 26L00025012 AND COULD NOT COMPLETE THE TASK DUE TO THE NEW SLIDE BEING DEFECTIVE. THE NEW SLIDE WAS RETURNED TO STORES AS BAD FROM STOCK TO BESDR AALA202208240741Slide · defectiveAIRCRAFT WAS NOT GROUNDED: DURING A SCHEDULED SLIDE REPLACEMENT MAINTENANCE REMOVED THE L3 ESCAPE SLIDE PER TASK CARD 26L00025012 AND COULD NOT COMPLETE THE TASK DUE TO THE NEW SLIDE BEING DEFECTIVE. THE NEW SLIDE WAS RETURNED TO STORES AS BAD FROM STOCK TO BESDR AALA202205127616None · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR ASSIST PRESSURE IS 1450 PSI AT 70*F. SERVICED DOOR ASSIST BOTTLE PER AMM 52-10-00.SDR AALA202205125610None · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR ASSIST PRESSURE LOW. SERVICED DOOR ASSIST BOTTLE PER AMM 52-22-00.SDR AALA202105049015Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L3 DOOR PRESSURE LOW. SERVICED L3 DOOR PER AMM 52-10-00.
Back to N420AN