N471CA
Service difficulty reports · 228
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 = 'N471CA' 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 = 'N471CA' 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 SWIA201229132Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5538) RELAMPED EMERGENCY LIGHT.SDR SWIA201129033Light · inoperativeRIGHT AFT OVERWING EMERGENCY LIGHT IS OUT. (FLT 5590) RELAMPED EMERGENCY LIGHT.SDR SWIA201129031Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5590) RELAMPED EMERGENCY LIGHT.SDR SWIA201129032Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6316) RELAMPED EMERGENCY LIGHT.SDR SWIA201129014Light · inoperativeMAIN CABIN DOOR EXTERIOR EMERGENCY EXIT LIGHT IS OUT. (FLT 6393) RELAMPED EMERGENCY LIGHT.SDR SWIA201128886Light · inoperativeRIGHT OVERWING CENTER EXTERIOR EMERGENCY EXIT LIGHT IS OUT. (FLT 5409) RELAMPED EMERGENCY LIGHT.SDR SWIA201128722Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128556Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6374) RELAMPED EMERGENCY LIGHT.SDR SWIA201128465Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128012Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5302) RELAMPED EMERGENCY LIGHT.SDR SWIA201127991Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6375) RELAMPED EMERGENCY LIGHT.SDR SWIA201127774Light · inoperativeNR 1 EXTERIOR EMERGENCY LIGHT IS OUT. (FLT 6364) RELAMPED EMERGENCY LIGHT.SDR SWIA201127776Light · inoperativeNR 1, 2 AND 4 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 5293) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127522Light · inoperativeNR 1 AND NR 3 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 5831) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127456Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6425) RELAMPED EMERGENCY LIGHT.SDR SWIA201126908Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5526) RELAMPED EMERGENCY LIGHT.SDR SWIA201126364Light · inoperativeEMERGENCY LIGHT IS OUT AT CABIN DOOR. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126085Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6631) RELAMPED EMERGENCY LIGHT.SDR SWIA201126084Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6852) RELAMPED EMERGENCY LIGHT.SDR SWIA201126001Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6378) RELAMPED EMERGENCY LIGHT.SDR SWIA201125861Light · inoperativeRIGHT SIDE AFT EXTERIOR EMERGENCY LIGHT BURNED OUT. (FLT 5800) RELAMPED EMERGENCY LIGHT.SDR SWIA201125694Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6693)REPLACED.SDR SWIA201125542Light · inoperativeFORWARD OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6825) RELAMPED EMERGENCY LIGHT.SDR SWIA201025250Light · inoperativeNR 3 CEILING EMERGENCY LIGHT INOPERATIVE. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201025093Light · inoperativeNR 2 EMERGENCY OVERHEAD AISLE INOPERATIVE. (FLT 6331) RELAMPED EMERGENCY LIGHT.SDR SWIA201025065Light · inoperativeNR 3 CEILING EMERGENCY LIGHT INOPERATIVE. (FLT 6194) RELAMPED EMERGENCY LIGHT.SDR SWIA201024864Light · inoperativeAFT EMERGENCY CEILING LIGHT INOPERATIVE. (FLT 6429) RELAMPED EMERGENCY LIGHT.SDR SWIA201024865Light · inoperativeRIGHT NR 2 EXTERNAL EMERGENCY LIGHT INOPERATIVE. (MAINTENANCE) RELAMPED EMERGENCY LIGHT.SDR SWIA201024914Intercostal · crackedPOSSIBLE CRACK AT FS 621, 4TH RT INTERCOSTAL UP FROM BOTTOM CLIP ON OUTBOARD INTERCOSTAL RBL 25. (C-CHECK) REPAIRED PER REO.SDR SWIA201024634Tire · burstNR 2 MAIN TIRE BURST ON TAKEOFF. (FLT 6116) REPLACED NR 1 AND 2 MAIN WHEELS AND COMPLETED BURST TIRE INSPECTION.SDR SWIA201024557Bulkhead · crackedFS 621 BULKHEAD CRACKED. (C-CHECK) REPAIR PER REO.SDR SWIA201024570Bulkhead · crackedFS 621 BULKHEAD AT TOP OF CARGO DOOR TRACK CRACKED. (A-CHECK) REPAIRED PER REO.SDR SWIA201024531Light · inoperativeTHE NR 3 CEILING LEVEL EMERGENCY FLOODLIGHT INOP. (FLT 6004) RELAMPED EMERGENCY LIGHT.SDR SWIA201024268Light · inoperativeNR 3 CEILING EMERGENCY LIGHT INOP. (FLT 5932) RELAMPED EMERGENCY LIGHT.SDR SWIA201024101Light · inoperativeNR 3 EMERGENCY LIGHT INOP. (FLT 6736) RELAMPED EMERGENCY LIGHT.SDR SWIA200923331Light · inoperativeCEILING LEVEL EMERGENCY FLOODLIGHT NR 4 INOP. (FLT 6503) RELAMPED EMERGENCY FLOODLIGHT.SDR SWIA200922753Light · inoperativeRIGHT WING CENTER EMERGENCY EXIT LIGHT INOP. (FLT 6640) RELAMPED EMERGENCY LIGHT.SDR SWIA200922665Paint · roughAIRCRAFT ROLLED TO RIGHT UNCOMMANDED WHEN FLAPS EXTENDED. (FLT 6140) SMOOTHED NEW PAINT RIDGES ON FLAP.SDR SWIA200922664Light · inoperativeFIRST THREE CEILING EMERGENCY LIGHTS INOP. (FLT 5935) RELAMPED EMERGENCY LIGHTS.SDR SWIA200922609Light · inoperativeLEFT FUSELAGE EMERGENCY LIGHT INOP. (FLT 1014) RELAMPED EMERGENCY LIGHT.SDR SWIA200922364Light · inoperativeFORWARD OVERHEAD EMERGENCY LIGHT INOP. (FLT 2555) RELAMPED EMERGENCY LIGHT.SDR SWIA200922302Light · inoperativeCEILING EMERGENCY LIGHT INOP. (FLT 2543) RELAMPED EMERGENCY LIGHT.SDR SWIA200921748Light · inoperativeCEILING LEVEL EMERGENCY FLOODLIGHT INOP. (FLT 2559) RELAMPED EMERGENCY FLOODLIGHT.SDR SWIA200921682Lamp · burned outFLT 2850 - CEILING LEVEL EMERGENCY FLOODLIGHT INOP. RELAMPED.SDR SWIA200921535Pump · failedFLT 2719 - GEAR DISAGREE WARNING ON APPROACH. REPLACED HYDRAULIC PUMP 3A.SDR SWIA200921272Skin · damagedBIRD STRIKE ON LEFT SIDE OF NOSE AND ACROSS LEFT PITOT TUBE (FLT 2768). DENT WITHIN LIMITS PER SRM, DOWNGRADED FROM RVSM DUE TO LOCATION OF DENT.SDR SWIA200921115Selector Valve · faultyFLT 2582 - "NOSE GEAR DISAGREE" MASTER WARNING. REPLACED NLG SELECTOR VALVE, PN 750006000 SN OFF 1943.SDR SWIA200921116Lamp · burned outFLT 2526 - MOST AFT CEILING EMERGENCY LIGHT IN CABIN INOP. RELAMPED.SDR SWIA200820682Lamp · burned outFLT 2768 - OVERHEAD EMERGENCY LIGHT SECOND FROM BACK OF AIRCRAFT INOP. RELAMPED.SDR SWIA200820663Lamp · burned outFLT 2631 - THIRD CABIN EMERGENCY FLOODLIGHT FROM THE FRONT OF CABIN BURNED OUT. RELAMPED.
Back to N471CA