N678CA
Service difficulty reports · 214
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 = 'N678CA' 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 = 'N678CA' 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 COMA2011040490004Bulkhead · corrodedFS 280 RT LOWER BULKHEAD WEB AT CABIN FLOOR LINE CORRODED. REMOVED LOWER SECTION OF FS 280 RT BULKHEAD WEB, FABRICATED AND INSTALLED NEW SECTION IAW SRM 53-11-10-201-003-A01.SDR COMA2011040490003Bulkhead · corrodedFS 280 LT LOWER BULKHEAD WEB AT CABIN FLOOR LINE CORRODED. REMOVED LOWER SECTION OF FS 280 LT BULKHEAD WEB, FABRICATED AND INSTALLED NEW SECTION IAW SRM 53-11-10-201-003-A01.SDR COMA2011030790002Selector Valve · failedON APPROACH INTO BHM RECEIVED GEAR DISSAGREE MSG. EMERGENCY DECLARED, PERFORMED MANUAL GEAR EXTENSION. A/C LANDED SAFELY. REMOVED AND REPLACED MLG SELECTOR VALVE. OPS CHECK GOOD.SDR COMA2010102890013Panel · crackedPAX DOOR FWD SIDE PANEL CRACKED IN ZONE 2. REPAIRED PAX DOOR FWD SIDE ZONE 2 BY REMOVING DAMAGE AND INSTALLING DOUBLER IAW REO 670-52-11-104.SDR COMA2010091590011Selector Valve · failedON APPROACH INTO MEM RECEIVED GEAR DISAGREE MSG. FOLLOWED QRH, EMERGENCY DECLARED. A/C LANDED SAFELY. REMOVED AND REPLACED MAIN LANDING GEAR SELECTOR VALVE.SDR COMA2010072990006Pseu · faultyON APPROACH INTO JFK WHEN LANDING GEAR WAS SELECTED DOWN GEAR DID NOT EXTEND, RECEIVED GEAR DISAGREE. EMERGENCY DECLARED, FOLLOWED QRH ALL GEAR EXTENDED MANUALLY. A/C LANDED SAFELY. REMOVED AND REPLACED PSEU. NO FURTHER DEFECTS NOTED.SDR COMA2009061590011Warning System · activatedON FINAL APPROACH INTO CVG RECEIVED FLAPS FAIL CAUTION MSG. EMERGENCY DECLARED, A/C LANDED SAFELY. CLEARED INHIBITS PER FIM 27-50-00, MSG CLEARED. OPS CHECK GOOD, NO FURTHER DEFECTS NOTED.SDR COMA2009051290008Sensor · faultyEN ROUTE FROM CHS TO ATL RECEIVED LEFT BLEED DUCT WARNING MSG. EMERGENCY DECLARED, A/C RETURNED TO CHS LANDED SAFELY. REMOVED AND REPLACED LEFT BLEED TEMP SENSOR.SDR COMA2009051190007Sensing Element · faultyEN ROUTE FROM IAH TO JFK RECEIVED LEFT BLEED DUCT MSG. EMERGENCY DECLARED, A/C DIVERTED TO AEX LANDED SAFELY. REMOVED AND REPLACED SENSING ELEMENT MT 225.SDR COMA2009012070011Door · openAC POWER DOOR LEFT OPEN, A/C RETURNED TO JFK LANDED SAFELY. INSPECTED AC POWER DOOR, NO DEFECTS NOTED. SECURED DOOR CLOSED.SDR COMA0880015Door · openAFTER T/O LOUD NOISE COMING FROM NOSE AREA, SUSPECTED EXTERNAL ACCESS PANEL LEFT OPEN. EMERGENCY DECLARED, A/C RETURNED BACK TO IAH AND LANDED SAFELY. INSPECTED A/C AND FOUND EXT PWR RECEPTACLE DOOR OPEN. INSPECTED DOOR NO DEFECTS NOTED, CLOSED DOOR.SDR COMA0880008Landing Gear · malfunctionedFLIGHT 5099 - GEAR DISAGREE MESSAGE RECEIVED ON CLIMB. NOSE GEAR NOT RETRACTING. DECLARED EMERGENCY, FOLLOWED QRH, RETURNED TO CVG, ALL GEAR SHOWED GREEN, LANDED WITHOUT INCIDENT. VISUALLY INSPECTED NOSE GEAR, PERFORMED EXTENSION AND RETRACTION CHECKS. NO SDR COMA0880007Loop · out of positionFLIGHT 5056- ON CLIMB-OUT FROM AUS TO ATL, RECEIVED LEFT BLEED DUCT WARNING MESSAGE. EMERGENCY DECLARED AND A/C RETURNED BACK TO AUS AND LANDED SAFELY. REPOSITIONED INSULATION AND LOOPS AT HP GROUND DUCT. OPS CHECK GOOD.SDR COMA0880005Ecu · malfunctionedFLIGHT 5210 - ON APPROACH INTO CVG RECEIVED NOSE WHEEL STEERING INOP CAUTION MESSAGE. EMERGENCY DECLARED, AIRCRAFT LANDED SAFELY. RESET NOSE WHEEL STEERING SYSTEM C/B'S AND ECU. OPS CHECK GOOD.
Back to N678CA