N496CA
Service difficulty reports · 163
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 = 'N496CA' 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 = 'N496CA' 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 SWIA200921381Battery Pack · dischargedFLT 2772 - SEVERAL CABIN EMERGENCY LIGHTS INOP. REPLACED BATTERIES.SDR SWIA200921270Light · inoperativeCEILING EMERGENCY LIGHT INOP (FLT 2621). RELAMPED EMERGENCY LIGHT.SDR SWIA200921250Selector Valve · faultyFLT 2679 - RECEIVED GEAR DISAGREE MESSAGE WHEN GEAR EXTENDED. REPLACED NLG SELECTOR VALVE PN 750006000 SN OFF 0164T.SDR SWIA200921391Mount · corrodedLEFT ENGINE AFT THRUST MOUNT CORRODED. SB COMPLIANCE, REPLACED MOUNT.SDR SWIA200921390Mount · corrodedRT ENGINE AFT THRUST MOUNT CORRODED. SB COMPLIANCE, REPLACED MOUNT.SDR SWIA200819795Windshield · failedRT WINDSHIELD SHATTERED WHILE AT CRUISE. (FLIGHT NR 2876) REPLACED WINDSHIELD IAW AMM 56-11-01. OPS AND LEAK CHECK GOOD. P/N OFF 601R33033-18 S/N OFF 03017H4489.
SDR COMA0760014Relief Valve · faultyFLIGHT 5478 - LEFT ENGINE COWL ANTI-ICE CAUTION MESSAGE IN FLIGHT. AIRCRAFT DIVERTED TO YYZ AND LANDED SAFELY. REMOVED AND REPLACED LEFT ENGINE COWL ANTI-ICE RELIEF VALVE.SDR COMA0660579Element · faultyFLIGHT 5126 - ON TAKEOFF ROLL RECEIVED A 14TH STAGE DUCT WARNING MESSAGE. ABORTED TAKEOFF AND RETURNED TO GATE WITHOUT INCIDENT. REPLACED RIGHT PYLON BLEED LOOP. NO FURTHER DEFECTS.SDR COMA0560523Door · openFLIGHT 5222 - CREW O2 SERVICE DOOR CAME OPEN IN FLIGHT. INSPECTED DOOR AND FOUND SERVICEABLE, CLOSED DOOR.SDR COMA0560409Bulb · failedFLIGHT 5315- NR 2 IDG CAUTION DURING T/O. REPLACED THE IDG TEMP BULB.SDR COMA0460287Cooling Fan · failedFLIGHT 5527 DISPLAY COOL CAUTION MESSAGE. REPLACED THE COCKPIT DISPLAY COOLING FAN.SDR COMA0360521Warning Light · activatedFLIGHT 6858) AFTER TAKE OFF AND DURING CLIMB RECEIVED A (STAB TRIM) AND (MACH TRIM) CAUTION, SYSTEM WOULD NOT RESET, AIRCRAFT RETURNED TO DEPARTING CITY (DSM). INTERROGATED HSTCU, NO FAULT CODES FOUND, CLEANED THE STAB TRIM PANEL AND PERFORMED AN OPERATIONAL SDR COMA0360326Warning System · activatedFLIGHT 5845 TAKEOFF ABORTED DUE TO YAWING TO RIGHT AND CONFIG SPOILER MESSAGE. COULD NOT DUPLICATE. NO FAULT CODES IN SECU, FUNCTIONAL CHECK WAS NORMAL. HIGH SPEED TAXI, NO YAWING OR FAULTS.
Back to N496CA