N738SK
Service difficulty reports · 160
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 = 'N738SK' 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 = 'N738SK' 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 SWIA201642014Panel · corrodedPANEL 832DR HAS CORROSION AROUND SCREW HOLES. REPAIRED PANEL 832DR IAW STS EA.SDR SWIA201642013Panel · corrodedPANEL 832 BR HAS CORROSION AROUND SCREW HOLES. PANEL 832BR REPAIRED IAW EA.SDR SWIA201642012Door Sill · corrodedFOUND CORROSION IN 4 SPOTS ALONG AFT BAGGAGE BAY DOOR SILL. AFT BAGGAGE BAY DOOR FLOOR SILL R & R IAW SRM.SDR SWIA201439818Ahrs · failedPILOT REPORTS HE HAS A YAW DAMPNER NR 1 INOPERATIVE, PITCH FEEL FAULT, FD ATT MAG FLAGS AND NO AUTO PILOT. ACFT HAD TO DESCEND TO 28000 AND FUEL WOULD HAVE BEEN CLOSE SO DIVERTED. REPLACED NR 1 AHARS.SDR SWIA201439728Transceiver · failedF/O'S RADIO ALTIMETER INOPERATIVE. AFTER TAKEOFF , F/O'S RADIO ALT STAYED AT 0' AND CONSTANT GEAR HORN AUDIO. GLD UNSAFE CAUTION MESSAGE. RAN QRH FOR GLD UNSAFE AND RETURNED TO FIELD. R & R THE NR 2 RADIO ALTIMETER TRANSCEIVER IAW AMM.SDR SWIA201438545Light · unsecureSERVICE DOOR LIGHT STRIP IS PEELING. SECURED.SDR SWIA201438511Clamp · out of adjustRETURNED TO FIELD WITH A BLEED DUCT WARNING MESSAGE. REPOSITIONED LT PYLON LOOP AND ADJUSTED ADEL CLAMP.SDR SWIA201436679Unknown · smokeOBSERVED SMOKE IN COCKPIT AFTER TURNING ON PACKS & APU BLEEDS. OP CHECKED APU & LT & RT PACKS. NO SMOKE OBSERVED.SDR SWIA201436151Light · inoperativeNR 5 CEILING EMERGENCY LIGHT IS BURNED OUT. FLT 5169 RELAMPED.SDR SWIA201334613Battery Pack · dischargedEMERGENCY LIGHTS NOT WORKING. FLT#6433 REPLACED ALL FOUR ELBPS IAW AMM. PN AD-2013-1A , SN ON 81436, SN OFF 40198 PN AD-2013-1A , SN ON 65918, SN OFF 78630, PN AD-2013-1A, SN ON 69891, SN OFF 67800, PN AD-2013-1A , SN ON 112360 & SN OFF 79469.SDR SWIA201334544Printed Ckt Board · faultyEMERGENCY LIGHTS FLASHING WHEN IN ARMED POSITION. FLT#6292 REPLACED PCB-5 IN JB-11 IAW AMM. PN E520005-705A, SN ON E0248 & SN OFF E0347SDR SWIA201333290Crossbeam · crackedFS 280 CROSSBEAM CRACKED ON BOTH SIDES. (C-CHECK) REPLACED 280 CROSSBEAM IAW REO.SDR SWIA201333289Structure · crackedLEFT AFT CORNER OF TRU BAY FLOOR IS CRACKED. (C-CHECK) REPAIRED LEFT AFT CORNER OF TRU BAY FLOOR IAW REO.SDR SWIA201333288Structure · crackedRIGHT AFT CORNER OF TRU BAY FLOOR IS CRACKED. (C-CHECK) REPAIRED CRACK AT RIGHT TRU BAY FLOOR IAW REO.SDR SWIA201332742Unknown · odorAFTER LANDING AFT SMOKE IN LAV RED LIGHT CAME ON, APU ON, SMELLED LIKE PACKS, TURNED OFF PACKS, LIGHT WENT OUT AFTER 2 MIN. VISUAL INSPECTION BY FA AND LAX FIRE DEPT. (FLT 6462) INSPECTED A/C FOUND NO SIGNS OF SMOKE IN CABIN. RAN ENGINES AND SWAPPED BLEED SDR SWIA201332601Outlet · crackedRIGHT BLEED DUCT WARNING IN FLIGHT FOLLOWED BY RIGHT BLEED DUCT CAUTION. (FLT 5157) REPLACED RIGHT COWL ANTI ICE VALVE OUTLET IAW AMM.SDR SWIA201231574Light · inoperativeOVERHEAD EMERGENCY LIGHT IS OUT AT ROW 9. (FLT 5197) RELAMPED EMERGENCY LIGHT.SDR SWIA201231482Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5400) RELAMPED EMERGENCY LIGHT.SDR SWIA201231434Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 7 IS OUT. (FLT 6440) RELAMPED EMERGENCY LIGHT.SDR SWIA201231385Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201231284Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5166) RELAMPED EMERGENCY LIGHT.SDR SWIA201230972Outflow Valve · failedAUTO PRESSURE CONTROLLER CABIN CAUTION AND LOST MANUAL PRESSURE CONTROL CABIN. CONTINUED DESCENT AND GOT MANUAL CONTROL. (FLT 5435) REPLACED THE OUT FLOW VALVE IN REFERENCE TO AMM. P/N: GG670-98003-5, S/N OFF: 00364.SDR SWIA201230771Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5307) RELAMPED EMERGENCY LIGHT.SDR SWIA201229919Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5373) RELAMPED EMERGENCY LIGHT.SDR SWIA201229809Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5359) RELAMPED EMERGENCY LIGHT.SDR SWIA201128844Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5191) RELAMPED EMERGENCY LIGHT.SDR SWIA201128344Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5177) RELAMPED EMERGENCY LIGHT.SDR SWIA201130343Sill · corrodedC-CHECK, SERVICE DOOR LOWER SILL ANGLE HAS CORROSION. RERAIRED SERVICE DOOR LOWER SILL ANGLE PER CRJ700 SRM.SDR SWIA201128222Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2011) RELAMPED EMERGENCY LIGHT.SDR SWIA201127176Light · inoperativeTHE 2ND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6369) RELAMPED EMERGENCY LIGHT.SDR SWIA201127014Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 4378) RELAMPED EMERGENCY LIGHT.SDR SWIA201126688Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6227) RELAMPED EMERGENCY LIGHT.SDR SWIA201126469Light · inoperativeOVERHEAD EMERGENCY LIGHT BETWEEN ROWS 14 AND 15 IS OUT. (FLT 6222) RELAMPED EMERGENCY LIGHT.SDR SWIA201125547Light · inoperativeTHE 2ND TO LAST OVERHEAD EMERGENCY LIGHT NOT WORKING. (FLT 6563) RELAMPED EMERGENCY LIGHT.SDR SWIA201024329Floorbeam · crackedFS 280 FLOORBEAM CRACKED AND CORRODED. (C CHECK) REPLACED BEAM PER REO AND SRM.SDR SWIA201023854Light · inoperativeFORWARD EMERGENCY CEILING LIGHT INOP. (FLT 6685) RELAMPED EMERGENCY LIGHT.SDR SWIA201023440Battery Pack · dischargedFLT 6465 - ALL FORWARD CABIN EMERGENCY LIGHTS INOP. REPLACED NR 1 EMERGENCY LIGHT BATTERY PACK.SDR SWIA200923428Light · inoperativeFLT 5863 - EMERGENCY FLOOD LIGHT ABOVE LAVATORY INOP. RELAMPED.SDR SWIA200923245Light · inoperativeEMERGENCY CEILING LIGHT AT ROW 9 INOP. (FLT 6699)RELAMPED.SDR SWIA200922760Battery Pack · dischargedSEVERAL EMERGENCY LIGHTS INOP. (FLT 6465) REPLACED NR 3 ELBP.SDR SWIA200922728Bushing · corrodedLEFT ENGINE FWD MOUNT LINK BUSHINGS HAVE CORROSION PITTING. (ENGINE CHANGE) REPLACED LEFT ENGINE FWD MOUNT LINK BUSHINGS IAW AMM 71-21-01.SDR SWIA200922687Charger · inoperativeEMERGENCY BATTERY NR 3 CHARGER ASSY NOT CHARGING BATTERY. (FLT 6663) REPLACED NR 3 EMERGENCY BATTERY CHARGER ASSY.SDR SWIA200922686Power Supply · dischargedEMERGENCY LIGHTS INOP. (FLT 6663) REPLACED NR 1, 2, 3 & 4 EMERGENCY LIGHT BATTERY POWER SUPPLY ASSY'S.SDR SWIA200922616Light · inoperativeREAR EMERGENCY LIGHT INOP. (FLT 6096) RELAMPED EMERGENCY LIGHT.SDR SWIA200921962Lamp · burned outOVERHEAD EMERGENCY LIGHT INOP AT ROW 15. (FLT 6663) RELAMPED EMERGENCY LIGHT.SDR SWIA200921763Servo · jammedAUTO PILOT WOULD NOT DISENGAGE. (FLT 6526) REPLACED AILERON SERVO.SDR SWIA200921762Trim Switch · jammedRUDDER TRIM SWITCH JAMMED. (FLT 6526) REPLACED AILERON/RUDDER TRIM PANEL.SDR SWIA200921499Lamp · burned outFLT 6392 - CEILING EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921141Connector · damagedFLT 6324-5 - LOW AIR PRESSURE AIR CONDITIONING CONNECTOR DAMAGED. REPAIRED PER REO.SDR SWIA200820508Connector · shortedFLT 6285 - LEFT BLEED WARNING, PACKS SHUTDOWN AUTOMATICALLY, PERFORMED EMERGENCY DESCENT. REPOSITIONED LEFT BLEED LOOP A, CLEANED CONNECTORS LEFT BLEED LOOP B.
Back to N738SK