N762SK
Service difficulty reports · 169
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 = 'N762SK' 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 = 'N762SK' 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 SWIA201540930Structure · crackedFWD EQUIPMENT COMPARTMENT LANDING CRACKED ON LT SIDE AT BS 193 AND WL 79.5. REPAIRED IAW REO.SDR SWIA201540934Latch · chafedLEFT NACELLE LATCH DOOR ASSY CHAFED. REPAIRED IAW EA.SDR SWIA201540924Attach Fitting · gougedFROM THE FWD SIDE OF PAX DOOR TO MIDLINE- THE HINGE LUGS 5,6 AND 11 AND LUGS FROM THE AFT SIDE OF PAX DOOR TO MIDLINE, AT 1-5, AND 9 AND 10, ON PAX DOOR HINGE HALF, MARKED, ARE GOUGED/NICKED, C-CHECK, RO 3/24/15. REPAIRED PAX DOOR HINGE, DOOR SIDED, CHAFED LUSDR SWIA201439081Battery Pack · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. R & R BATTERY, OPS CHECK GOOD.SDR SWIA201437871Light · damagedINTERIOR EMERGENCY LIGHT JUST AFT OF THE SERVICE DOOR IS DAMAGED. REPLACED INTERIOR EMERGENCY FLOOD LIGHT ASSY IAW AMM.SDR SWIA201437060Battery Pack · dischargedLAST TWO EMERGENCY LIGHTS DO NOT ILLUMINATE, RECHARGED THE BATTERY PACKS.SDR SWIA201335714Ballast · faultyBURNED ODOR AROUND ROW 2C. OVERHEAD LIGHTS EXTINGUISHED OVER THE SAME ROW. FLT 6226 REPLACED BALLAST FOR OVERHEAD LIGHTS AT ROW 2 SEATS CD.SDR SWIA201334817Panel · chafedRT WING INBD FLAP PANEL 684 ET CHAFED OUT OF LIMITS. C-CHECK REPLACED RT WING INBD FLAP PANEL 684 ET IAW SRM.SDR SWIA201334818Stringer · crackedFS 280 STRINGER 3L CRACK. C-CHECK REPAIRED CRACK IAW REO.SDR SWIA201334819Structure · chafedCHAFE GOUGE JUST AFT OF FS 977.00 AT STRINGER 27. C-CHECK REPAIRED IAW REO.SDR SWIA201333033Light · inoperativeEXIT ROW OVERHEAD EMERGENCY EXIT LIGHT BURNED OUT. (FLT 6249) RELAMPED EMERGENCY LIGHT.SDR SWIA201232359Light · inoperativeNR 1 OVERHEAD LIGHT BURNED OUT. (FLT 6304) RELAMPED OVERHEAD LIGHT.SDR SWIA201232100Bushing · corrodedTHE LEFT ENGINE FORWARD MOUNT UPPER LINK HAS CORROSION ON THE BUSHINGS. (SERVICE) INSTALLED A SERVICABLE LEFT ENGINE FORWARD MOUNT UPPER LINK.SDR SWIA201232039Light · inoperativeONE BULB IS OUT ON FLOOR LEVEL EMERGENCY EXIT ROW ON AIRCRAFT'S RIGHT SIDE. (FLT 5782) RELAMPED EMERGENCY LIGHT.SDR SWIA201231946Connector · disconnectedNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6365) FOUND CONNECTER TO NR 1 EMERGENCY LIGHT DISCONNECTED AND WAS RECONNECTED.SDR SWIA201230726Light · inoperativeOVERHEAD EMERGENCY LIGHT IS OUT NEXT TO HINGE OF SERVICE DOOR. (FLT 5216) RELAMPED EMERGENCY LIGHT.SDR SWIA201230725Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5480) RELAMPED EMERGENCY LIGHT.SDR SWIA201230513Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6353) RELAMPED EMERGENCY LIGHT.SDR SWIA201230370Panel · wornRIGHT AILERON UPPER FIXED LEADING EDGE WORN. (C-CHECK) REPLACED RIGHT AILERON UPPER FIXED LEADING EDGE PANEL IN REFERENCE TO SRM.SDR SWIA201230369Panel · wornLEFT AILERON UPPER FIXED LEADING EDGE WORN. (C-CHECK) REPLACED LEFT AILERON UPPER FIXED LEADING EDGE PANEL IN REFERENCE TO SRM.SDR SWIA201230342Beam · crackedC-CHECK, FS 280 BEAM CRACKED AT LBL 11.0 AND RBL 11.0. REPAIRED FS 280 BEAM CRACKED AT LBL 11.0 AND RBL 11.0.SDR SWIA201230141Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6324) RELAMPED EMERGENCY LIGHT.SDR SWIA201230341Skin · dentedC-CHECK, DENT FOUND ON RIGHT INBOARD LEADING EDGE ABOVE LANDING LIGHT LENS. REPAIR DENT ON RIGHT INBOARD LEADING EDGE ABOVE LANDING LIGHT LENS.SDR SWIA201229807Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5326) RELAMPED EMERGENCY LIGHT.SDR SWIA201229493Cover · missingFLOOR LEVEL EMERGENCY FLOOD LIGHT AT SERVICE DOOR COVER MISSING. (FLT 6273) REPLACED FLOOR LEVEL SERVICE DOOR EMERGENCY FLOOD LIGHT ASSEMBLY.SDR SWIA201229357Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5417) RELAMPED EMERGENCY LIGHT.SDR SWIA201229268Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6283) RELAMPED EMERGENCY LIGHT.SDR SWIA201129057Light · inoperativeNR 4 CEILING EMERGENCY LIGHT IS OUT. (FLT 6216) RELAMPED EMERGENCY LIGHT.SDR SWIA201128773Battery · dischargedAPPROXIMATELY 50 PERCENT OF INTERIOR EMERGENCY LIGHTS NOT WORKING. (FLT 6207) CHARGED EMERGENCY LIGHTS WITH APU GENERATOR PER AMM.SDR SWIA201128334Light · inoperativeNR 1 AND NR 2 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 5456) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128220Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 9 IS OUT. (FLT 5449) RELAMPED EMERGENCY LIGHT.SDR SWIA201128081Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6483) RELAMPED EMERGENCY LIGHT.SDR SWIA201127675Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5424) RELAMPED EMERGENCY LIGHT.SDR SWIA201127147Light · inoperativeNR 5 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201126856Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6348) RELAMPED EMERGENCY LIGHT.SDR SWIA201126575Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 15 IS OUT. (FLT 5314) RELAMPED EMERGENCY LIGHT.SDR SWIA201126026Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6616) RELAMPED EMERGENCY LIGHT.SDR SWIA201125986Light · inoperative#4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6414) RELAMPED EMERGENCY LIGHT.SDR SWIA201125511Light · inoperativeTHE 2ND TO LAST OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 1127) RELAMPED EMERGENCY LIGHT.SDR SWIA201125485Light · inoperativeRIGHT EXTERIOR NR 2 EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201125415Lamp · burned outAFT OVERHEAD EMERGENCY LIGHT INOPERATIVE. (FLT 6508) RELAMPED EMERGENCY LIGHT.SDR SWIA201024930Beam · crackedFS 280 BEAM CRACKED ON BOTH SIDES. (C-CHECK) REPLACE BEAM PER SRM.SDR SWIA201024918Light · inoperativeCEILING EMERGENCY FLOOD LIGHT INOPERATIVE, NR 2 FROM BACK OF AIRCRAFT. (FLT 6466) RELAMPED EMERGENCY LIGHT.SDR SWIA201024919Light · inoperativeMOST AFT CEILING EMERGENCY LIGHT INOPERATIVE. (FLT 6948) RELAMPED EMERGENCY LIGHT.SDR SWIA201024593Light · inoperativeNR 5 EMERGENCY CEILING LIGHT INOP. (FLT 6889) RELAMPED EMERGENCY LIGHT.SDR SWIA201024386Light · inoperativeNR 6 EMERGENCY CEILING LIGHT INOP. (FLT 6187) RELAMPED EMERGENCY LIGHT.SDR SWIA201024183Light · inoperativeAFT INTERIOR EMERGENCY FLOODLIGHT INOP. (FLT 6381) RELAMPED EMERGENCY LIGHT.SDR SWIA201023740Light · inoperativeCEILING LIGHT AT THE EMERGENCY EXIT ROW LEFT SIDE INOP. (FLT 6720) RELAMPED EMERGENCY LIGHT.SDR SWIA201023723Light · inoperativeMOST AFT CEILING EMERGENCY LIGHT INOP. (FLT 6217) RELAMPED EMERGENCY LIGHT.SDR SWIA200922860Light · inoperativeLAST AFT CEILING EMERGENCY FLOODLIGHT INOP. (FLT 5980) RELAMPED EMERGENCY LIGHT.
Back to N762SK