N727SK
Service difficulty reports · 184
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 = 'N727SK' 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 = 'N727SK' 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 SWIA201642327Intercostal · corrodedPAX DOOR INTERCOSTAL DD6 CORRODED. REPLACED THE INTERCOSTAL IAW SRM.SDR SWIA201642326Web · corrodedPAX DOOR AFT WEB HAD OUT OF LIMITS CORROSION. REMOVED AND REPLACED THE DOOR AFT WEB IAW SRM.SDR SWIA201642323Frame · corrodedBS 349 LOWER FUSELAGE FRAME HAD OUT OF LIMITS CORROSION. REMOVED AND REPLACED THE FRAME SECTOR IAW SRM.SDR SWIA201642325Frame · corrodedBS 319 LOWER FUSELAGE FRAME HAD OUT OF LIMITS CORROSION. REPLACED THE FRAME IAW REO.SDR SWIA201642324Frame · corrodedBS 333 LOWER FUSELAGE FRAME HAD OUT OF LIMITS CORROSION. REPLACED THE FRAME SECTOR AND CLEATS IAW REO.SDR SWIA201642322Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT BS 295 HAD OUT OF LIMITS CORROSION. PERFORMED SPLICE REPAIR TO THE FRAME IAW REO.SDR SWIA201642321Frame · corrodedMAIN AVIONICS BAY LOWER FRAME AT BS 310 HAD OUT OF LIMITS CORROSION. REPLACED THE FRAME IAW REO.SDR SWIA201642318Structure · crackedLEFT TRU BAY FLOOR CRACKED AT CUT-OUT FOR FRAME BS 193. REPAIRED FLOOR IAW REO. OPS CHECKED GOOD.SDR SWIA201642320Door Sill · corrodedFOUND MULTIPLE SPOTS OF CORROSION ALONG AFT CARGO DOOR SILL. REPLACED THE DOOR SILL IAW SRM.SDR SWIA201642319Door Sill · corrodedFOUND MULTIPLE SPOTS OF CORROSION ON THE GALLEY SERVICE DOOR SILL. REMOVED AND REPLACED THE DOOR SILL IAW SRM.SDR SWIA201438752Battery Pack · dischargedEMERGENCY EXIT SIGN ON SIDE WALL LT SIDE OF ACFT INOPERATIVE. CHARGED NR 4 BATTERY PACK, SYSTEM OPS CHECKED GOOD IAW AMM.SDR SWIA201436455Light · inoperativeLOWER RT SIDE EXIT SIGN BY THE EMERGENCY EXIT DOOR HAS A LIGHT BURNED OUT. C CHECK REPLACED ONE BULB IN THE RT SIDE EXIT SIGN IAW AMM.SDR SWIA201436392Light · inoperativeSECOND TO LAST OVERHEAD EMERGENCY LIGHT IS BURNED OUT. FLT 5653 RELAMPED.SDR SWIA201436144Light · inoperativeFWD LOWER EMERGENCY EXIT SIGN NEXT TO MAIN CABIN DOOR IS BURNED OUT. FLT 5605 RELAMPED.SDR SWIA201335776Light · inoperative2ND FROM BOTTOM LIGHT BULB ON BOTTOM EMERGENCY EXIT SIGN ON RT SIDE OF AIRCRAFT BURNED OUT. FLT 6381 RELAMPED.SDR SWIA201334852Light · inoperativeEMERGENCY POD LIGHT BURNED OUT. FLT#5208 RELAMPED.SDR SWIA201334207Light · inoperativeCEILING EMERGENCY LIGHT IN AFT BURNED OUT. FLT#5530 RELAMPED.SDR SWIA201333493Light · inoperativeFORWARD FLOOR LEVEL EMERGENCY FLOOD LIGHT IS BURNED OUT. RELAMPED.SDR SWIA201333198Battery Pack · dischargedEMERGENCY OVERHEAD LIGHTS DO NOT ILLUMINATE. (FLT 5170) RECHARGED EMERGENCY BATTERY PACKS.SDR SWIA201333160Axle · corrodedCORROSION FOUND, NR 4 MLG AXLE ROOT. (C-CHECK) REPAIRED NR 4 MLG AXLE IAW REO.SDR SWIA201333159Axle · corrodedCORROSION FOUND, NR 1 MLG AXLE ROOT. (C-CHECK) REPAIRED NR 1 MLG AXLE IAW REO.SDR SWIA201333158Axle · corrodedCORROSION FOUND, NR 2 MLG AXLE ROOT. (C-CHECK) REPAIRED NR 2 MLG AXLE IAW REO.SDR SWIA201333157Axle · corrodedCORROSION FOUND, NR 3 MLG AXLE ROOT. (C-CHECK) REPAIRED NR 3 MLG AXLE IAW REO.SDR SWIA201333161Crossbeam · corrodedFS 280 CROSSBEAM IS CORRODED IN SEVERAL PLACES. (C-CHECK) REPLACED FS 280.0 CROSSBEAM IAW REO.SDR SWIA201332580Light · brokenGALLEY SERVICE DOOR FLOOR LEVEL EMERGENCY FLOODLIGHT BROKEN. (SERVICE) REPLACED FLOOR LEVEL FLOOD LIGHT.SDR SWIA201332518Light · inoperativeEMERGENCY EXIT LIGHTS AT ROW 12 AND MAIN CABIN DOOR ARE NOT WORKING. (FLT 5184) RELAMPED EMERGENCY EXIT SIGN.SDR SWIA201232093Light · inoperativeNR 2 EMERGENCY OVERHEAD LIGHT IS BURNED OUT. (FLT 5175) RELAMPED EMERGENCY LIGHT.SDR SWIA201231860Light · inoperativeLOWER EMERGENCY LIGHTS FOR GALLEY SERVICE DOOR HAS SEVERAL BULBS INOPERATIVE. (FLT 6424) RELAMPED EMERGENCY LIGHTS.SDR SWIA201231270Acm · malfunctionedSMOKE IN THE CABIN AND THE FLIGHT DECK. RECEIVED A LEFT PACK FAIL CAUTION MESSAGE. (FLT 5621) REPLACED THE LEFT AIR CYCLE MACHINE IAW AMM. P/N OFF: GG670-95009-5, S/N OFF: 01130SDR SWIA201230584Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5158) RELAMPED EMERGENCY LIGHT.SDR SWIA201230515Light · inoperativeNR 1 AND NR 2 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 5157) RELAMPED EMERGENCY LIGHTS.SDR SWIA201230395Light · inoperativeNR 2 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201230300Lamp · burned outFLT 6381, AFT OVERHEAD EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT.SDR SWIA201230264Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201229552Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 6390) RELAMPED EMERGENCY LIGHT.SDR SWIA201229551Light · inoperativeNR 3 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5363) RELAMPED EMERGENCY LIGHT.SDR SWIA201229437Light · inoperativeAFT EMERGENCY LIGHT IS OUT. (FLT 5316) RELAMPED EMERGENCY LIGHT.SDR SWIA201229192Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5519) RELAMPED EMERGENCY LIGHT.SDR SWIA201128702Unknown · vibrationDURING CRUISE RIGHT N1 VIBES STARTED SLOWLY RISING TO 1.6 THEN UP TO 2.0, RAN QRH PROCEDURE, AND PULL BACK THE ENGINE TO ACCEPTABLE LEVELS TO HOLD ACCEPTABLE SPEED AT ALTITUDE N1 HAD TO BE AT 74 PERCENT. ENGINE VIBES SLOWLY DEGRADED. (FLT 5194) SHOOK BLADESSDR SWIA201128648Light · inoperativeCEILING EMERGENCY LIGHTS ABOVE ROWS 13 & 14 ARE OUT. (FLT 5324) RELAMPED EMERGENCY LIGHTS.SDR SWIA201128346Light · inoperativeNR 5 OVERHEAD EMERGENCY LIGHT IS OUT. (SERVICE) RELAMPED EMERGENCY LIGHT.SDR SWIA201127885Light · inoperativeAFT 3 OVERHEAD EMERGENCY LIGHTS ARE OUT. (FLT 6392) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127584Floorbeam · corrodedFS 280 FLOORBEAM CORRODED. (C-CHECK) REPLACE PER SRM.SDR SWIA201130457Web · crackedPASSENGER DOOR AFT WEB CRACKED ON UPPER MOTOR 2 ANGLES. (C-CHECK) REPAIRED PASSENGER DOOR AFT WEB.SDR SWIA201128176Light · inoperativeNR 5 AND 6 OVERHEAD EMERGENCY LIGHTS DO NOT ILLUMINATE. (FLT 5507) RELAMPED EMERGENCY LIGHTS.SDR SWIA201127163Light · inoperative2ND FROM AFT OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5457) RELAMPED EMERGENCY LIGHT.SDR SWIA201126696Light · inoperativeNR 4 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5457) RELAMPED EMERGENCY LIGHT.SDR SWIA201126547Light · inoperativeNR 1 OVERHEAD EMERGENCY LIGHT IS OUT. (FLT 5522) RELAMPED EMERGENCY LIGHT.SDR SWIA201126237Light · inoperativeOVERHEAD EMERGENCY LIGHT ABOVE ROW 14 IS OUT. (FLT 7007) RELAMPED EMERGENCY LIGHT.SDR SWIA201125846Light · inoperativeNR 4 CEILING EMERGENCY LIGHT IS OUT. (FLT 6437) RELAMPED EMERGENCY LIGHT.
Back to N727SK