N371CA
Service difficulty reports · 205
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 = 'N371CA' 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 = 'N371CA' 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 COMA0470079Warning Light · illuminatedFLIGHT 5500 SLAT FAIL CAUTION MESSAGE. COULD NOT DUPLICATE, OPERATIONAL CHECK SATISFACTORY.SDR COMA0470045Control Unit · malfunctionedFLIGHT 2780 SLATS FAIL CAUTION MESSAGE. RESET THE SECUS, SYSTEM TEST SATISFACTORY.SDR COMA0470038Warning System · false activationFLIGHT 5291 FLIGHT SPOILER AND SPOILERON CAUTION MESSAGE. COULD NOT DUPLICATE RESET CONTROL UNITS. SYSTEM OPERATION NORMAL.SDR COMA0370049Bulkhead · crackedFS 1098.20 BULKHEAD RIGHT WEB BETWEEN STRINGERS 8R AND 9R IS CRACKED. REPAIRED BY REMOVING DAMAGE AND INSTALLING A BATHTUB FITTING IAW BOMBARDIER, INC REO 670-53-61-034 REV B.SDR COMA0370015Valve · faultyFLIGHT 5071 DURING CLIMB OUT RECEIVED A GEAR DISAGREE WARNING WHEN GEAR WAS SELECTED UP, AIRCRAFT RETURNED TO THE FIELD. REPLACED THE LANDING GEAR SELECTOR VALVE.
Back to N371CA