Airbus A318-111
Service difficulty reports · 353
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = 'A318111' 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 aircraft_model_key = 'A318111' 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 F3LA200400005Windshield · crackedAIR TURNBACK, FLIGHT CREW REPORTED FIRST OFFICER'S WINDSHIELD CRACKED. DECLARED AN EMERGENCY, AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED FIRST OFFICER'S WINDSHIELD PER 56-11-11-000-001 AND 56-11-11-400-001. PERFORMED TEST OF WINDOW HEAT AND DEFOGGING PER 30SDR F3LA200300177Filter · malfunctionedBLOCK TURNBACK. FLIGHT CREW REPORTED F/CTL SLAT SYS 1 FAULT. COMPLETED CONTINUITY CHECK BETWEEN SFCC NR 1 AND SLAT FFPU IAW ASM 27-81-00 SCH06 AND CHECKED GOOD. REPLACED FILTER IAW TSM ON FLAP/SLAT VALVE BLOCK NR 1 IAW MM 27-84-53-400-03.SDR F3LA200300136Power Supply · inoperativeFLIGHT CREW REPORTED SEAT BELT/NO SMOKING LIGHTS AND FWD GALLEY EXIT SIGNS INOPERATIVE. REPLACED EPSU IAW MM 33-51-13-04.
Back to Airbus A318-111