N767SK
Service difficulty reports · 109
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 = 'N767SK' 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 = 'N767SK' 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 SWIA2017102343895Housing · gougedTHE AFT CARGO DOOR OUTER HANDLE HOUSING IS GOUGED IN SEVERAL LOCATIONS. INSTALLED A NEW CARGO DOOR OUTER HANDLE ASSY IAW SRM. PERFORMED OPS TEST OF THE HANDLE IAW AMM. OPS TESTED GOOD.SDR SWIA2017102343894Stringer · corrodedSTRINGER 20R, BS 677 - 693 HAS CORROSION AROUND RIVET BUCKTAILS. REPAIRED THE STRINGER IAW REO. LEAK CHECKED GOOD.SDR SWIA2017102343890Floorbeam · corrodedBS 280 FLOORBEAM CORRODED OUT OF LIMITS. REMOVED AND REPLACED THE FLOORBEAM IAW SRM.SDR SWIA2017102343893Intercostal · corrodedBS 319.7, STRINGER 20R INTERCOSTAL HAS CORROSION. REMOVED AND INSTALLED A NEW INTERCOSTAL IAW SRM.SDR SWIA201743892Frame · corrodedFRAME BS 280 BETWEEN STRINGERS 25L TO 23R HAS CORROSION. COMPLIED WITH REO. COMPLIED WITH THE PRESSURE TEST OF REPAIRED AREA IAW AMM. NO DEFECTS WERE NOTED.SDR SWIA2017102343891Housing · chafedSERVICE DOOR EXTERNAL LATCH HANDLE, HOUSING IS CHAFED AT UPPER AREA OF PIVOT POINT. REMOVED AND REPLACED THE HANDLE HOUSING IAW SRM. LEAK CHECKED GOOD.SDR SWIA201440171Battery Pack · dischargedNO EMERGENCY LIGHTS. CHARGED EMERGENCY LIGHTS, OPS CHECKED ALL SEVERAL TIMES, NO FAULTS NOTED, OPS CHECK IS GOOD AT THIS TIME.SDR SWIA201439165Battery Pack · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. R & R FWD F/A PORTABLE EMERGENCY FLASHLIGHT BATTERY IAW AMM. OPS CHECKED GOOD.SDR SWIA201438823Battery Pack · inoperativeFWD F/A FLASHLIGHT IS INOPERATIVE. R & R THE FLASHLIGHT BATTERIES.SDR SWIA2014061838218Lamp · burned outSERVICE DOOR EMERGENCY FLOOD LIGHT BURNED OUT. REPLACED THE LAMP.SDR SWIA2014061838221Sign · brokenRED EMERGENCY LIGHT ON AFT EMERGENCY EXIT SIGN IS BROKEN. REPLACED RED CELL LIGHT COVER ON AFT EMERGENCY EXIT SIGN OVER ROW 1B.SDR SWIA201436878Battery Pack · failedTHIRD AFT OVERHEAD EMERGENCY LIGHT AND EMERGENCY EXIT LIGHT, ROW 18 DOES NOT ILLUMINATE. REPLACED NR 2 ELBP ,SDR SWIA201436750Axle · corrodedCORROSION FOUND ON MLG AXLE NR 1 ROOT RADIUS. REMOVED CORROSION ON NR 1 MLG AXLE ROOT RADIUS IAW REO.SDR SWIA201436749Axle · corrodedCORROSION FOUND ON MLG AXLE NR 2 ROOT RADIUS. C-CHECK, REMOVED CORROSION ON NR 2 MLG AXLE ROOT RADIUS IAW REO.SDR SWIA201436748Axle · corrodedCORROSION FOUND ON RIGHT MLG AXLE NR 3 ROOT RADIUS. REMOVED CORROSION IAW REO.SDR SWIA201436747Axle · corrodedCORROSION FOUND ON RT MLG AXLE NR 4 ROOT RADIUS. REMOVED CORROSION IAW REO.SDR SWIA201436751Sill · corrodedAFT CARGO DOOR SILL HAS CORROSION IN SEVERAL AREAS. REPLACED DOOR SILL IAW SRM.SDR SWIA201436752Skin · chafedSKIN CHAFED AT APPROX BS 969, NEAR STR 27. REPAIRED SKIN IAW SRM AND REO.SDR SWIA201335774Light · inoperativeEMERGENCY OVERHEAD LIGHT AT ROW 7 IS BURNED OUT. FLT 5603 RELAMPED.SDR SWIA201335569Light · inoperativeEMERGENCY OVERHEAD LIGHT BURNED OUT AT ROW 15. FLT 4966 RELAMPED.SDR SWIA201335462Light · inoperativeGALLEY EMERGENCY LIGHT BULB IS BURNED OUT. FLT 6398 RELAMPED.SDR SWIA201333940Light · inoperativeONE BULB IN FLOOR LEVEL EMERGENCY EXIT SIGN AT GALLEY SERVICE DOOR IS BURNED OUT. FLT# 6203 RELAMPED.SDR SWIA201333939Light · inoperativeONE BULB IN FLOOR-LEVEL EMERGENCY EXIT SIGN AT MAIN CABIN DOOR IS BURNED OUT. FLT#6203 RELAMPED.SDR SWIA201333470Selector Valve · failedGEAR DISAGREE WARNING MESSAGE ON TAKEOFF, AFTER PLACING LANDING GEAR LEVER IN THE UP POSITION. REPLACED LANDING GEAR SELECTOR VALVE, PERFORMED GEAR SWING WITH NO FURTHER FAULTS AT THIS TIME.SDR SWIA201333395Light · inoperativeEMERGENCY EXIT LIGHT BY MAIN CABIN DOOR IS BURNED OUT. (FLT 6217) RELAMPED EMERGENCY LIGHT.SDR SWIA201332903Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS BURNED OUT. (FLT 6209) RELAMPED EMERGENCY LIGHT.SDR SWIA201231950Control Handle · failedON DEPARTURE, RAISED LANDING GEAR AND RECEIVED A GEAR DISAGREE WARNING. (FLT 5175) REPLACED LANDING GEAR CONTROL HANDLE ASSEMBLY IN REFERENCE TO CMM AND AMM. P/N: 53344-3 S/N OFF: B0618.SDR SWIA201231878Selector · failedGEAR DISAGREE WHEN SELECTED UP. CYCLED GEAR, GEAR RETRACTED NORMALLY. (FLT 6239) REPLACED GEAR SELECTOR HANDLE ASSEMBLY IN REFERENCE TO AMM. P/N: 43344-3 S/N OFF: B0333.SDR SWIA201231837Floorbeam · corrodedFS 280 FLOORBEAM IS CORRODED. (C-CHECK) REPLACED FS 280 FLOORBEAM PER REO.SDR SWIA201231566Unknown · odorFLIGHT ATTENDANT SMELLED SMOKE IN CABIN. (FLT 6326) MAINTENANCE STARTED APU AND POWERED UP ALL ELECTRICAL SYSTEMS, AIR CONDITIONING PACKS, LIGHTING, ETC. AFTER EXTENDED PERIOD OF TIME NO SMOKE OR SMOKE SMELL.SDR SWIA201231127Light · inoperativeNR 1 AND NR 3 OVERHEAD EMERGENCY LIGHTS ARE OUT. (SERVICE) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230483Light · inoperativeOVERHEAD EMERGENCY LIGHT IS OUT AT ROW 15. (FLT 5216) RELAMPED EMERGENCY LIGHT.SDR SWIA201230165Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6356) RELAMPED EMERGENCY LIGHT.SDR SWIA201230089Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA2012021429658Circuit Board · failedFLT 5170, RECEIVED EMERGENCY LIGHTS ON STATUS MESSAGE. REPLACED JB11PCB5.SDR SWIA201229378Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5469) RELAMPED EMERGENCY LIGHT.SDR SWIA201229359Warning System · false activationEMERGENCY LIGHTS STATUS MESSAGE CAME ON. (FLT 5464) POWERED DOWN AIRCRAFT AND POWERED BACK UP.SDR SWIA201129055Light · inoperativeNR 5 CEILING EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201128651Light · inoperativeTHE 2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS BURNED OUT. (FLT 5294) RELAMPED EMERGENCY LIGHT.SDR SWIA201128187Light · inoperativeAFT 2 CEILING EMERGENCY LIGHTS ARE OUT. (FLT 6486) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128186Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5388) RELAMPED EMERGENCY LIGHT.SDR SWIA201128039Light · inoperativeAFT 2 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 6479) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127790Light · inoperativeAFT TWO EMERGENCY LIGHTS ARE INOPERATIVE. (FLT 5464) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127363Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2028) RELAMPED EMERGENCY LIGHT.SDR SWIA201127303Light · inoperativeAFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 2004) RELAMPED EMERGENCY LIGHT.SDR SWIA201127087Light · inoperativeNR 6 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5404) RELAMPED EMERGENCY LIGHT.SDR SWIA201126582Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 17 IS OUT. (FLT 6531) RELAMPED EMERGENCY LIGHT.SDR SWIA201126195Light · inoperativeMOST AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6895) RELAMPED EMERGENCY LIGHT.SDR SWIA201125629Light · inoperativeRIGHT SIDEWALL EMERGENCY LIGHT OUT. (FLT 6742) RELAMPED EMERGENCY LIGHT.SDR SWIA201024119Light · inoperativeEMERGENCY CEILING LIGHT AT ROW 15 INOP. (FLT 6145) RELAMPED EMERGENCY LIGHT.
Back to N767SK