N12218
Service difficulty reports · 102
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 = 'N12218' 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 = 'N12218' 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 CALA0300254Overheat Sensor · inoperativeTHE WHEEL WELL FIRE LIGHT ILLUMINATED WITH THE LANDING GEAR RETRACTED AFTER TAKEOFF FROM IAH. THE AIRCRAFT WAS RETURNED TO IAH WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND NO EVIDENCE OF FIRE. THE OVERHEAT DETECTION UNIT WAS REMOVED AND REPLACED AND SDR CALA0200220Support · crackedINSPECTION FOUND RT WING UPPER PANEL SUPPORT DIRECTLY BEHIND NR 2 ENGINE EXHAUST T/E OF WING CRACKED THROUGH. THE SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-40.
Back to N12218