N371CA
Service difficulty reports · 205
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 = 'N371CA' 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 = 'N371CA' 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 ASOA2015010712011Floor Support · crackedRT SIDE FLOOR SUPPORT CRACKED, COCKPIT. REMOVED AND REPLACED THE RT COCKPIT FLOOR SUPPORT IAW SRM 51-42-06-001-001-A01, SRM 51-42-06-001-001-A01, AND DWG CC670-0-331994.SDR ASOA2015010712010Floorbeam · corrodedCOCKPIT FLOORBEAM AFT ANGLE CORRODED AROUND FASTENERS. R & R COCKPIT FLOORBEAM AFT ANGLE IAW SRM 51-42-00-001-001-A01.SDR ASOA2015010712009Floorbeam · corrodedLT FS 280 FLOORBEAM CORRODED ON LOWER SURFACE AT LBL 9. BLENDED THE CORROSION IAW SRM 51-21-06-001-001-A01. FOUND TO BE OUT OF LIMITS IAW SRM 53-21-43. REPLACED DURING INCORPORATION OF SB670BA-53-041, REV D.SDR ASOA2015010712008Floorbeam · corrodedRT FS 280 FLOORBEAM CORRODED ON LOWER SURFACE AT RBL 9. REPLACED DURING INCORPORATION OF SB 670A-53-041, REV D.SDR ASOA2014100911395Structure · damagedAFT CARGO BAY DOOR COMBING IS DAMAGED AT 8 O`CLOCK POSITION. AS VIEWED FROM INSIDE. AFT LOWER EDGE. ALL WORK ACCOMPLISHED IAW REO 670-53-61-196, REV.A, CONSIDERED A PERMANENT REPAIR. COMPLIED WITH LEAK CHECK, AFT CARGO DOOR IAW AMM TASK 52-00-00-790-801. OSDR ASOA2014100911394Skin · dentedFUSELAGE SKIN DENTED RT SIDE BS 437 - 453, STRINGERS 17 - 18R. REPAIRED IAW SRM 53-00-01, FIGURE 53-00-01-991-808 SHEET 2. MAJOR REPAIR.SDR V0XR201305310190Bulkhead Web · corrodedRT LOWER COCKPIT BULKHEAD WEB CORRODED AT FS 280. REPAIRED BULKHEAD WEB IAW 670-53-11-594 REV. A.SDR V0XR201305280189Floorbeam · corrodedFS 280.00 FLOORBEAM CORRODED. R & R FLOORBEAM IAW SRM 53-11-41.SDR V0XR201305300188Bulkhead · corrodedLEFT LOWER COCKPIT BULKHEAD CORRODED AT FS 280. REPAIRED LT LOWER WEB IAW REO 670-53-11-594 01.SDR ASOA2013061903855Skin · corrodedCORROSION ON FUSELAGE AT STRINGER 26R BETWEEN FRAMES 333.0 AND 349.0. REPAIRED IAW SRM 51-21-06 AND IAW REO 670-53-21-959, SRM 53-21-03.SDR ASOA2013061903854Stringer · corrodedCORROSION ON FUSELAGE AT STRINGER 25R BETWEEN FRAMES BS 333 AND 349. BLENDED OUT CORROSION IAW SRM 51-21-06. REPAIRED IAW REO 670-53-21-959.SDR ASOA2013061903853Floorbeam · corrodedFLOORBEAM BS 280 CORRODED. R & R FLOORBEAM IAW SRM 51-42-06 AND 51-40-11.SDR ASOA2013061703826Stringer · corrodedCORROSION FOUND ON STR 25R AT BS 310. REPAIRED IAW SRM 53-21-06 AND SRM 51-21-06.SDR ASOA2013061703825Intercostal · corrodedINTERCOSTAL FWD OF AVIONICS DOOR CORRODED. R & R INTERCOSTAL IAW SRM 51-42-06 AND 51-42-20.SDR ASOA2013061903852Stringer · crackedPAX DOOR LINTEL STRINGER 3 CRACKED. COMPLIED WITH ECTC SB 670BA-53-040 01 IAW THE SB 670BA-53-040, REV C, SEP 20/2012, PART B. SB 670BA-53-040 REV C, FUSELAGE CENTER FUSELAGE, PRIMARY STRUCTURE FS280.00 TO FS295.00 INSPECTION AND REINFORCEMENT OF LINTEL STRINSDR ASOA2013061903848Floorbeam · corrodedFLOORBEAM AT FS 1036, LBL 28L OUT OF LIMITS. CUT OUT CORRODED AREA OF FLOORBEAM AT FS 1036, LBL 28 AND COMPLIED WITH EC/TC EO 700-53-0253 AND SRM 51-21-11, 51-25-16, 51-25-06, 51-24-36, 51-40-11.SDR ASOA2013061903847Floorbeam · corrodedBS 280 FLOORBEAM CORRODED. R & R FLOORBEAM IAW SRM 51-42-06, 51-40-11, 51-42-13, AND 51-42-21, 51-25-16, 51-24-36, 51-21-11 AND 51-25-06.SDR ASOA2013061903846Beam · corrodedRT SILL AT BS 280 BEAM CORRODED. R & R RT SILL IAW SRM 51-42-10, 51-45-00, 51-42-06, 51-42-21, 51-40-11, 51-21-11, 51-25-06.SDR ASOA2013061903845Bulkhead · corrodedRT LOWER BULKHEAD CORRODED AT BS 280 BEAM. REPAIRED IAW REO 670-53-11-594 AND GENERIC REO 670-53-11-594, REV A DATED 4/27/2011.SDR ASOA2013061903844Bulkhead · corrodedLEFT LOWER BULKHEAD CORRODED AT BS 280 BEAM. REPLACED LOWER BULKHEAD IAW EC/TC REO 670-53-11-594, AT FS280 LT SIDE.SDR ASOA2013061703824Floorbeam · corrodedCORROSION ON FLOORBEAM AT FS 1036, LBL 28. REPAIRED IAW CRJ 700 53-61-43.SDR COMA2012051570023Intercostal · chafedLEFT INTERCOSTAL CHAFED, FS 1149.5 AT STRINGER 9L. CUT OUT CHAFE DAMAGE AND INSTALLED A DOUBLER IAW BOMBARDIER REO 670-53-61-863.SDR COMA2011011870002Crossbeam · crackedFS 280 CROSSBEAM CRACKED IN RADIUS AT RBL 9. REMOVED DAMAGED SECTION OF FS 280 CROSSBEAM AND INSTALLED REPLACEMENT SECTION IAW REO 670-53-11-047 REV E.SDR COMA2011011870001Stringer · corrodedSTRINGER 25 RIGHT CORRODED AT FS 295, BELOW STAND OFFS. REMOVED DAMAGED SECTION OF STRINGER AND SPLICED IN NEW SECTION IAW SRM 53-00-03.SDR COMA2010020170001Computer · failedON APPROACH INTO CVG RECEIVED EFIS COMP MON, ATT/ROLL/PIT/HDG INDICATIONS MACH TRIM, STAB TRIM, RT AND LT FADEC FAULT, FLAP FAULT AND RUD LIMIT FAULT STATUS MSG'S. EMERGENCY DECLARED, A/C LANDED SAFELY. REMOVED AND REPLACED NR 2 AHC-85E.SDR COMA2008122970008Intercostal · chafedINTERCOSTAL CHAFED FROM RIGHT ACM WATER LINE. BLENDED OUT DAMAGED AREA AND PERFORMED REPAIR IN ACCORDANCE WITH EA 70-5361-02470.SDR COMA0870028Engine · vibrationLT ENGINE N2 VIB ON CLIMBOUT FROM CVG. ACFT RETURNED TO CVG. LANDED SAFELY. R&R LT ENGINE.SDR COMA0870009Proximity Sensor · faultyFLIGHT 9651 - RECEIVED AVIONICS BAY DOOR CAUTION MESSAGE DURING TAKEOFF ROLL. ABORTED TAKEOFF APPROX 20 KTS AND RETURNED TO GATE. REMOVED AND REPLACED PROX SENSOR (PX 41).SDR COMA0870008Warning System · malfunctionedFLIGHT 5644 - ON TAKEOFF ROLL RECEIVED AVIONICS BAY DOOR CAUTION MESSAGE, ABORTED TAKEOFF AT LOW SPEED. INSPECTED AVIONICS BAY DOOR AND PROX SENSOR, NO DEFECTS NOTED. INDICATION IS WORKING PROPERLY.SDR COMA0870007Warning System · malfunctionedFLIGHT 5579 - AVIONICS BAY DOOR CAUTION MESSAGE DURING TAKEOFF ROLL. ABORTED TAKEOFF SAFELY. INSPECTED AVIONICS BAY DOOR AND HANDLE, NO DEFECTS FOUND. OPS CHECK OF DOOR INDICATION NORMAL.SDR COMA0870006Warning System · activatedFLIGHT 5543 - AVIONICS BAY DOOR CAUTION MESSAGE ON TAKEOFF. ABORTED TAKEOFF SAFELY. DEFERRED PER MEL 52-70-02.SDR COMA0770038Control Unit · malfunctionedFLIGHT 5881 - EN ROUTE ATL-MDW RECEIVED A PITCH FEEL CAUTION MESSAGE. FLIGHT DIVERTED TO ORD. PERFORMED RESET OF SSCU 1 AND 2, PERFORMED AN OPERATIONAL CHECK OF PITCH FEEL UNITS, NO DEFECTS FOUND.SDR COMA0770035Slat System · malfunctionedFLIGHT 5077 - SLATS FAILED AT 0 DEGREES. FLAPS OPS NORMAL. CREW DECLARED AN EMERGENCY, AIRCRAFT LANDED SAFELY. PERFORMED MECHANICAL RIGGING OF RIGHT SIDE SLAT SYSTEM. OPS CHECK GOOD.SDR COMA0770030Floorbeam · corrodedRIGHT SIDE OF FS 280 FLOORBEAM IS CORRODED. REPAIRED THE FS 280 FLOORBEAM IAW REO 670-53-11-046.SDR COMA0770023Control Unit · faultyFLIGHT 5280 - STAB CH2 STATUS MESSAGE DISPLAYED ON AND OFF CONTINUOUSLY DURING CLIMB, CRUISE, LANDING AND TAXI. TRIM IN MOTION ORAL ON CONTINUOUSLY. ELECTRICAL SMELL IN AFT CABIN. LANDED DEN WITHOUT INCIDENT. REPLACED STAB ACTUATOR MCU. NO FURTHER DEFECTSSDR COMA0770022Motor · faultyFLIGHT 5280 - STAB CH2 STATUS MESSAGE DISPLAYED ON AND OFF CONTINUOUSLY DURING CLIMB, CRUISE, LANDING AND TAXI. TRIM IN MOTION ORAL ON CONTINUOUSLY. ELECTRICAL SMELL IN AFT CABIN. LANDED DEN WITHOUT INCIDENT. REPLACED NR 2 STAB ACTUATOR MOTOR. NO FURTHER SDR COMA0670220A/C Pack · smokeFLIGHT 5124 - ON TAXI RECEIVED AFT LAV SMOKE THEN FWD LAV SMOKE WARNING. F/A REPORTED SMELL AND LIGHT HAZE IN CABIN. NO FIRES REPORTED IN EITHER LAV. RAN RIGHT PACK ON APU FOR 2 HOURS, ALSO RAN ON NR 2 ENGINE TEMP CONTROL AUTO AND MANUAL MODES. NO FURTHER SDR COMA0670171Proximity Sensor · faultyFLIGHT 5198 - DURING TAKEOFF ROLL AT GSO RECEIVED AN AVIONICS DOOR CAUTION MESSAGE, ABORTED TAKEOFF AND FLIGHT RETURNED TO THE GATE. REPLACED THE AVIONICS DOOR PROXIMITY SENSOR.SDR COMA0570133Sensor · malfunctionedFLT 5276 - RT ENGINE LOW FUEL PRESSURE CAUTION. REPLACED THE LOW PRESSURE SENSOR.SDR COMA0670001Controller · unknownFLIGHT 4976 - ANTI-ICE DUCT WARNING. RESET THE AILC, C.N.D. SYSTEM TEST SATISFACTORY.SDR COMA0570128Controller · malfunctionedFLIGHT 4976 - ANTI-ICE DUCT WARNING. RESET THE AILC. SYSTEM TEST SATISFACTORY.SDR COMA570076Smoke · detectedSMOKE IN CABIN DURING TAXI. DEFERRED MAINTENANCE ON RT A/C SYSTEM PER MEL.SDR COMA0570059Beam · corrodedTRANSVERSE BEAM AT FS 280 FROM LBL36 TO RBL36 IS CORRODED ALONG UPPER AND LOWER EDGES. REPLACED THE TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER REO 670-53-11-047 REV C.SDR COMA0570058Bulkhead · corrodedFS 280 BULKHEAD LOWER WEBS ARE CORRODED BEYOND LIMITS FROM LBL 36 TO RBL 36. REPLACED THE FS 280 BULKHEAD LOWER WEBS IAW BOMBARDIER INC REO 670-53-11-052 REV A REPAIR NR 2.SDR COMA0570057Cylinder · corrodedNLG OUTER CYLINDER P/N 52101-1 S/N BA0049 IS CORRODED. CORROSION REPAIRED I/A/W BOMBARDIER REO 670-32-21-054 AND GOODRICH SCR 0008-04 REV C.SDR COMA0570055Actuator · malfunctionedFLIGHT 5472, SLATS FAIL CAUTION. REPLACED LT INBOARD SLAT ACTUATOR.SDR COMA0570045Control Unit · faultyFLIGHT 5613 DURING ATL APPROACH RECEIVED A SLAT FAIL CAUTION MESSAGE, CREW DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT. REPLACED THE SLAP/FLAPS ELECTRONIC CONTROL UNIT (SFECU).SDR COMA0570044Drive Unit · faultyFLIGHT 5613 DURING ATL APPROACH RECEIVED A SLAT FAIL CAUTION MESSAGE, CREW DECLARED AN EMERGENCY AND LANDED WITHOUT INCIDENT. REPLACED THE SLAP POWER DRIVE UNIT.SDR COMA0570007Warning System · malfunctionedFLIGHT 5283, INBOARD FLIGHT SPOILER AND SPOILERON CAUTION. RESET CONTROL UNIT, COULD NOT DUPLICATE. SYSTEM TEST SATISFACTORY.SDR COMA0470084Control Unit · malfunctionedFLIGHT 5866 SLAT FAIL CAUTION MESSAGE. RESET THE SFECU, SYSTEM OPERATIONAL CHECK SATISFACTORY.
Back to N371CA