N317CA
Service difficulty reports · 275
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 = 'N317CA' 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 = 'N317CA' 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 TRAX200800144Megaphone · weakAFT MEGAPHONE VOLUME WEAK.SDR TRAX200800093Skin · crackedPAX DOOR INNER SKIN CRACKED 8 INCHES AFT OF FWD EDGE 4 INCHES UP FROM BOTTOM ON SKIN. REMOVED INNER SKIN AND INSTALLED NEW INNER SKIN PER CRJ 700 SRM 51-42-06,51-42-13 AND 52-11-01.SDR TRAX200800098Web · corrodedLEFT 280 WEB CORRODED BEYOND LIMITS.SDR TRAX200800067Beam · corrodedFS 280 TRANSVERSE BEAM CORRODED BEYOND LIMITS AND CRACKED. REPAIRS PERFORMED IN ACCORDANCE WITH BOMBARDIER REO 670-53-11-047 & BOMBARDIER SERVICE BULLETIN SB670-BA-53-026. SUPPLEMENTAL SDR CLOSED 3/27/08.SDR TRAX200800076Beam · corrodedFS 280 TRANSVERSE BEAM CORRODED BEYOND LIMITS AND CRACKED.SDR TRAX200800066Intercostal · crackedPAX DOOR INTERCOSTAL 318 CRACKED. REMOVED AND REPLACED 318 INTERCOSTAL IAW SRM 51-42-06.SDR TRAX200800065Drag Angle · crackedLEFT VERTICAL STAB DRAG ANGLE CRACKED AT AFT END (MARKED). PERFORMED EDDY CURRENT INSPECTION OF LT VERTICAL STAB DRAG ANGLE IAW NDTM 51-20-006 TO LOCATE END OF CRACK. END OF CRACK IS MARKED. INSTALLED AND SEALED L/H DRAG ANGLE PER REO 670-55-31-018.
SDR TRAX200800064Drag Angle · crackedRIGHT VERTICAL STAB DRAG ANGLE CRACKED AT AFT END (MARKED). PERFORMED EDDY CURRENT INSPECTION OF RIGHT HAND VERTICAL STAB DRAG ANGLE IAW NDTM 51-20-006 TO LOCATE END OF CRACK. END OF CRACK IS MARKED. INSTALLED AND SEALED RT DRAG ANGLE PER REO 670-55-31-018.SDR TRAX200800062Placard · wornPAX DOOR "EXIT" PLACARD WORN. REPLACED PLACARD PER 11-30-00.SDR TRAX200800061Handle · crackedPAX DOOR OUTER HANDLE CRACKED. REMOVED OUTER HANDLE AND INSTALLED NEW HANDLE PER AMM 52-11-03.SDR COMA0570085Striker · bentPASSENGER DOOR SEAL STRICKER IS DENTED. REPAIRS CARRIED OUT IAW BOMBARDIER REO 670-53-22-001 REV E REPAIR TYPE 1.SDR COMA0570084Sill · corrodedFLOOR SILL CORROSION BEYOND LIMITS APPROXIMATELY 3 INCHES AFT OF FS 280 ON THE RIGHT HAND SIDE. REPAIRS CARRIED OUT IAW BOMBARDIER EO 601R-53-6796.SDR COMA0570081Skin · lightning strikeLIGHTNING STRIKE EXIT DAMAGE ON LT ELEVATOR TRAILING EDGE. REPAIRED ELEVATOR UPPER SKIN TRAILING EDGE IAW BOMBARDIER EO 601R-55-6779.SDR COMA0570080Cylinder · corrodedNLG OUTER CYLINDER P/N 52101-1 S/N BA0025 CORRODED. CORROSION REPAIRED IAW BOMBARDIER REO 670-32-21-0060 AND GOODRICH SCR 0028-05.SDR COMA0570079Floorbeam · corrodedTRANSVERSE BEAM AT FS 280 FROM LBL 36 TO RBL 36. CORRODED ALONG UPPER AND LOWER EDGES. REPLACED TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER REO 670-53-11-047 REV C.SDR COMA0570078Web · corrodedFS 280 BULKHEAD LOWER WEBS CORRODED BEYOND LIMITS FROM LBL 36 TO RBL 36. REPLACED FS 280 BULKHEAD LOWER WEBS IAW BOMBARDIER REO 670-53-11-052 REV A REPAIR 2.SDR COMA0570036Control Unit · malfunctionedFLIGHT 5020 DURING DESCENT INTO CVG WHEN FLIGHT SPOILERS WERE DEPLOYED, RECEIVED SPOILERON AND FLIGHT SPOILER CAUTION MESSAGES, CREW DECLARED AN EMERGENCY, AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED THE LT OUTBOARD MULTIFUNCTION SPOILER POWER CONTROL UNIT.SDR COMA0570035Control System · malfunctionedFLIGHT 5020 DURING TPA APPROACH WHEN FLIGHT SPOILERS WERE DEPLOYED, RECEIVED A SPOILERON AND FLIGHT SPOILER CAUTION MESSAGE ON EICAS PRIMARY SCREEN. CREW DECLARED AN EMERGENCY. AIRCRAFT LANDED WITHOUT INCIDENT. PERFORMED A GROUND FUNCTIONAL CHECK OF SPOILERSDR COMA0570034Control Unit · faultyFLIGHT 5020 DURING DESCENT INTO CVG WHEN FLIGHT SPOILERS WERE DEPLOYED, RECEIVED SPOILERON AND FLIGHT SPOILER CAUTION MESSAGES. CREW DECLARED AN EMERGENCY, AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED THE RIGHT INBOARD MULTIFUNCTION SPOILER POWER CONTROL UNIT.SDR COMA0570033Computer · malfunctionedFLIGHT 5020 SUSPECTED PITCH TRIM ANOMALY. REPLACED THE FLIGHT CONTROL COMPUTER.SDR COMA0470076Selector Valve · unreliableFLIGHT 5077 GEAR DISAGREE WARNING. REPLACED THE SELECTOR VALVE.SDR COMA0470043Fan Blade · vibrationFLIGHT 5249 LT ENGINE FAN AT 2.3 VIBES. REPLACED THE LT ENGINE FAN BLADES.SDR COMA0470030Attach Fitting · crackedTHE RIGHT OUTBOARD MULTI-FUNCTION SPOILER OUTBOARD ATTACH FITTING (WS 216.9) IS CRACKED. REMOVED THE CRACKED ATTACH FITTING AND INSTALLED A NEW ATTACH FITTING P/N CC670-17113-5 IAW BOMBARDIER REGIONAL AIRCRAFT SERVICES EO 601R-57-4790A.SDR COMA0370056Fan Blade · damagedFLIGHT 5043 RT ENGINE FAN VIB CAUTION MESSAGE. REPLACED THE RT ENGINE FAN BLADES.SDR COMA0370029Tiller · malfunctionedFLIGHT 454 NOSE WHEEL STEERING FAIL CAUTION MESSAGE. REPLACED THE TILLER.
Back to N317CA