N391CA
Service difficulty reports · 270
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 = 'N391CA' 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 = 'N391CA' 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 COMA0770062None · noneFLIGHT 5506 - RECEIVED ANTI-ICE DUCT WARNING AND RIGHT FUSELAGE DUCT RED ON SYNOPTIC PAGE. DECLARED EMERGENCY, PERFORMED QRH AND LANDED WITHOUT INCIDENT. RAN BOTH ENGINES AND PERFORMED OPS CHECK OF ANTI-ICE SYSTEM. NO FURTHER DEFECTS.SDR COMA0770045Altimeter · erraticFLIGHT 5257 - AFTER TAKEOFF RADAR ALTIMETER BECAME ERRATIC, FLUCTUATING FROM 300 TO 3000 FT. A TERRAIN ALERT WAS ALSO RECEIVED AT ABOUT 2000 FT. AIRCRAFT LANDED SAFELY BACK AT CVG. COULD NOT DUPLICATE ON GROUND. OHMED AND MEGGED CABLES, NO DEFECTS NOTED.SDR COMA0670185Fan Blade · vibratesFLIGHT 5617 - EN ROUTE JAN-BOS DURING CLIMB ENCOUNTERED VIBRATION FROM THE LEFT ENGINE, FLIGHT DIVERTED TO CVG. REPLACED THE LEFT ENGINE FAN BLADES.SDR COMA0670155Control Unit · faultyFLIGHT 5212 - DURING CLIMBOUT OF SAT RECEIVED A RUDDER LIMITER FAULT MESSAGE, FLIGHT RETURNED TO THE FIELD. REPLACED SSCU NR 2.SDR COMA0670151Warning Message · illuminatedFLIGHT 5867 - AFTER TAKEOFF RUDDER LIMITER CAUTION MESSAGE AND RUDDER FAULT MESSAGE APPEARED, STAYED ON. RETURNED FOR LANDING PER QRH. PERFORMED SPOT 2 TEST, MESSAGE CLEARED, OPS NORMAL.SDR COMA0670146Cylinder · corrodedNLG OUTER CYLINDER HAS MINOR CORROSION. REPAIRED NLG OUTER CYLINDER CORROSION IAW BOMBARDIER REO 670-32-21-094 AND GOODRICH SCR 0008-07 REV C.SDR COMA0670145Beam · 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 COMA0670144Bulkhead · corrodedFS 280 LT BULKHEADS CORRODED BEYOND REPAIRABLE LIMITS. REPLACED THE LT BULKHEAD IAW BOMBARDIER REO 670-53-11-052 REV A.SDR COMA0670143Bulkhead · corrodedFS 280 RT BULKHEADS CORRODED BEYOND REPAIRABLE LIMITS. REPLACED THE RT BULKHEAD AT FS 280 IAW BOMBARDIER REO 670-53-11-052 REV A.SDR COMA0670119Bleed Air Sys · contaminatedFLIGHT 4985 - SMOKE FORWARD LAV WARNING MESSAGE CAME ON DURING TAXI THEN WENT OUT. INSPECTED FORWARD LAV NO EVIDENCE OF SMOKE OR FIRE. SUSPECT GLYCOL INGESTION IN BLEED SYSTEM.SDR COMA0570131Battery Pack · dischargedFLIGHT 5689 - EMERGENCY LIGHT INOPERABLE. REPLACED EMERGENCY BATTERY PACK.SDR COMA0570010Control Handle · stuckFLIGHT 5670 FLAPS/SLATS CONTROL HANDLE IS STUCK. REPLACED FLAPS/SLATS SELECTOR LEVER.SDR COMA0470062Warning Light · illuminatedFLIGHT 5451 FLIGHT SPOILERS AND SPOILERON CAUTION MESSAGE. COULD NOT DUPLICATE SYSTEM, TEST NORMAL.SDR COMA0470056Windshield · crackedFLIGHT 5832 PILOTS WINDSHIELD CRACKED. REPLACED WINDSHIELD.SDR COMA0470052Warning Light · illuminatedFLIGHT 5048 RECEIVED A RIGHT THRUST REVERSER UNSAFE CAUTION DURING TAKEOFF ROLL, ABORTED AND RETURNED TO THE GATE. DEFERRED THE RIGHT THRUST REVERSER SYSTEM PER MEL 78-30-01.SDR COMA0470036Flow Valve · malfunctionedFLIGHT 5287 GEAR DISAGREE WARNING. REPLACED THE SYSTEM 3B FLOW LIMITING VALVE.SDR COMA0470006Selector Valve · malfunctionedFLIGHT 5520 NR 3 HYDRAULIC SYSTEM LOW PRESSURE AND GEAR DISAGREE WARNING. REPLACED THE L/G SELECTOR VALVE.SDR COMA0470003Pseu · malfunctionedFLIGHT 5299 GEAR DISAGREE WARNING DURING CRUISE. REPLACED THE PSEU.SDR COMA0370058Warning Light · illuminatedFLT 5213 LT WING ANTI ICE MESSAGE. COULD NOT DUPLICATE. SYSTEM TEST SATISFACTORY.SDR COMA0370028Sealant · missingFLIGHT 5717 CABIN DOOR MAKING LOUD NOISE, FA AND PASSENGER SAID THEY SMELLED SOMETHING BURNING. COULD NOT DUPLICATE - FOUND VERY SMALL AREA OF DOOR FRAME THAT WAS MISSING SEALANT. FILLED HOLE WITH SEALANT.
Back to N391CA