N379CA
Service difficulty reports · 227
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 = 'N379CA' 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 = 'N379CA' 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 ASOA200900419Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. REMOVED PAX DOOR AFT DRAG ANGLE. LOCATED, FABRICATED AND DRILLED MOST OF THE HOLES (15694) COMPLETED FABRICATION OF -1, -2, AND -3 REPAIR PARTS IAW REO 670-52-11-072.SDR ASOA200900203Step · crackedBOTTOM FOLDING STEP ON PAX DOOR TOP STEP CRACKED.SDR ASOA200801510Battery · lowF/A REPORTS MEGAPHONE BATTERY IS LOW.SDR COMA0870025Wire Harness · damagedON CLIMBOUT FROM CVG RECEIVED PROX SYSTEM FAULT 1 STATUS MESSAGE FOLLOWED BY CARGO DOOR CAUTION AND PASS DOOR WARNING MESSAGE. NO CABIN PRESSURE LOSS. ACFT RETURNED BACK TO CVG AND LANDED SAFELY. FOUND CARGO DOOR HARNESS DAMAGED. REMOVED AND REPLACED CARGOSDR TRAX200800564Handle · crackedAVIONICS DOOR HANDLE CRACKED. DRILLED AND INSTALLED NEW HANDLE ASSY. PAINTED HANDLE PER SRM 51-25-00, LOCK FASTENERS INSTALLED PER SRM 51-42-20.SDR TRAX200800553Handle · crackedAVIONIC DOOR HANDLE CRACKED. THIS SDR WILL REMAIN OPEN PENDING MAINTENANCE DETERMINATION OF AN APPROPRIATE CORRECTIVE ACTION.SDR COMA0770046Light · inoperativeFLIGHT 5273 - EMERGENCY LIGHT AT ROW 13 INOP. RELAMPED EMERGENCY FLOOD LIGHT.SDR COMA0770017Acm · failedFLIGHT 5044 - DURING TAXI F/A REPORTED SMOKE IN CABIN, THEN RIGHT PACK AUTO FAIL CAUTION MESSAGE. A/C RETURNED TO GATE. REMOVED AND REPLACED RIGHT PACK ACM.SDR COMA0670222Door · openLOUD NOISE FROM NOSE DURING CLIMBOUT. AIRCRAFT RETURNED BACK TO MSP AND LANDED SAFELY. INSPECTED AIRCRAFT AND FOUND GROUND POWER SERVICE DOOR UNLATCHED. SECURED DOOR. NO FURTHER DEFECTS.SDR COMA0670216Acm · odorFLIGHT 5461 - DURING CLIMBOUT OF CVG RECEIVED A FWD AND AFT LAVATORY SMOKE WARNING MESSAGE, CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD. FLIGHT LANDED WITHOUT INCIDENT. PERFORMED OPERATIONAL CHECKS OF BOTH AIR CONDITIONING PACKS ON APU BLEED AIR, SMSDR COMA0670135Window · crackedFLIGHT 5841 - EN ROUTE BDL-RSW THE CAPTAIN'S WINDSHIELD CRACKED, CREW DECLARED AN EMERGENCY AND DIVERTED TO MCO. FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE CAPTAIN'S WINDSHIELD.SDR COMA0670100Computer · faultyFLIGHT 5075- EN ROUTE CVG-PBI, RECEIVED A RIGHT MAIN LANDING GEAR CAUTION MESSAGE, CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD. FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE NR 2 DATA CONCENTRATOR UNIT.SDR COMA0570129Torque Tube · looseFLIGHT 9490 - FLAPS FAIL CAUTION. SECURED LOOSE TORQUE TUBE AT THE RT NR 4 ACTUATOR.SDR COMA0570048Battery · dischargedFLIGHT 5196, 2 EMERGENCY LIGHTS AND OVERHEAD EXIT SIGN ARE INOP. REPLACED EMERGENCY LIGHT BATTERY.SDR COMA0570047Light · inoperativeFLIGHT 5490 EMERGENCY LIGHTS ARE INOP. COULD NOT DUPLICATE, OPERATIONAL CHECK OF EMERGENCY LIGHTS SATISFACTORY.SDR COMA0570031Ejector · crackedFLIGHT 5285 FUEL TRANSFERRING FROM RIGHT TANK TO CENTER TANK. REPLACED THE PRIMARY EJECTOR.SDR COMA0570022Actuator · faultyFLIGHT 5307 - AFTER TAKEOFF FROM JAX RECEIVED A STEERING INOP CAUTION MESSAGE, CREW DECLARED AN EMERGENCY AND DIVERTED TO BWI. AIRCRAFT LANDED WITHOUT INCIDENT. REPLACED THE STEERING ACTUATOR.SDR COMA0570021Limiter · malfunctionedDURING TEST FLIGHT WITH AUTOPILOT ENGAGED, AIRCRAFT EXPERIENCES PITCH OSCILLATIONS BETWEEN +/-20 TO 800 FPM VSI. PITCH DISCONNECT HANDLE PULLED IN FLIGHT AND REVEALED LAG IN LEFT SIDE PITCH CONTROL SYSTEM. PERFORMED FLIGHT CONTROL PATH INSPECTION AND FOUND TSDR COMA0570020Pressure Switch · faultyFLIGHT 5803 RECEIVED A STEERING CAUTION MESSAGE AFTER TAKEOFF FROM CVG, AIRCRAFT RETURNED TO FIELD. REPLACED THE STEERING PRESSURE SWITCH.SDR COMA0470025Warning System · malfunctionedFLIGHT 5072 SLATS FAIL CAUTION MESSAGE. COULD NOT DUPLICATE. NO FAULTS IN COMPUTER, OPERATION OF SLATS NORMAL.SDR COMA0470016Control Valve · malfunctionedFLIGHT 5073 LEFT COWL ANTI ICE AND LEFT BLEED CAUTION MESSAGE. REPLACED THE TEMP CONTROL VALVE.SDR COMA0470014Warning Light · illuminatedFLIGHT 5077 SLATS FAIL CAUTION MESSAGE. COULD NOT DUPLICATE, FOUND NO FAULT CODES IN COMPUTER. SYSTEM OPERATION NORMAL.SDR COMA0470013Shutoff Valve · malfunctionedFLIGHT 5319 COWL ANTI ICE AND LEFT BLEED CAUTION MESSAGE. REPLACED THE LT PRSOV.SDR COMA0370059Warning Light · false indicationFLIGHT 5649 SLATS FAIL MESSAGE. NO FAULTS LOGGED IN COMPUTER, COULD NOT DUPLICATE. SYSTEM OPERATES NORMAL.SDR COMA0370054Control Unit · faultyFLIGHT 5903) DURING CLIMB OUT OF STL RECEIVED AN IB FLIGHT SPOILER AND IB SPOILER CAUTION MESSAGE, AIRCRAFT RETURNED TO STL. REPLACED THE SPOILER/STABILIZER CONTROL UNIT.SDR COMA0370033Bulkhead · crackedFS 1098.20 BULKHEAD BETWEEN STRINGERS 8R AND 9R IS CRACKED. REPAIRED BY REMOVING DAMAGE AND INSTALLING A BATHTUB FITTING IAW MFG REO 670-53-61-034 REV. B.SDR COMA0370017Battery Pack · dischargedFLIGHT 5812 FORWARD EMERGENCY LIGHTS ARE INOPERATIVE. REPLACED EMERGENCY BATTERY.
Back to N379CA