N708SK
Service difficulty reports · 175
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 = 'N708SK' 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 = 'N708SK' 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 SWIA201743260Frame · corrodedMAIN AVIONICS BAY: CORROSION ON FRAME BS 310 BETWEEN STRINGERS 25 - 27R. REPAIRED IAW REO.SDR SWIA201743259Floorbeam · corrodedMAIN AVIONICS BAY, CORROSION FOUND ON THE FLOORBEAM ANGLE AFT OF FRAME BS 280 BETWEEN STRINGERS 26L- 26R . AROUND THE NUT PLATE HOLES. REMOVED AND REPLACED THE FLOORBEAM ANGLE IAW SRM.SDR SWIA201541297Intercostal · corrodedPAX DOOR INTERCOSTAL CORRODED. BLENDED OUT CORROSION AREA ON PAX DOOR INTERCOASTAL, IAW SRM.SDR SWIA201541301Rib · damagedRIGHT WING L/E RIB, SS 58.41, AT INBD. SLAT SEAL RETAINER ATTACHMENT, UPPER END AREA, 2 RIVET HOLES ELONGATED. REPAIRED RT INBD WING L/E RIB, SS 58.41, AT INBD L/E UPPER AREA, ELONGATED HOLES IAW REO.SDR SWIA201541293Frame · corrodedBS 349 FRAME HAS CORROSION. BLENDED AND RESTORED AREA IAW SRM.SDR SWIA201541292Stringer · corrodedAVIONICS BAY STRINGER 26L AT BS 362 -364 CORRODED. REPAIRED THE STRINGER IAW SRM.SDR SWIA201541300Arm · gougedLEFT NLG DOOR AFT HINGE ARM HAS A GOUGE. REPAIRED LT NLG AFT HINGE ARM IAW STS EA.SDR SWIA201541296Skin · chafedLEFT UPPER TRANSCOWL HAS CHAFING ON THE FORWARD OTBD CORNER. REPAIRED LT UPPER TRANSCOWL CHAFED IAW REO.SDR SWIA201541295Skin · chafedLEFT LOWER TRANSCOWL HAS CHAFING ON THE FORWARD OTBD CORNER. REPAIRED LT LOWER TRANSCOWL CHAFED IAW REO.SDR SWIA201541294Skin · chafedLEFT LOWER TRANSCOWL HAS CHAFING ON THE UPPER SIDE OF THE OTBD SLIDER. REPAIRED LT LOWER TRANSCOWL CHAFING ON THE UPPER SIDE OF THE OTBD SLIDER IAW REO.SDR SWIA201541291Striker · dentedPASSENGER DOOR SURROUND, UPPER END OF AFT SEAL STRIKER DENTED. REPAIRED PASSENGER DOOR UPPER AFT SEAL STRIKER AREA IAW REO.SDR SWIA201541302Floorbeam · corrodedFLOORBEAM BETWEEN RBL9 AND LBL9, COCKPIT ENTRANCE, ATOP 280 BEAM CORRODED. REPLACED COCKPIT FLOORBEAM IAW SRM.SDR SWIA201541299Panel · crackedAFT DORSAL STRAKE FAIRING PANEL 321CT CRACK ON AFT SECTION. REPAIRED CRACK IN AFT SECTION OF THE AFT DORSAL STRAKE FAIRING PANEL 321CT IAW STS EA.SDR SWIA201541298Skin · dentedRT WING INBD L/E SLAT LOWER T/E HAS DENT. REPAIRED DENT ON RT WING INBD L/E SLAT, LOWER T/E IAW STS EA.SDR SWIA201436182Shroud · damagedDAMAGE TO MLG TOP SKIN SHROUD AT WS 34.00 RT SIDE. SERVICE REPAIRED DAMAGE TO MLG TOP SKIN SHROUD AT WS 34.00 RT SIDE IAW REO.SDR SWIA201436097Sill · corrodedCORROSION FOUND AT FS 349 JUST BEHIND SERVICE DOOR ENTRANCE ON LOWER FLOOR SILL. C-CHECK REPAIRED FLOOR SILL AT FS 349.00 RBL 41 IAW STS EA.SDR SWIA201436095Structure · crackedCRACK FOUND ON AFT LT WING TO FUSELAGE FAIRING SUPPORT STRUCTURE STRINGER AT FS 909.00 STRINGER 24L. C-CHECK REPAIRED LT WING TO FUSELAGE FAIRING SUPPORT STRUCTURE STRINGER AT FS 909 STRINGER 24L IAW STS EA.SDR SWIA201436098Fitting · crackedFOUND A CRACK DURING NDT INSPECTION COMMON TO LT FWD MLG DOOR FITTING CTR HOLE. C-CHECK INSTALLED FREEZE PLUG & NOMINAL FASTENER IN DISCREPANT HOLE IAW REO.SDR SWIA201436096Sill · corrodedSERVICE DOOR FWD SILL HAS SIGNS OF CORROSION AROUND FWD NUTPLATE. C-CHECK SILL REPAIRED IAW SRM.SDR SWIA201436099Skin · chafedAT FS 977.00 ACFT AFT BELLY SKIN IS CHAFED. C-CHECK CHAFE AT FS 977.00 BELLY SKIN REPAIRED IAW REO.SDR SWIA201436100Floor Panel · crackedFWD EQUIPMENT COMPARTMENT HAS CRACK AT FLOOR PANEL ON RT SIDE LOWER CORNER JUST AFT OF HYD PUMP FOR ADG. C-CHECK PERFORMED REPAIR OF CRACK AT FLOOR PANEL ON RT LOWER CORNER AFT OF ADG PUMP IAW REO.SDR SWIA201334979Hydraulic Line · failedON SHORT FINAL ALL OF HYD NR 2 FLUID QUANTITY WAS LOST WITH ASSOCIATED CAUTION MESSAGE. FLT 6227 REPLACED NR 2 ACMP PRESSURE LINE, NR 2 EDP, NR 2 RETURN FILTER ELEMENT, CASE DRAIN ELEMENT & THE PRESSURE MANIFOLD FILTER ELEMENT IAW AMM.SDR SWIA201334976Light · inoperativeNR 4 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. FLT 550 RELAMPED.SDR SWIA201333742Light · inoperativeONE EMERGENCY OVERHEAD LIGHT DOES NO ILLUMINATE. FLT#5207 REPLACED NR 4 ELBP & RELAMPED THE EMERGENCY LIGHT. PN: AD-2013-1A SN ON: 84026 SN OFF: 77256SDR SWIA201333304Windshield · crackedCAPTAIN'S SIDE WINDSHIELD CRACKED. (FLT 6531) REPLACED CAPTAINS WINDSHIELD IAW AMM. P/N ON: NP134321-13 S/N ON: 11321H8217 P/N OFF: 601R33033-17 S/N OFF: 04068H7432SDR SWIA201332912Light · inoperativeEMERGENCY EXIT LIGHT NEXT TO SERVICE DOOR BURNED OUT. (FLT 6331) RELAMPED EMERGENCY LIGHT.SDR SWIA201231840Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6202) RELAMPED EMERGENCY LIGHT.SDR SWIA201231675Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 IS OUT. (FLT 6361) RELAMPED EMERGENCY LIGHT.SDR SWIA201231461Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5456) RELAMPED EMERGENCY LIGHT.SDR SWIA201231214Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6493) RELAMPED EMERGENCY LIGHT.SDR SWIA201230884Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5184) RELAMPED EMERGENCY LIGHT.SDR SWIA201230512Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5429) RELAMPED EMERGENCY LIGHT.SDR SWIA201230334Lamp · burned outFLT 5371, NR 4 OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201230333Lamp · burned outFLT 5403, NR 4 OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201229770Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6265) RELAMPED EMERGENCY LIGHT.SDR SWIA201229769Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6294) RELAMPED EMERGENCY LIGHT.SDR SWIA201229746Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5202) RELAMPED EMERGENCY LIGHT.SDR SWIA201202139655Lamp · burned outNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201202119654Lamp · burned outNR 2 OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. RELAMPED AND REPLACED COVER FOR NR 2 OVERHEAD LIGHT.SDR SWIA201128806Light · inoperativeOVERHEAD EMERGENCY LIGHT IS INOPERATIVE. (FLT 5392) RELAMPED EMERGENCY LIGHT.SDR SWIA201128626Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 4 IS OUT. (FLT 6508) RELAMPED EMERGENCY LIGHT.SDR SWIA201126261Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126081Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 6511) RELAMPED EMERGENCY LIGHT.SDR SWIA201125884Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6740) RELAMPED EMERGENCY LIGHT.SDR SWIA201125469Charger · failedSERVICE DOOR EMERGENCY LIGHT AT GALLEY IS OUT. (FLT 1112) REPLACED NR 1 EMERGENCY LIGHT BATTERY CHARGER.SDR SWIA201025260Light · inoperativeNR 2 EMERGENCY CEILING LIGHT INOPERATIVE. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201024988Lamp · burned out4TH AFT CEILING EMERGENCY LIGHT INOPERATIVE. (FLT 6688) RELAMPED.SDR SWIA201024949Light · inoperativeLIGHT BULB OUT ON EMERGENCY EXIT SIGN NEAR SERVICE DOOR. (FLT 6157) RELAMPED EMERGENCY SIGN.SDR SWIA201024852Light · inoperativeOVERHEAD EMERGENCY FLOODLIGHT INOPERATIVE AT FIRST CLASS. (FLT 6348) RELAMPED EMERGENCY LIGHT.SDR SWIA201024394Light · inoperativeFIRST CEILING EMERGENCY LIGHT INOP. (FLT 6844) RELAMPED EMERGENCY LIGHT.
Back to N708SK