N695CA
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 = 'N695CA' 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 = 'N695CA' 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 ASOA2013122409684Door · bindingAIR STAIR WOULD NOT OPEN, HAD TO FORCE THE DOOR DOWN.SDR ASOA2013111809414Lamp · inoperativeNR 1 EMERGENCY FLOOD LIGHT, INOPERATIVE. REPLACED LAMP IAW AMM 33-51-09. OPS CHECKED GOOD.SDR ASOA2012112102503Battery Pack · malfunctionedEMERGENCY LIGHTS POWER SUPPLY NR 4 WILL NOT HOLD A CHARGE. R & R EMERGENCY LIGHT POWER SUPPLY UNIT NR 4 IAW AMM 33-51-17.SDR ASOA2012103102410Flashlight · inoperativeAFT F/A FLASHLIGHT IS INOPERATIVE. INSTALLED NEW FLASHLIGHT TO AFT F/A STATION IAW AMM 25-61-01. OK FOR SERVICE.SDR COMA2011112990036Ecu · malfunctionedON APPROACH INTO HOU RECEIVED FLAPS FAIL CAUTION MSG. EMERGENCY DECLARED, A/C LANDED SAFELY.
RESET SFECU, OPS CHECK GOOD.SDR COMA2011101390032Sill · corrodedFLOOR SILL FWD OF SERVICE DOOR CORRODED. REMOVED AND REPLACED RT SIDE SILL IAW CRJ SRM 51-42-00.SDR COMA2011101390033Crossbeam · corrodedFS 280 CROSSBEAM CORRODED ALONG TOP SURFACE OF UPPER ANGLE. REMOVED AND REPLACED FS 280 FLOORBEAM IAW REO 690-53-11-092 AND SRM 51-42-00.SDR COMA2011101190031Skin · damagedFUSELAGE LOWER SKIN SCRAPED 18" FORWARD OF AFT DRAIN MAST.
CUT OUT DAMAGED SKIN AND INSTALLED A DOUBLER IAW BOMBARDIER REO 690-53-61-133.SDR COMA2011080990027Splice · shortedEN ROUTE FROM MEM TO BWI RECEIVED ANTI-ICE DUCT MSG. MSG REMAINED ON FOR 45 MIN. EMERGENCY DECLARED, A/C DIVERTED TO CVG LANDED SAFELY. INSPECTED A/C FOUND LEFT WING CONNECTOR MT171P1 TO HAVE HIGHT RESISTANCE, CLEANED CONNECTOR. ALSO FOUND RIGHT WING SPLICSDR COMA2008122390002Door · malfunctionedLEFT FWD OVERWING EMERGENCY EXIT DOOR WILL NOT CLOSE. RESTOWED AND SECURED LEFT FWD OVERWING EMERGENCY EXIT DOOR. NO FURTHER DEFECTS NOTED, OPS CHECK GOOD.
Back to N695CA