N774SK
Service difficulty reports · 145
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 = 'N774SK' 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 = 'N774SK' 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 SWIA201436253Light · inoperativeNR 4 CEILING EMERGENCY FLOOD LIGHT IS BURNED OUT. FLT 6257 RELAMPED.SDR SWIA201334555Link · damagedRT ENGINE FWD ENGINE MOUNT LINK ASSEMBLY HAS PITTING. C-CHECK REPLACED RT ENGINE FWD MOUNT LINK ASSEMBLY.SDR SWIA201334097Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT#5605 RELAMPED.SDR SWIA201333938Light · inoperativeREAR-MOST CABIN EMERGENCY LIGHT IS BURNED OUT. FLT#6248 RELAMPED.SDR SWIA201333599Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT, RELAMPED.SDR SWIA201333506Battery · dischargedEMERGENCY LIGHTS FAILED TO STAY ON. INSTALLED FWD EMERGENCY LIGHT BATTERY, PN: AD-2013-1A, SN ON: 67796, SN OFF: 80624.SDR SWIA201333189Battery Pack · misinstalledNR 2 ELBP NOT ILLUMINATING EMERGENCY LIGHTS AS REQUIRED. (SERVICE) CORRECTLY INSTALLED NR 2 ELBP.SDR SWIA201332955Lens · missingOVERHEAD EMERGENCY RED INDICATOR LIGHT LENS MISSING. (FLT 5193) INSTALLED OVERHEAD EMERGENCY LIGHT RED LENS.SDR SWIA201232123Ballast · malfunctionedBURNING SMELL FROM OVERHEAD BIN ROW 2 A/B SIDE. (FLT 5207) REPLACED LIGHT BALLAST.SDR SWIA201231858Sill · corrodedAVIONICS BAY DOOR SILL HAS PITTING DAMAGE. (C-CHECK) REPAIRED AVIONICS BAY DOOR SILL PER BOMBARDIER REO.SDR SWIA201231857Crossbeam · crackedFS 280 CROSSBEAM IS CRACKED. (C-CHECK) REPLACED FS 280.0 CROSSBEAM IN REFERENCE TO REO.SDR SWIA201231859Axle · corrodedPITTING ON NR 1, 2, 3, AND 4 MLG AXLE ROOT RADIUS. (C-CHECK) REPAIRED NR 1, 2, 3, AND 4 MLG AXLES PER REO.SDR SWIA201231225Sensor · out of adjustRECEIVED WOW INPUT CAUTION MESSAGE. LANDING GEAR LEVER WOULD NOT MOVE TO THE UP POSITION. (FLT 5174) ADJUSTED NLG WOFFW, CENTERED SENSOR PX03 AND PX11 IAW MM.SDR SWIA201230475Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5171) RELAMPED EMERGENCY LIGHT.SDR SWIA201230263Light · inoperativeMULTIPLE BULBS ARE INOP ON THE LEFT OVER WING EMERGENCY EXIT SIGN. (FLT 5781) RELAMPED EMERGENCY EXIT SIGN.SDR SWIA201230262Light · inoperativeNR 4 AND NR 5 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 5781) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127788Light · inoperativeEMERGENCY LIGHT INOPERATIVE. (FLT 6427) RELAMPED EMERGENCY LIGHT.SDR SWIA201127393Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2062) RELAMPED EMERGENCY LIGHT.SDR SWIA201126931Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5476) RELAMPED EMERGENCY LIGHT.SDR SWIA201126877Acm · malfunctionedRIGHT SIDE PACK OVERHEATING, RIGHT PACK AUTO FAIL CAUTION MESSAGE AND SMOKE. (FLT 5451) REPLACED RIGHT HOT AIR SHUT OFF VALVE AND RIGHT AIR CYCLE MACHINE. P/N1: GG670-95002-3, SN1 OFF: 00129, P/N2: GG760-95009-3, S/N2 OFF: 01050.SDR SWIA201126221Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6246) RELAMPED EMERGENCY LIGHT.SDR SWIA201126140Light · inoperativeOVERHEAD EMERGENCY LIGHT NEAR ROW 15 IS OUT. (FLT 1142) RELAMPED EMERGENCY LIGHT.SDR SWIA201126111Light · inoperativeTHE 2ND TO LAST CEILING EMERGENCY LIGHT IS OUT. (FLT 1160) RELAMPED EMERGENCY LIGHT.SDR SWIA201125766Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED ON BOTH SIDES. (C-CHECK) REPLACED FLOORBEAM PER SRM.SDR SWIA201025316Light · inoperativeFORWARD CEILING EMERGENCY LIGHT OUT. (FLT 6573) RELAMPED EMERGENCY LIGHT.SDR SWIA201025039Light · inoperativeFORWARD INTERIOR EMERGENCY LIGHT INOPERATIVE. (FLT 6447) RELAMPED EMERGENCY LIGHT.SDR SWIA201024393Mechanism · obstructedUNABLE TO OPEN MAIN CABIN DOOR FROM THE INSIDE. (FLT 6132) FOUND OUTER SKIN INSULATION JAMMING LOWER CAM MECHANISM. REMOVED INSULATION.SDR SWIA201024275Light · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE ROW 5 INOP. (FLT 6495) RELAMPED EMERGENCY LIGHT.SDR SWIA201023927Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT INOP. (FLT 6361) RELAMPED EMERGENCY LIGHT.SDR SWIA201023425Light · inoperativeOVERHEAD EMERGENCY FLOODLIGHT INOP. (FLT 5876) RELAMPED EMERGENCY LIGHT.SDR SWIA200923405Unknown · odorFUEL SMELL IN FLIGHT DECK AFTER ENGINE SHUTDOWN. (FLT 6160) ALL INSPECTIONS AND OPERATIONAL CHECKS NORMAL WITH NO FUEL SMELL NOTED.SDR SWIA200923310Light · inoperativeCEILING LEVEL EMERGENCY FLOODLIGHT ABOVE ROW 15 INOP. (FLT 6129) RELAMPED EMERGENCY FLOODLIGHT.SDR SWIA200922544Beam · crackedFS 280 BEAM CRACKED. (C CHECK) REPLACED BEAM PER REO.SDR SWIA200922894Beam · crackedFS 280 BEAM CRACKED. (C CHECK) REPLACED BEAM PER REO.SDR SWIA200921784Light · inoperativeFLOOR EMERGENCY LIGHT INOP. (FLT 5802) RELAMPED EMERGENCY LIGHT.SDR SWIA200921731Sign · missingEMERGENCY LIGHT SIGN MISSING ON LOWER GALLEY FLOOR. (FLT 6075) REPLACED COVER.SDR SWIA200921636Lamp · burned outFLT 6021 - NR 5 OVERHEAD EMERGENCY LIGHT INOP. RELAMPED.SDR SWIA200921217Lamp · burned outFLT 5821 - GALLEY EMERGENCY FLOOD LIGHT INOP. RELAMPED.SDR SWIA200819922Acm · smokeBURNING ODOR REPORTED IN FLIGHT DECK AREA. (FLIGHT NR 6630) REPLACED LT AIR CYCLE MACHINE IAW 21-51-08. OPS AND LEAK CHECK GOOD. PN: GG670-95009-1 S/N OFF: 1042.
SDR SWIA200819939Floorbeam · crackedFS 280 IS CRACKED AT LBL 9 AND RBL 9. FOUND AT C-CHECK. COMPLIED WITH REPAIRS AT RBL AND LBL 9 PER SB 670BA-53-026, REV B.
SDR SWIA200718616Computer · malfunctionedFLIGHT DISPLAY NR 1 IS MISSING ALTITUDE AND SPEED INFORMATION, FLIGHT NR 1001. REPLACED NR 1 ADC IAW MM 34-13-01. OPS CHECKS GOOD.SDR SWIA200718470Switch · shortedCAPTAIN'S DOME LIGHT SWITCH IS HARD TO OPERATE AND APPEARS TO BE SHORTING. REPLACED CAPTAIN'S DOME LIGHT SWITCH AS REQUIRED BY AMM 33-13-09.SDR SWIA200718396Light · shortedFIRST OFFICERS MAP LIGHT POPPED CIRCUIT BREAKER 2G7 WHEN KNOB WAS ROTATED IT. REPLACED MAP LIGHT IAW AMM 33-13-07.SDR SWIA200718359Structure · crackedPAX DOOR CRACKED ON FORWARD SIDE OF STEP NR 2. INSTALLED EXTERNAL DOUBLER AND REPAIR ANGLES PER CRJ700/900 SRM 51-42-06.SDR SWIA200718358Web · crackedPAX DOOR WEB CRACKED AT AFT SIDE OF NR 2 STEP, DISCOVERED AT C-CHECK. INSTALLED EXTERNAL DOUBLER AND REPAIR ANGLES IAW CRJ 700 SRM 51-42-06.
Back to N774SK