N901CF
Service difficulty reports not matched to an aircraft · 309
They name N901CF, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N901CF' AND registry_match IS NULL 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 = 'N901CF' AND registry_match IS NULL 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 96ZZZX3129Link · wornLINK WORN BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1497Control Cable · failedPILOT REPORTS THAT WHILE ACTIVATING THE HEATER CABLE, THE LOCKING MECHANISM CAME FREE FROM THE CONTROL KNOB. HEATER CONFIGURATION WAS CHANGED.SDR 96ZZZX1494Nozzle Set · defectiveNOZZLE SET DEFECTIVE. SIL PW200-002. REMOVED DUE TO CARBON ACCUMULATION THAT COULD CAUSE ENGINE START DIFFICULTY. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1493Nozzle Set · defectiveNOZZLE SET DEFECTIVE. SIL PW200-002. REMOVED DUE TO CARBON ACCUMULATION THAT COULD CAUSE ENGINE START DIFFICULTY. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1492Nozzle Set · defectiveNOZZLE SET DEFECTIVE. SIL PW200-002. REMOVED DUE TO CARBON ACCUMULATION THAT COULD CAUSE ENGINE START DIFFICULTY. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1491Nozzle Set · defectiveHYBRID FUEL NOZZLE SET DEFECTIVE. SIL PW200-002. REMOVED DUE TO CARBON ACCUMULATION THAT COULD CAUSE ENGINE START DIFFICULTY. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1489Duct · crushedDUCT CRUSHED AND FAILS TO HOLD PROPER SHAPE. REPLACED WITH NEW UNIT, CORRECTED PROBLEM. (X)SDR 96ZZZX3135Exhaust Stack · crackedEXHAUST STACK CRACKED BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT, CORRECTED PROBLEM.SDR 96ZZZX1496Shield · crackedSHIELD CRACKED BEYOND SERVICEABLE LIMITS. REPLACED WTIH NEW UNIT, CORRECTED PROBLEM.
Back to N901CF