N703SK
Service difficulty reports · 246
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 = 'N703SK' 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 = 'N703SK' 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 SWIA201541232Skin · gougedINTERIOR OF LT LOWER FWD CORE COWL GOUGED. JUST AFT OF ENGINE DRAIN HOLES. C-CHECK RO 5/23/15, COMPLIED WITH REPAIR OF LT LOWER FWD CORE COWL FIRE-SHIELD GOUGE. IAW REO.SDR SWIA201541230Intercostal · corrodedPASSENGER DOOR INTERCOSTAL CORRODED, ABOVE PRESSURE DOOR CUT OUT. REMOVED CORROSION, NDT'D, EVALUATED, FOUND TO BE WITHIN LIMITS, RESTORED FINISH IAW STS EA.SDR SWIA201541231Step · corrodedPAX DOOR BOTTOM STEP PANEL ASSY HAS CORROSION AT BOTTOM FLANGE. REPAIRED PAX DOOR BOTTOM STEP PANEL ASSY AT BOTTOM FLANGE REF EA.SDR SWIA201540939Skin · dentedTWO DENTS JUST BELOW THE AFT BAGGAGE BAY DOOR BS 1000 -1015 BETWEEN STRINGERS 15 AND 16L. REPAIRED IAW REO.SDR SWIA201541233Skin · corrodedCORROSION PRESENT AT INSIDE LIP SKIN OF MAIN AVIONICS BAY DOOR OPENING. REMOVED CORROSION IAW REO. REINSPECT IAW REO REQUIREMENTS AND IAW NDTM. C-CHECK RO 5/23/15. REMOVED CORROSION IAW REO.SDR SWIA2014112540162Receiver · faultyLOCALIZER RECEIVERS FAIL INTERMITTENTLY. R & R NR 1 AND 2 VIR-432 IAW AMM.SDR SWIA201438946Light · inoperativeFWD LEFT EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R FWD LEFT NR 1 EXTERIOR EMERGENCY LIGHT IAW AMM. OPS CHECKED GOOD.SDR SWIA201437521Tru · failedNR 2 TRU IS SMOKING. R & R THE TRU ,SDR SWIA201437410Seal · dirtyMAIN CABIN DOOR HANDLE STICKS AND WILL NOT OPEN. CLEANED MAIN CABIN DOOR SEAL AS REQUIRED. DOOR OPERATES NORMALLY. NO DEFECTS NOTED.SDR SWIA201436763Lamp · burned outEMERGENCY EXIT SIGN IS BURNED OUT, REPLACED LAMP.SDR SWIA201436585Controller · failedRECEIVED CABIN ALT WARNING MESSAGE. FOLLOWED QRH PROCEDURE. SMELL OF SMOKE & LIGHT HAZE IN THE CABIN. FLT 5506 REPLACED NR 1 ACSC IAW AMM. OPERATIONS CHECKED GOOD. PRESSURIZED AIRCRAFT WITH NO FAULTS IN MANUAL MODE. NO HAZE OR SMOKE SMELL DETECTED DURING SDR SWIA201436347Light · inoperativeCTR CEILING EMERGENCY LIGHT BETWEEN ROWS 20 & 21 IS BURNED OUT. FLT 5176 RELAMPED.SDR SWIA201436039Light · inoperativeEMERGENCY EXIT FLOOD LIGHTS AT MAIN CABIN DOOR BULB IS BURNED OUT. FLT 5189 RELAMPED.SDR SWIA201335415Lug · corrodedHORIZONTAL STABILIZER LUG NR 1 OTBD FACE HAS FRETTING, 1ST LUG FROM THE LEFT. C-CHECK REPAIRED DAMAGE ON HORIZONTAL STABILIZER LUG NR 1 OTBD FACE, 1ST LUG FROM THE LEFT IAW REO.SDR SWIA201335417Bulkhead · corrodedLT FS 280 LOWER BULKHEAD WEB IS CORRODED BEYOND LIMITS. C-CHECK REPLACED LT FS 280 LOWER BULKHEAD WEB IAW REO.SDR SWIA201335416Bulkhead · corrodedRT FS 280 LOWER BULKHEAD WEB IS CORRODED BEYOND LIMITS. C-CHECK REPLACED RT FS 280 LOWER BULKHEAD WEB IAW REO.SDR SWIA201335422Floorbeam · crackedLT COCKPIT FLOOR BEAM CRACKED AT FS 274 LBL 12 WL 71.5. C-CHECK REPAIRED LT CRACKED FLOOR BEAM AT FS 274, LBL 12, WL 71.5, IAW REO.SDR SWIA201335421Floorbeam · crackedRT COCKPIT FLOOR BEAM CRACKED AT FS 274 RBL 12 WL 71.5. C-CHECK REPAIRED RT CRACKED FLOOR BEAM AT FS 274, RBL 12, WL 71.5 IAW REO.SDR SWIA201335420Door · chafedPAX DOOR FWD PULL-IN LEVER ASSEMBLY CHAFED. C-CHECK REPAIRED PAX DOOR PULL-IN LEVER ASSEMBLY IAW REO.SDR SWIA201335419Structure · crackedCRACK AT INTERNAL FWD EQUIPMENT COMPARTMENT CLOSE TO TRU€™S WL79.50 & FS202.75. C-CHECK REPAIRED CRACK AT INTERNAL FWD EQUIPMENT COMPARTMENT CLOSE TO TRU€™S WL79.50 & FS202.75 IAW REO.SDR SWIA201335418Structure · crackedCRACK AT FWD EQUIPMENT COMPARTMENT CLOSE TO ADG PUMP WL79.50 & FS202.75. C-CHECK REPAIRED CRACK AT FWD EQUIPMENT COMPARTMENT CLOSE TO ADG PUMP WL79.50 & FS202.75 IAW REO.SDR SWIA201333769Light · inoperativeEMERGENCY OVERHEAD LIGHT IN GALLEY REAR IS BURNED OUT. FLT#6213 RELAMPED.SDR SWIA201333632Light · inoperativeNR 3 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. RELAMPED.SDR SWIA201232344Light · inoperativeNR 2 OVERHEAD LIGHT IN CABIN BURNED OUT. (FLT 6476) RELAMPED OVERHEAD LIGHT.SDR SWIA201232219Light · inoperativeAFT EMERGENCY OVERHEAD LIGHT IS BURNED OUT. (FLT 5601) RELAMPED EMERGENCY LIGHT.SDR SWIA201232199Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS BURNED OUT. (FLT 5526) RELAMPED EMERGENCY LIGHT.SDR SWIA201231815Light · inoperativeLEFT EMERGENCY ROW OVERHEAD LIGHT STRIP IS INOPERATIVE. (FLT 5177) RELAMPED EMERGENCY LIGHT.SDR SWIA201230980Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5497) RELAMPED EMERGENCY LIGHT.SDR SWIA201230396Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230260Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5326) RELAMPED EMERGENCY LIGHT.SDR SWIA201230201Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6483) RELAMPED EMERGENCY LIGHT.SDR SWIA201230170Mcu · failedSTAB CHANNEL 1 IS INOPERATIVE. (FLT 5204) REPLACED THE MCU IN REF TO AMM. P/N 7074-5 S/N OFF 435.SDR SWIA201229901Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6421) RELAMPED EMERGENCY LIGHT.SDR SWIA201229243Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229244Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6259) RELAMPED EMERGENCY LIGHT.SDR SWIA201229194Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201129000Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6230) RELAMPED EMERGENCY LIGHT.SDR SWIA201128869Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6425) RELAMPED EMERGENCY LIGHT.SDR SWIA201128786Light · inoperativeOVERHEAD AFT EMERGENCY LIGHT IS OUT. (FLT 5507) RELAMPED EMERGENCY LIGHT.SDR SWIA201128523Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5156) RELAMPED EMERGENCY LIGHT.SDR SWIA201128522Light · inoperativeRIGHT AFT EXTERIOR EMERGENCY LIGHT IS OUT. (FLT 5160) RELAMPED EMERGENCY LIGHT.SDR SWIA201128448Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5529) RELAMPED EMERGENCY LIGHT.SDR SWIA201128449Display · defectiveSMELL OF SMOKE IN COCKPIT. (FLT 5459) TRACED SMELL OF SMOKE TO FMS CDU. REPLACED FMS CDU. P/N 822-0021-202 S N OFF 34C9NSDR SWIA201128221Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT DOES NOT WORK. (FLT 6462) RELAMPED EMERGENCY LIGHT.SDR SWIA201127499Light · inoperativeNR 3 AND NR 5 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 6351) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127482Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6209) RELAMPED EMERGENCY LIGHT.SDR SWIA201127394Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6237) RELAMPED EMERGENCY LIGHT.SDR SWIA201127395Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6231)RELAMPED.SDR SWIA201127332Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6203) RELAMPED EMERGENCY LIGHT.SDR SWIA201127123Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6389) RELAMPED EMERGENCY LIGHT.
Back to N703SK