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 N6WA20140606003Cover · unsecureLEFT OVERWING EXIT HANDLE COVER FELL DOWN IN FLIGHT. SECURED VELCRO ON HANDLE COVER IAW AMM 51-22-61.SDR N6WA20140517002Lens · misinstalledRIGHT LAST EMERGENCY LIGHT LENS INSTALLED UPSIDE DOWN. REMOVED LIGHT LENS & INSTALLED IT IN THE CORRECT POSITION IAW AMM 33-51-15.SDR N6WA20140515001Door Seal · dirtyLEFT EMERGENCY DOOR HUMMING IN FLIGHT. REMOVED HATCH & CLEANED SEAL, SECURED DOOR IAW AMM 52-21-00. NO DEFECTS NOTED. ACFT OK FOR SERVICE.SDR N6WA20140504003Light · inoperativeRIGHT EMER LIGHT AT FLOOR LEVEL TOP BULB INOPERATIVE. DEFERRED IAW MEL 33-51-01 F CAT C.SDR N6WA20140501006Cover · looseLEFT OVERWING EMER EXIT HANDLE COVER LOOSE. SECURED LT OVERWING EMER EXIT HANDLE COVER IAW AMM 51-22-61, NO DEFECTS NOTED.SDR N6WA20140421003Light · inoperativeCEILING FLOOD LIGHT AT ROW 16 INOPERATIVE. RELAMPED LIGHT IAW AMM 33-51-09, OPERATIONS CHECKED GOOD.SDR N6WA20140303001Seal · dirtySQUEAL COMING FROM LT OVERWING EMERGENCY EXIT DOOR IN FLIGHT. CLEANED & LUBED LT EMERGENCY EXIT DOOR SEALS IAW CRJ700 AMM 121-20-32, NO DEFECTS NOTED.SDR N6WA20140220001Door · unsecureLOUD SQUEAL FROM LT EMERGENCY EXIT DOOR. SECURED LT SIDE EMERGENCY DOOR IAW CRJ700 AMM 52-21-00 & PRESSURIZED ACFT IAW CRJ700 21-31-00. OPERATIONS & LEAK CHECKED GOOD AT THIS TIME.SDR N6WA20130828003Cover · wornPAX DOOR AFT SIDE HINGE COVER WORN. R & R PAX DOOR AFT HINGE COVER IAW AMM 52-11-00.SDR N6WA2013071201Sign · inoperativeOVERWING EXIT SIGN LIGHTS NOT WORKING. PERFORMED OP'S CHECK OF OVERWING EXIT SIGN LIGHTS IAW AMM 33-51-00, OP'S CHECKED GOOD.SDR N6WA2013041101Sensor · inoperativeELEVATOR SPLIT CAUTION IN FLIGHT. R & R POSITION SENSOR RT ELEVATOR IAW AMM 27-34-10, OP'S CHECK GOOD AT THIS TIME.SDR N6WA2013031101Bulb · burned outOVERWING EXIT SIGN, RT BULBS ARE OUT. R & R BULBS ON RT SIDE IAW AMM 33-51-05, OP'S CHECKED GOOD.SDR N6WA2013030801Glowstrip · looseLEFT GLOWSTRIP LOOSE AT EMERGENCY EXIT. SECURED GLOWSTRIP IAW AMM 33-51-01.SDR N6WA2013022503Glowstrip · looseGLOW STRIP CAME LOOSE. SECURED GLOW STRIP IAW AMM 33-51-01.SDR N6WA20121231001Placard · fadedMAIN CABIN DOOR OPEN PLACARD FADED.SDR N6WA2012120702Warning Message · false activationHIGH SPEED ABORT FOR ICE CAUTION MESSAGE ON T/O ROLL 95 KAIS, THRUST REVERSERS WERE DEPLOYED, COWL ANTI ICE WAS ON, THRUST SETTING WAS 86.7% N1 AND GTOW 69480. HIGH ENERGY STOP, REJECTED TAKE OFF INSPECTION IAW AMM 05-51-27 AND AD 2011-17-12 INSPECTION, NO DESDR N6WA2012102701Warning Light · false activationPAX DOOR OUT HANDLE CAUTION MESSAGE, INTERMITTENT AFTER LANDING. OP'S CHECKED PAX DOOR IAW 52-11-00.SDR N6WA2012080203Handle · unsecureCOCKPIT EMERGENCY HATCH HANDLE STICKING UP OUTSIDE. RESECURED COCKPIT EMERGENCY LATCH HANDLE IAW AMM 52-22-00.SDR N6WA2012080204Handle · stickingCOCKPIT EMERGENCY HATCH HANDLE STICKING UP OUTSIDE. RESECURED COCKPIT EMERGENCY LATCH HANDLE IAW AMM52-22-00.SDR N6WA2012052303Bracket · detachedBRACKET DETACHED FROM LOWER PAX DOOR STEP. OPENSDR N6WA2012051901Fairing · looseEXIT ROW PLASTIC FAIRING FELL OFF. RESECURED FAIRING IAW AMM 25-26-09.SDR V0XR201205080039Fairing · brokenPASSENGER DOOR AFT HINGE FAIRING BROKEN. REMOVED AND ATTEMPTED REPLACEMENT, MOUNT HOLES TRANSFERRED FROM ORIGINAL AFT FAIRING TO NEW REPLACEMENT FAIRING, RESULTED UPON INSTALLATION OF NEW FAIRING THE TRANSFEREED FAIRING MOUNT HOLES WERE MISALIGNED TO THE FUSESDR V0XR201205080038Fairing · brokenPASSENGER DOOR FWD HINGE FAIRING BROKEN. REMOVED AND ATTEMPTED REPLACEMENT, MOUNT HOLES TRANSFERRED FROM ORIGINAL FAIRING TO NEW REPLACEMENT FAIRING, RESULTED UPON INSTALLATION OF NEW FAIRING THE TRANSFERED FAIRING MOUNT HOLES WERE MISALIGNED TO THE FUSELAGE SDR V0XR20120508J0037Placard · wornPASSENGER DOOR REFLECTIVE STRIP PLACARD WORN BEYOND RECOGNITION. R & R PASSENGER DOOR REFLECTIVE STRIP PLACARD IAW AMM 20-60-04. (REF. W/O 80072, W/C 8022)SDR V0XR20120508J0036Placard · wornPASSENGER DOOR DIRECTIONAL PLACARD WORN BEYOND RECOGNITION. R & R PASSENGER DOOR DIRECTIONAL PLACARD IAW AMM 20-60-04.SDR V0XR20120508J0035Cable · damagedICE BREAKER CABLE LOCATED IN PASSENGER DOOR DAMAGED BEYOND SERVICEABLE LIMITS. R & R PASSENGER DOOR ICE BREAKER CABLE IAW AMM 52-11-15.SDR V0XR20120508J0034Step · wornPASSENGER DOOR TOP STEP SPONGY IN THE CENTER AREA. R & R PASSENGER DOOR TOP STEP IAW AMM 52-11-04. (REF. W/O 80072, W/C 8020)SDR V0XR20120508J0033Seat Track · corrodedLEFT SEAT TRACK AT FS 785.15, AFT OF OVERWING EXIT DOOR, CORRODED BEYOND SERVICEABLE LIMITS. CLEANED AND BLENDED SEAT TRACK, BLENDED 0.018" WITHIN THE MAXIMUM 0.35" LIMIT IAW SRM 53-41-49.SDR V0XR20120508J0032Angle · corrodedPASSENGER DOOR THRESHOLD BOTTOM ANGLE FWD CAP CORRODED BEYOND SERVICEABLE LIMITS, FS 349. R & R PASSENGER DOOR THRESHOLD LOWER ANGLE FWD CAP IAW SRM 51-42-00, 51-10-06.SDR V0XR20120508J0031Angle · corrodedPASSENGER DOOR THRESHOLD BOTTOM ANGLE AFT CAP CORRODED BEYOND SERVICEABLE LIMITS, FS 349, R & R PASSENGER DOOR THRESHOLD LOWER ANGLE AFT CAP IAW SRM 51-42-00, 51-10-06.SDR V0XR20120508J0030Angle · corrodedFWD VERTICAL POST (CLOSING ANGLE) AT LBL 9, BS 280.00, WL 72.50 CORRODED BEYOND SERICEABLE LIMITS. R & R FWD VERTICAL POST (CLOSING ANGLE), TREATED, PRIMED AND PAINTED WITH TOPCOAT IAW SRM 51-42-06, 51-40-11.SDR V0XR20120508J0029Floorbeam · corrodedFS 279 FLOORBEAM CORRODED AT RBL 9 TO LBL 9 BEYOND SERVICEABLE LIMITS. INSTALLED NEW FLOORBEAM IAW SRM 51-42-13, 51-42-21.SDR V0XR20120508J0028Floorbeam · corrodedFS 280 FLOORBEAM CORRODED BEYOND SERVICEABLE LIMITS. REMOVED CORROSION IAW REO 670-53-11-046. ORIGINAL THICKNESS 0.040 ", MATERIAL REMAINING AFTER CORROSION REMOVAL 0.038 ", MATERIAL THICKNESS REMAINING AFTER REPAIR WITHIN SERVICEABLE LIMITS, TREATED AND PRISDR V0XR05082012J0033Seat Track · corrodedLEFT SEAT TRACK AT FS 785.15, AFT OF OVERWING EXIT DOOR, CORRODED BEYOND SERVICEABLE LIMITS. CLEANED AND BLENDED SEAT TRACK, BLENDED 0.018" WITHIN THE MAXIMUM 0.35" LIMIT IAW SRM 53-41-49.SDR V0XR05082012J0032Cap · corrodedPASSENGER DOOR THRESHOLD BOTTOM ANGLE FWD CAP CORRODED BEYOND SERVICEABLE LIMITS, FS 349.00. R & R PASSENGER DOOR THRESHOLD LOWER ANGLE FWD CAP IAW SRM 51-42-00, 51-10-06.SDR V0XR05082012J0031Cap · corrodedPASSENGER DOOR THRESHOLD BOTTOM AFT CAP CORRODED BEYOND SERVICEABLE LIMITS, FS 349.00. R & R PASSENGER DOOR THRESHOLD LOWER AFT CAP IAW SRM 51-42-00, 51-10-06.SDR V0XR05082012J0030Angle · corrodedFWD VERTICAL POST (CLOSING ANGLE) AT LBL9, BS 280, WL 72.50 CORRODED BEYOND SERICEABLE LIMITS. R & R FWD VERTICAL POST (CLOSING ANGLE), TREATED, PRIMED, & PAINTED WITH TOPCOAT IAW SRM 51-42-06, 51-40-11.SDR V0XR05082010J0029Floorbeam · corrodedFS 279 FLOORBEAM CORRODED AT RBL 9 TO LBL 9 BEYOND SERVICEABLE LIMITS. INSTALLED NEW FLOORBEAM IAW SRM 51-42-13, 51-42-21.SDR V0XR05082012J0028Floorbeam · corrodedFS 280 FLOORBEAM CORRODED. REMOVED CORROSION IAW REO 670-53-11-046. ORIGINAL THICKNESS 0.040 ", MATERIAL REMAINING AFTER CORROSION REMOVAL 0.038 ", MATERIAL THICKNESS REMAINING AFTER REPAIR WITHIN SERVICEABLE LIMITS, TREATED AND PRIMED REPAIR AREA IAW SRM 5SDR N6WA2012041001Structure · missingTRIM MISSING ON LT OVERWING EMERGENCY EXIT DOOR. RESECURED TRIM ON LT OVERWING EMERGECNY EXIT DOOR IAW AMM 25-26-09.SDR ASOA201200374Battery Pack · inoperativeNR 3 EMERGENCY LIGHT BATTERY PACK INOPERATIVE. R & R BATTERY PACK IAW AMM 33-51-17 IPC REF 33-51-17, FIG 1.SDR ASOA201200218Manifold · unserviceableSTEERING INOPERATIVE AFTER TAKEOFF, COMPLIED WITH QRH, EMERGENCY DECLARED. R & R STEERING MANIFOLD ASSY IAW AMM 32-51-50 IAW AIPC 32-51-00, OPS CHECKS GOOD. NO FUTHER DEFECTS NOTED ACFT OK FOR SERVICE.SDR ASOA201102189Connector · damagedNR 1 CEILING EMERGENCY LIGHT INOPERATIVE. REPAIRED CONNECTOR ON NR1 CEILING EMERGENCY LIGHT IAW SRM 20-16-00. OPS CHECKED GOOD.SDR ASOA201102026Lamp · burned outCEILING EMERGENCY LIGHT AT 1ACD IS OUT. RELAMPED CEILING EMERGENCY LIGHT IAW AMM 33-51-16.SDR ASOA201101893Intercostal · crackedFORE AND AFT INTERCOSTAL CLIP CRACKED ON FLOOR STRUCTURE BETWEEN FS 349.0 AND 364.0, LT OF AISLE AND BELOW FWD CLOSET AND AFT OF ASD ENTRANCE. REMOVED CRACKED CLIP. INSTALLED NEW CLIP IAW SRM 51-42-06.SDR ASOA201101682Megaphone · damagedCABIN MEGAPHONE DAMAGED. R & R CABIN MEGAPHONE IAW AMM 25-61-14. OPS CHECKED GOOD.SDR ASOA201101612Landing Gear · malfunctionedLANDING GEAR DISAGREE WARNING MESSAGE. ( LANDING GEAR RETRACTION SYS ) EMERGENCY DECLARED AS A PRECAUTION. COMPLIED WITH OPS TEST OF THE LANDING GEAR ENTENSION/RETRACTION IAW AMM 32-30-00.SDR ASOA201101366Handle · out of adjustMAIN PASSENGER DOOR INNER HANDLE IS HARD TO OPEN FROM THE INSIDE. ADJUSTED MAIN PASSENGER DOOR INNER HANDLE LATCH MECHANISM IAW AMM 52-11-02. MAIN DOOR HANDLE OPERATES CORRECTLY.SDR ASOA201101354Door · bindingF/A REPORTS MAIN CABIN DOOR HARD TO OPEN. COMPLIED WITH PAX DOOR INSP, NO DEFECTS NOTED. DOOR OPEN/CLOSED CHECK. OPS CHECKED GOOD OK IAW AMM 52-11-00.SDR ASOA201100681Floor Support · corrodedAFTER REMOVING FLOORBOARD FROM E&E BAY FOUND CORROSION ON FLOORBOARD SUPPORT BELOW BS 280. REMOVED CORROSION IAW STM 51-42-06.
Back to N390CA