N676CA
Service difficulty reports · 269
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 = 'N676CA' 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 = 'N676CA' 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 ASOA2013021403011Clamp · looseICE CAUTION IN NONE ICING CONDITIONS, LT WING DUCT OVERHEAT MASTER WARNING MESSAGE, LOST PRESSURE. OXYGEN MASK DEPLOYED, DECLARED EMERGENCY. FOUND TWO LOOSE V-BAND CLAMPS LOOSE. TORQUED BOTH IAW AMM 20-30-00. OPS CHECKED GOOD ON GROUND RUNS ACFT OK FOR SERSDR COMA2012070990017Window · crackedON CLIMBOUT FROM ROC TO JFK CAPTAINS SIDE WINDOW INNER PLY CRACKED. EMERGENCY DECLARED, A/C DIVERTED BACK TO ROC LANDED SAFELY. REMOVED AND REPLACED CAPTAINS SIDE WINDOW.SDR COMA2011080490026Warning System · false activationON CLIMBOUT FROM DFW RECEIVED BLEED AIR DUCT WARNING MSG. A/C DEPRESSURIZED, EMERGENCY DECLARED. A/C RETURNED TO DFW LANDED SAFELY. INTEROGATED MDC FOUND LOOP MT 227 FLAGGED. INSPECTED LOOP MT 227 AND SURROUNDING LOOPS, NO DEFECTS NOTED. PERFORMED ANTI-ICSDR COMA2011080190025Skin · dentedDENT IN FUSELAGE ABOVE EMERGENCY LIGHT JUST AFT OF PAX DOOR. REMOVED DAMAGED AREA AND INSTALLED REPAIR DOUBLER OVER AREA IAW REO 690-53-21-214.SDR COMA2011080190022Floor Support · corrodedFS 280 FLOOR SUPPORT (CAMLOC ANGLE) CORRODED. REMOVED AND REPLACED FLOOR SUPPORT (CAMLOC ANGLE) IAW SRM 51-42-06.SDR COMA2011080190024Crossbeam · corrodedRIGHT CROSSBEAM AT FS 280 CORRODED. REMOVED AND REPLACED CROSSBEAM IAW DWG CC670-34010 REV A, SRM 51-42-06, SRM 51-42-13, AND SRM 51-42-22.SDR COMA2011080190023Crossbeam · corrodedLEFT CROSSBEAM AT FS 280 CORRODED. REMOVED AND REPLACED CROSSBEAM IAW DWG CC670-34010 REV A, SRM 51-42-06, SRM 51-42-13, AND SRM 51-42-22.SDR COMA2011080190021Post · corrodedCORROSION FOUND ON RIGHT COCKPIT ENTRY POST AT FS 280.00 AT FLOOR LEVEL. REPAIRED CORROSION AT FS 280.00 AS PER BOMBARDIER REO 690-53-11-311.SDR COMA2011080190020Bulkhead · corrodedLEFT 280.00 BULKHEAD IS CORRODED. REMOVED AND REPLACED LEFT FS 280.00 LOWER BULKHEAD (CC670-34170-3) AS PER SRM 53-11-10 REPAIR "B".SDR COMA2011080190019Bulkhead · corrodedRIGHT 280.00 BULKHEAD IS CORRODED. REMOVED AND REPLACED RIGHT FS 280.00 LOWER BULKHEAD (CC670-34170-6) AS PER SRM 53-11-10 REPAIR "B".SDR COMA2011080190018Post · corrodedCORROSION FOUND ON LEFT COCKPIT ENTRY POST AT FS 280 AT FLOOR LEVEL. CUT AWAY CORRODED AREA OF DOOR POST, FABRICATED FILLER AND DOUBLER AND INSTALLED IAW REO 690-53-11-311.SDR COMA2011080190017Sill · corrodedFLOOR SILL DIRECTLY BEHIND SERVICE DOOR HAS CORROSION. REMOVED CORROSION IAW CRJ900 SRM 51-21-06-001-A01.SDR COMA2011080190016Sill · corrodedSERVICE DOOR SILL HAS CORROSION. REMOVED CORROSION IAW CRJ900 SRM 51-21-06-001-A01.SDR COMA0880013Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT COME ON. REPLACED BATTERY PACK NR 5. (S)SDR COMA0880012Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT COME ON. REPLACED BATTERY PACK NR 4. (S)SDR COMA0880011Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT COME ON. REPLACED BATTERY PACK NR 3. (S)SDR COMA0880010Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT COME ON. REPLACED BATTERY PACK NR 2. (S)SDR COMA0880009Battery Pack · dischargedEMERGENCY LIGHTS WILL NOT COME ON. REPLACED BATTERY PACK NR1. (S)SDR COMA0880004Control Unit · faultyFLIGHT 5105- RECEIVED BRAKE OVERHEAT MESSAGE ON TAKE-OFF ROLL. ABORTED TAKE-OFF, RETURNED TO GATE WITHOUT INCIDENT. REPLACED ANTI-SKID CONTROL UNIT. NO FURTHER DEFECTS.
Back to N676CA