N390CA
Service difficulty reports · 287
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 = 'N390CA' 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 = 'N390CA' 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 ASOA200900249Beam · corrodedLT 280 BEAM CORRODED ON UPPER AFT SURFACE. REMOVED BEAM AND DOUBLER, DRILLED UP NEW BEAM, AND DOUBLER AND INSTALLED PER SRM 51-40-11, 51-42-06,51-42-21,51-42-13,51-23-00 AND 51-21-16.SDR ASOA200900248Web · corrodedLT 280 WEB APPEARS TO HAVE MINOR CORROSION ON AFT LOWER SURFACE. BLENDED MINOR CORROSION ON LEFT 280 WEB FOUND TO BE WITHIN LIMITS IAW SRM 51-12-00.SDR ASOA200900255Doubler · crackedASD DOUBLER ON AFT SIDE OF FRAME 5 AT PULL IN LEVER TORQUE TUBE IS CRACKED. REMOVED DOUBLER PER SRM 51-42-06. LOCATED, DRILLED AND INSTALLED NEW DOUBLER PER SRM 51-42-06. REINSTALLED AFT 1/2 OF PULL IN LEVER TORQUE TUBE PER AMM 52-11-00.SDR ASOA200900247Handle · crackedASD OUTER HANDLE CRACKED.SDR ASOA200900246Light · damagedEMERGENCY LIGHT TRACK CLEAR PLASTIC COVER AND PHOTOLUMINSCENT STRIPS ARE DAMAGED. REMOVED AND REPLACED EMERGENCY LIGHT TRACK IAW AMM 33-51-01.SDR TRAX200701749Handle · stiffF/A REPORTS SERVICE DOOR HANDLE DIFFICULT TO OPEN FULLY.SDR TRAX200701549Line · chafedFOUND RIGHT ENG PYLON HYDRAULIC PRESSURE LINE CHECK VALVE AT FIREWALL CHAFED. REMOVED CHECK VALVE IAW CRJ 700 AMM 29-11-00. EN ROUTE TO ATL A/C DIVERTED TO AEX DUE TO MTC. RELATED TO DEFECT 360869-1 &-2 AND 360870-1. EMERGENCY DECLARED. REF AFDL 360869, ISDR TRAX200701232Light · inoperativeLEFT EXTERNAL, 2ND FROM AFT, EMERGENCY LIGHT INOP.SDR TRAX200700846Floorbeam · crackedRIGHT FS 280 CROSSBEAM CRACKED O/B OF RBL 9. [06-26-07] ALL WORK DONE IAW CRJ 700, 51-42-06, 51-42-06, 51-42-21.SDR TRAX200700845Skin · crackedPAX DOOR STAIRS AFT SKIN CRACKED IN RADIUS UNDER UPPER MID STEP.SDR TRAX200700844Skin · crackedPAX DOOR STAIRS FWD SKIN CRACKED IN RADIUS UNDER UPPER MID STEP.SDR TRAX200700843Handle · crackedPAX DOOR OUTER HANDLE FLAP IS CRACKED. [06-26-07] REPAIRED IAW SRM 51-42-06, 51-25-01, AMM 11-20-00, & AMM 52-11-00.SDR TRAX200700841Light · inoperativeCEILING EMERGENCY LIGHT AT FS 605.00 INOP (FLAGGED). [06-26-07] REPAIRED IAW AMM 33-50-00 & AMM 35-51-00.SDR TRAX200700824Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED (MARKED). [06-21-07] REPAIRED PAX DOOR AFT DRAG ANGLE IAW BOMBARDIER REO 670-52-11-072.SDR TRAX200700822Crossbeam · corrodedFS 280 CROSSBEAM HAS MINOR SURFACE CORROSION. [06-26-07] REPAIRED IAW SRM 51-21-06, 51-25-06, AND 51-25-16.SDR TRAX200700840Floorbeam · corrodedFS 280 FWD FLOOR SUPPORT ANGLE CORRODED. [06-26-07] REPAIRED IAW CRJ SRM 51-42-06, 51-42-21 AND 51-45-00.SDR TRAX200700803Flashlight · inoperativeCAPT'S FLASHLIGHT IS INOP.SDR TRAX200700527Megaphone · inoperativeMEGA PHONE IS INOP.SDR COMA0670221Door · unsecureFLIGHT 5112 - AIRCRAFT WILL NOT PRESSURIZE. NO DOORS INDICATE OPEN, NO OTHER MESSAGES. RETURNED TO AIRPORT. FOUND AFT CARGO DOOR NOT SECURED. SECURED DOOR, PERFORMED OPS CHECK OF PRESSURIZATION SYSTEM. NO FURTHER DEFECTS.SDR COMA0670186Acm · smokeFLIGHT 5428 - THE AFT CABIN FILLED WITH SMOKE DURING TAXI OUT AT JAX, FLIGHT RETURNED TO THE GATE. DEFERRED THE LEFT AIR CONDITIONING PACK.SDR COMA0670159Access Door · openFLIGHT 5147 - AFTER TAKEOFF THE GROUND POWER ACCESS DOOR OPENED, FLIGHT RETURNED TO RIC. INSPECTED DOOR AND CLOSED.SDR COMA0670117Controller · faultyFLIGHT 5407 - DURING CAK APPROACH AND DEPLOYMENT OF FLIGHT SPOILER RECEIVED OUTBOARD FLIGHT SPOILER AND SPOILERON CAUTION MESSAGE, CREW DECLARED AN EMERGENCY AND FLIGHT LANDED WITHOUT INCIDENT. REPLACED SSCU NR 2.SDR COMA0670116Controller · faultyFLIGHT 5407 - DURING CAK APPROACH AND DEPLOYMENT OF FLIGHT SPOILER AND SPOILERON CAUTION MESSAGE, CREW DECLARED AN EMERGENCY AND FLIGHT LANDED WITHOUT INCIDENT. REPLACED SSCU NR 1.SDR COMA0670115Pcu · faultyFLIGHT 5885 - DURING LANDING AT RSW THE ELEVATOR CONTROL SYSTEM TEMPORARILY JAMMED AND RELEASED BY ITSELF. FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE RIGHT NR 3 POWER CONTROL UNIT.SDR COMA0670114Pcu · faultyFLIGHT 5885 - DURING LANDING AT RSW THE ELEVATOR CONTROL SYSTEM TEMPORARILY JAMMED AND RELEASED BY ITSELF. FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE RIGHT ELEVATOR NR 2 POWER CONTROL UNIT.SDR COMA0670113Pcu · faultyFLIGHT 5885 - DURING LANDING AT RSW THE ELEVATOR CONTROL SYSTEM TEMPORARILY JAMMED AND RELEASED BY ITSELF. FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE RIGHT ELEVATOR NR 1 POWER CONTROL UNIT.SDR COMA0670112Servo · faultyFLIGHT 5885 - DURING LANDING AT RSW THE ELEVATOR CONTROL SYSTEM TEMPORARILY JAMMED AND RELEASED BY ITSELF. FLIGHT LANDED WITHOUT INCIDENT. REPLACED THE ELEVATOR AUTO PILOT SERVO SMT-87B.SDR COMA0670109Servo · bindingFLIGHT 5609 - DURING LANDING AT STL THE ELEVATOR CONTROL FELT STIFF. PERFORMED INSPECTION OF THE LEFT AND RIGHT ELEVATOR CONTROL CABLE PATHS FROM NOSE TO ELEVATOR, NO DEFECTS NOTED. REPLACED SUSPECT ELEVATOR SERVO.SDR COMA0570104Pump · defectiveFLIGHT 5296 - HYDRAULIC SYSTEM 1 LOW PRESSURE WARNING. QUANTITY INDICATES EMPTY. REPLACED THE NR 1 EDP.SDR COMA0570092Warning Light · illuminatedFLIGHT 5104 - SLAT FAULT MESSAGE. SLATS FAILED AT 0. CND NO DEFECTS FOUND.SDR COMA0470080Selector Valve · faultyFLIGHT 5286 DURING TAKEOFF ROLL RECEIVED A GEAR DISAGREE WARNING MESSAGE. AIRCRAFT RETURNED TO THE GATE. REPLACED THE MLG SELECTOR VALVE ASSEMBLY.SDR COMA0470049Ecu · malfunctionedFLIGHT 5665 NLG STEERING INOP CAUTION MESSAGE. REPLACED THE NWS ECU.SDR COMA0470010Fan · malfunctionedFLIGHT 5326 RT PACK FAULT STATUS MESSAGE AND RT PRSOV CLOSED IN FLIGHT. REPLACED THE GALLEY FAN.SDR COMA0370040Bearing · stickingFLIGHT 9463, DURING SMALL BANK TURNS, STICKING CAN BE FELT IN AILERONS. REPLACED THE CONTROL WHEEL BEARINGS IN COPILOTS CONTROL YOKE.SDR COMA0370038Selector Valve · malfunctionedFLIGHT 9463 GEAR DISAGREE WARNING - LANDING GEAR DID NOT EXTEND. REPLACED THE SELECTOR VALVE.SDR COMA0370034Bulkhead · crackedFS 1098.20 BULKHEAD BETWEEN STRINGERS 8R AND 9R IS CRACKED. REPAIRED BY REMOVING DAMAGE AND INSTALLING A BATHTUB FITTING IAW BOMBARDIER, INC REO 670-53-61-034 REV B.SDR COMA0370022Control Unit · malfunctionedFLIGHT 5743 STAB TRIM AND MACH TRIM WARNINGS AUTO PILOT AND PITCH TRIM WARNING. REPLACED THE MCU.
Back to N390CA