N376CA
Service difficulty reports · 282
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 = 'N376CA' 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 = 'N376CA' 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 ASOA20100028Lens · missingINSTALLED EXIT LIGHT COVER. REF; AMM 33-50-00. (CLOSED)SDR ASOA201000028Sign · missingILLUMINATED EXIT SIGN BY SERVICE DOOR IS MISSING.SDR ASOA200901029Light · inoperativeRT AFTMOST EXTERNAL EMERGENCY LIGHT INOP.SDR ASOA200900637Angle · crackedANGLE CRACKED AT RBL 26.00 FS 280.00 (14211/PG 100). REMOVED UNSERVICEABLE ANGLE AT RBL 26.00 FS 280.00 & REPLACED WITH FABRICATED SERVICEABLE ANGLE IAW CRJ 700 SRM 53-11-00 & 51-24-21.SDR ASOA200900623Seat Track · corrodedSEQ 169 \ 2000-0060 CORROSION ON RT FWD SEAT RAIL JUST AFT OF FWD LAV AREA. REMOVED CRACKED "CLEAT" P/N CC670-33528-1 AND DUPLICATED USING 2024 T3 BY .050 ALUMINUM. INSTALLED NEW SERVICEABLE CLEAT WITH LOCK FASTENERS. ALL WORK DONE IAW SRM REFERENCE AAR FORSDR ASOA200900622Attach Bracket · crackedFLIGHT COMPARTMENT FLOORBEAM, CROSSBEAM ATTACH BRACKETS AT FS 232.00, RBL 9, IS CRACKED. REMOVED UNSERVICEABLE SEAT RAIL JUST AFT OF FWD LAV IAW SRM 53-00-49. SOLVENT CLEANED AREA WHERE SEAT RAIL IS TO BE INSTALLED IAW AMM 51-26-00. INSTALLED SERVICEABLE SSDR ASOA200900588Bulkhead · corrodedSEQ 37 \ 2000-0016 LT LOWER FS280 BULKHEAD WEB HAS AREA OF SURFACE CORROSION AT LBL15 ON EXISTING REPAIR INSERT. BLENDED CORROSION .003 INCH MATERIAL REMOVED OVER A SURFACE AREA OF APPROX 1 SQUARE INCH, .005 INCH MAX BLEND DEPTH ALLOWED. OK TO APPLY FINISH CSDR ASOA200900587Bracket · crackedFS 280 FLOORBEAM T-BRACKETS CRACKED AT LBL 9 AND RBL 9. REMOVED FLOORBEAM T-BRACKETS IAW SRM 51-42-06 & SRM 51-42-21. LOCATED, DRILLED AND PREPPED BRACKETS IAW SRM 51-40-11. INSTALLED BRACKETS IAW SRM 51-42-21. APPLIED PRIMER & TOPCOAT IAW SRM 51-25-06 & 5SDR ASOA200900586Crossbeam · corrodedFLOOR SUPPORT CORRODED AT MULTIPLE LOCATIONS BETWEEN LBL 37 AND RBL 37. REMOVED AND REPLACED FLOOR SUPPORT IAW REO NR 670-53-11-047 REV D.SDR ASOA200900585Floor Support · corrodedFLIGHT DECK FLOOR SUPPORT ANGLE AT FS 280 CORRODED. REMOVED FLIGHT DECK FLOOR SUPPORT ANGLE IAW ARM 51-42-06 & SRM 51-42-21. FABRICATED NEW SERVICEABLE FLT DECK FLOOR SUPPORT ANGLE USING SAMPLE PART IAW SRM 5124-21 & SRM 51-42-06. INSTALLATION OF NEW SERVICSDR ASOA200900161Door · stiffSTATION REPORTS PAX DOOR DIFFICULT TO CLOSE.SDR COMA0760683Spoiler · damagedMULTI FUNCTION SPOILER SURROUND STRUCTURE HAS WORKING RIVETS. REMOVED RIVETS AND PERFORMED HOT BOND REPAIR TO DAMAGED AREA IAW EA 70-5751-01925.SDR COMA0770072Seal · damagedPAX DOOR SEAL NIB PREVIOUS REPAIR APPEARED DAMAGED BY SHOOT BOLT. REMOVED PREVIOUS REPAIR, STRIPPED PAINT, LPI INSPECTED REPAIR PART AND FOUND NO DAMAGE. REINSTALLED REPAIR PART AND RE-PAINTED IAW REO 670-53-22-001.SDR COMA0770071Cowl Door · damagedRIGHT ENGINE LOWER FAN COWL DOOR I/B AFT CORNER IS DAMAGED. FABRICATED AND INSTALLED DOUBLER REPAIR IAW SRM 54-14-00 AND 51-14-00.SDR COMA0770074Crossbeam · corrodedTHE 280 BULKHEAD AND CROSSBEAM ARE CORRODED. REPAIRED DAMAGE IAW REO 670-53-11-047 AND SRM 51-40-11.SDR COMA0770069Door Frame · corrodedLOWER COAMING AFT CARGO DOOR SURROUND FRAME IS GOUGED BEYOND LIMITS. REPAIRED IAW EA 70-5361-01934.SDR COMA0670134Battery Pack · dischargedFLIGHT 5294 - FOUND EMERGENCY LIGHTS WILL NOT ILLUMINATE. REPLACED BATTERY PACK.SDR COMA0670133Battery Pack · dischargedFLIGHT 5294 - FOUND EMERGENCY LIGHTS WILL NOT ILLUMINATE. REPLACED BATTERY PACK.SDR COMA0670132Battery Pack · dischargedFLIGHT 5294 - FOUND EMERGENCY LIGHTS WILL NOT ILLUMINATE. REPLACED BATTERY PACK.SDR COMA0670131Battery Pack · dischargedFLIGHT 5294 - FOUND EMERGENCY LIGHTS WILL NOT ILLUMINATE. REPLACED BATTERY PACK.SDR COMA0670125Skin · crackedFOUND PASSENGER DOOR AFT SIDE PANEL CRACKED. REPAIRED IAW BOMBARDIER REO 670-52-11-104.SDR COMA0670124Skin Panel · dentedFOUND SKIN DAMAGE BETWEEN FS 1031.00 AND FS 1051.30, STGR 13R AND STGR 14R. DAMAGE IS 1.5LX1.5WX.025D. PERFORMED PERMANENT NON-FLUSH SKIN REPAIR IAW CRJ700 SRM 53-00-01-201-001-AO1.SDR COMA0670103Warning Light · illuminatedFLIGHT 5383 - DURING MSP APPROACH RECEIVED AN OUTBOARD SPOILERON AND OUTBOARD FLIGHT SPOILER CAUTION MESSAGE, CREW DECLARED AN EMERGENCY, ABORTED APPROACH THEN LANDED WITHOUT INCIDENT ON SECOND ATTEMPT. PERFORMED RESET OF THE SPOILER SYSTEM.SDR COMA0570125Engine · overheatedFLIGHT 5281- RT MOTOR OVERTEMP DURING T/O, ITT 960 C. INSPECTED ENGINE AND FOUND NO DEFECTS. OPERATIONAL CHECKS WERE NORMAL.SDR COMA0570100Window · failedFLT 5841 - COPILOT'S SIDE WINDOW SHATTERED. REPLACED WINDOW.SDR COMA0570062Warning Light · illuminatedFLIGHT 5173 - RIGHT THRUST REVERSER UNSAFE WARNING DURING AKEOFF.DEFERRED MAINTENANCE ON THRUST REVERSER PER MEL.SDR COMA0570050Floorbeam · corrodedTRANSVERSE BEAM AT FS 280 FROM LBL36 TO RBL 36 IS CORRODED ALONG THE UPPER AN LOWER EDGES. REPLACED THE TRANSVERSE BEAM AT FS 280 IAW BOMBARDIER AEROSPACE REO 670-53-11-047, REV A., CRJ 700 SRM 51-25-16-001-001-A01, CRJ 700 SRM 51-40-11-001-001-A01 AND CRJ 70SDR COMA0570049Bulkhead · corrodedFS 280 LT BULKHEAD LOWER WEB IS CORRODED IN VARIOUS PLACES ALONG THE BOTTOM EDGE FROM LBL36 TO LBL9. REPLACED THE FS 280 LT BULKHEAD LOWER WEB IAW BOMBARDIER INC REO 670-53-11-052, REV A REPAIR NR 2 AND CRJ 700 SRM 51-42-13-001-001-A01 AND CRJ 700 SRM 51-42-0SDR COMA0570051Bulkhead · corrodedLOWER WEB AT LT FS 280 (BACK OF PILOTS CB BULKHEAD) IS CORRODED BEYOND LIMITS. REMOVED AND REPLACED THE LOWER LT WEB P/N 670-53-11-052-1 IAW CRJ 700 SRM 51-42-06-001-A01.SDR COMA0470008Engine · vibrationFLIGHT 5874 RIGHT ENGINE VIBRATION CAUTION MESSAGE. COULD NOT DUPLICATE. RUN CHECKS WERE NORMAL.SDR COMA0370030Connector · dirtyFLIGHT OVERHEAT WARNING. COULD NOT DUPLICATE, CLEANED BRAKE TEMPERATURE MONITORING SYSTEM WIRING CONNECTOR.SDR COMA0370024Thermocouple · contaminatedBRAKE OVERHEAT WARNING, LEFT INBOARD BRAKE INDICATED 20. CLEANED CONTAMINATION FROM BTMS WIRING CONNECTOR.
Back to N376CA