N692SW, cancelled Sep 7, 2017
Service difficulty reports · 434
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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 SWAA091154Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 5R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091143Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500A, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091142Stringer Clip · crackedDURING SCHEDULED 24Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 706, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091141Slide · out of positionDURING SCHEDULED 24Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA090738Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 969, STR 22L. REPAIRED SKIN PER SWA EA.SDR SWAA090737Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND SKIN CRACKED AT BS 955, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA086266Light · inoperativeFLT ATTENDANTS REPORTED ELECTRICAL SMOKE SMELL AT ROW 12 TO ROW 14. CEILING LIGHTS INOP IN SAME ROW. RELAMPED LIGHTS PER MM.SDR SWAA085490Bear Strap · corrodedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN BEAR STRAP AROUND AFT SERVICE PANEL CORRODED BETWEEN BS 947.5 TO BS 967, STR 25L. REMOVED AND REPLACED BEAR STRAP PER SRM.SDR SWAA085489Stringer · corrodedDURING SCHEDULED MV2 CHECK, FOUND STRINGER CORRODED BS 907, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA085488Stringer · corrodedDURING SCHEDULED MV2 CHECK, FOUND STRINGER CORRODED BS 927, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA085487Stringer · corrodedDURING SCHEDULED MV2 CHECK, FOUND STRINGER CORRODED BS 1013, STR 27L. REPAIRED STRINGER PER SRM.SDR SWAA085486Stringer · corrodedDURING SCHEDULED MV2 CHECK, FOUND STRINGER CORRODED BETWEEN BS 933 TO BS 973, STR 26L. REPAIRED STRINGER PER SRM.SDR SWAA085485Shear Tie · corrodedDURING SCHEDULED MV2 CHECK, FOUND SHEAR TIE CORRODED AT BS 927.5, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085484Shear Tie · corrodedDURING SCHEDULED MV2 CHECK, FOUND SHEAR TIE CORRODED AT BS 947.5, STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085483Shear Tie · corrodedDURING SCHEDULED MV2 CHECK, FOUND SHEAR TIE CORRODED AT BS 947.5, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA085259Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND SKIN CRACKED AT BS 863, STR 25L. REPAIRED PER SWA EA.SDR SWAA085107Light · inoperativeDURING SCHEDULED MV2 CHECK, FOUND LT AFT FUSELAGE EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA084790Charger · faultyRIGHT AFT CABIN EMERGENCY EXIT LIGHTS ON. REMOVED AND REPLACED BATTERY CHARGER PER MM.SDR SWAA084641Slide · out of adjustR2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA082270Hinge Fitting · corrodedDURING SCHEDULED SPV CHECK, FOUND RIGHT WING NR 6 SPOILER INBOARD HINGE FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA081496Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FWD CARGO DOOR SKIN CRACKED AT DOOR HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA080911Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 930, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA080040Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 294 AND BS 312, STR 23R AND STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA080039Frame · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 328, STR 20R. REPAIRED FRAME PER SRM.SDR SWAA075389Skin · crackedDURING SCHEDULED OTS CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 948, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA074615Tank · fodAIR TURNBACK/INFLIGHT SHUTDOWN. CLIMBING THROUGH 22,000 FT NOTICED FUEL INBALANCE. ATTEMPTED TO BALANCE FUEL, RT FUEL TANK FELL 2,000 POUNDS BELOW LT FUEL TANK. INSPECTED FUEL SYSTEM, NO DEFECTS FOUND PER MM. AIRBORNE FROM BNA TO HOU WITH CROSSFEED VALVE OSDR SWAA074453Slide · out of adjustDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR PER MM.SDR SWAA074452Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 513B, STR 17L. REPAIRED SKIN PER SWA EA.SDR SWAA074433Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 510D, STR 15L. REPAIRED SKIN PER SWA EA.SDR SWAA074451Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 729E, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA072407Pressure Panel · crackedDURING SCHEDULED MV1 CHECK, FOUND NLG W/W PRESSURE PANEL WEB CRACKED AT RIGHT BS 239, WL 170. REPAIRED WEB PER SWA EA.SDR SWAA072406Pressure Panel · crackedDURING SCHEDULED MV1 CHECK, FOUND NLG W/W PRESSURE PANEL WEB CRACKED AT RIGHT BS 246, WL 170. REPAIRED WEB PER SWA EA.SDR SWAA071496Stringer · crackedDURING SCHEDULED MV2 CHECK, FOUND STRINGER 24L CRACKED AT BS 747. REPAIRED STRINGER PER SRM.SDR SWAA071139Door Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT CARGO DOOR CUTOUT FWD FRAME CRACKED AT LOWER CORNER. REPAIRED FRAME PER SRM.SDR SWAA071140Battery Pack · dischargedDURING SCHEDULED 22Y CHECK, FOUND AFT CABIN EMERGENCY EXIT LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA071046Stringer Splice · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 907, STR 25L. REMOVED AND REPLACED STRINGER SPLICE PER ER.SDR SWAA070912Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 1016, LBL 35 TO RBL 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA070857Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CORRODED AT BS 986, RBL 50. REPAIRED WEB PER SRM.SDR SWAA070682Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 986.5, STR 19R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA070683Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND BULKHEAD FRAME CRACKED AT BS 1016, STR 6R. REPAIRED CHORD PER SRM.SDR SWAA070681Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 992, RBL 50, WL 209. REPAIRED FRAME SECTION PER ER.SDR SWAA070680Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME SECTION PER ER.SDR SWAA070633Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 24R CORRODED AT BS 932. REPAIRED STRINGER PER SRM.SDR SWAA070591Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA070592Stiffener · crackedDURING SCHEDULED 22Y CHECK, FOUND BULKHEAD VERTICAL STIFFENER CRACKED AT BS 178, LBL 5.7, WL 184. REPAIRED STIFFENER PER SRM.SDR SWAA070552Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA070548Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 277 TO BS 294, RBL 55, WL 208. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA070549Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 26 TO LBL 54. REPAIRED FLOORBEAM PER SRM.SDR SWAA070551Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 492, STR 27R. REPAIRED SKIN PER ER.SDR SWAA070550Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, RBL 9 TO RBL 13. REPAIRED BULKHEAD PER SRM.
Back to N692SW, cancelled Sep 7, 2017