N625CA
Service difficulty reports · 160
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 = 'N625CA' 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 = 'N625CA' 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 COMA0670149Beam · corrodedFS 280 TRANSVERSE BEAM CORRODED BEYOND REPAIRABLE LIMITS. REPLACED THE TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER REO 670-53-11-047, REV D.SDR COMA0670148Bulkhead · corrodedFS 280 LEFT BULKHEAD CORRODED BEYOND REPAIRABLE LIMITS. REPLACED THE LEFT BULKHEAD AT FS 280 IAW BOMBARDIER REO 670-53-11-052, REV A.SDR COMA0670147Bulkhead · corrodedFS 280 RIGHT BULKHEADS CORRODED BEYOND REPAIRABLE LIMITS. REPLACED THE RIGHT BULKHEAD AT FS 280 IAW BOMBARDIER REO 670-53-11-052-2, REV A.SDR COMA0570109Reservoir · overtempFLIGHT 5416 - HYDRAULIC SYSTEM 3 OVERTEMP. REPLACED THE SYSTEM 3 HYDRAULIC RESERVOIR.SDR COMA0570042Actuator · malfunctionedFLT 5165 SLATS FAIL CAUTION. REPLACED THE LEFT NR 2 SLAT ACTUATOR.SDR COMA0470050Door · noisyFLIGHT 5794 FLIGHT CREW HEARD THUD/BANG NOISE FROM CABIN DOOR AREA. INSPECTED CABIN DOOR AREA, PRESSURIZED AIRCRAFT, NO DEFECTS FOUND.SDR COMA0470042Acm · smokeFLIGHT 9484 DURING CVG APPROACH ON FERRY FLIGHT, CREW REPORTED SIGNS OF SMOKE IN CABIN. PERFORMED A VISUAL INSPECTION OF CABIN AND COCKPIT LIGHTING. PERFORMED GROUND RUNS AND TAXI, PRESSURIZED AIRCRAFT. NO DEFECTS OR SIGNS OF SMOKE.SDR COMA0370057Light · defectiveFLIGHT 5523 SMOKE IN COCKPIT COPILOTS SIDE. REPLACED THE COPILOT FLOOD LIGHT ASSY.SDR COMA0370036Bulkhead · crackedFS 1098.20 BULKHEAD RT WEB BETWEEN STRINGERS 8R AND 9R IS CRACKED. REPAIRED BY REMOVING DAMAGE AND INSTALLING A BATHTUB FITTING IAW MFG REO 670-53-61-034 REV B.SDR COMA0370031Window · crackedFLIGHT 5043 PILOTS SIDE WINDOW CRACKED. REPLACED SIDE WINDOW.
Back to N625CA