N604SW, cancelled Aug 5, 2019
Service difficulty reports · 304
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 = 'N604SW' AND deregistration_id = 'N604SW-2019-08-05' 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 = 'N604SW' AND deregistration_id = 'N604SW-2019-08-05' 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 SWAA092007Connector · brokenAT APPROXIMATELY 20,000 FT ON CLIMBOUT, RECEIVED RIGHT RED & GREEN LIGHT. CYCLED GEAR, LIGHTS EXTINGUISHED. REMOVED AND REPLACED CONNECTOR D4536P PER MM.SDR SWAA090414Slide · out of positionDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR EMERGENCY EVACUATION SLIDE OUT OF POSITION. REPOSITIONED SLIDE PER MM.SDR SWAA090413Track · delaminatedDURING SCHEDULED HC1 CHECK, FOUND RT EEPLS TRACK DELAMINATED AT ROW 1. REMOVED AND REPLACED EEPLS PER MM.SDR SWAA090383Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND NLG W/W LT SIDEWALL CRACKED FWD OF DOOR CONTROL PIVOT ROD. REPAIRED SIDEWALL SKIN PER SWA EA.SDR SWAA087316Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 377, RBL 70, WL 208. REMOVED AND REPLACED WEB PER SRM.SDR SWAA087315Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 304, WL 234. REPAIRED SKIN PER ER.SDR SWAA087314Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RT R1 DOOR LOWER HINGE CUTOUT, BS 304, WL 257. REPAIRED SKIN PER ER.SDR SWAA087313Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT RT R1 DOOR LOWER HINGE CUTOUT, BS 290, WL 228. REPAIRED SKIN PER ER.SDR SWAA087295Wire · inoperativeDURING SCHEDULED SPV CHECK, FOUND FWD GALLEY EMERGENCY EXIT SIGN INOP. REPAIRED WIRE PER MM.SDR SWAA087294Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 397, RBL 70, WL 208. REPAIRED WEB PER SRM.SDR SWAA087293Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT L2 DOOR LOWER AFT ENTRY CUTOUT. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA087208Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA087207Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT, BS 290, WL 234. REPAIRED SKIN PER SWA EA.SDR SWAA087206Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087205Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087201Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 667 TO BS 671, RBL 24. REPAIRED CHORD PER ER.SDR SWAA087199Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA087128Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA087218Flashlight · brokenDURING SCHEDULED SPV CHECK, FOUND FLASHLIGHT IN AFT LT WINDSCREEN BROKEN. REMOVED AND REPLACED FLASHLIGHT ASSY PER MM.SDR SWAA086968Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA086812Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA086811Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA076369Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND RT HORIZONTAL STABILIZER LOWER SKIN CRACKED AT BS 131. REPAIRED SKIN PER SRM.SDR SWAA074822Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA074115Slide · out of positionL1 DOOR EMERGENCY EVAC SLIDE FELL OUT, DID NOT DEPLOY. INSTALLED EVAC SLIDE PER MM.SDR SWAA073495Hook · looseL1 DOOR EVAC SLIDE GIRT BAR HOOKS LOOSE. SECURED GIRT BAR HOOKS PER MM.SDR SWAA073067Skin · crackedDURING SCHEDULED BRDG CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 410, LBL 1. REPAIRED SKIN PER SWA EA.SDR SWAA073044Girt Bar · crackedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA073045Girt Bar · crackedDURING SCHEDULED BRDG CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA073046Girt Bar · crackedDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED FITTING PER MM.SDR SWAA072987Bearing · wornDURING SCHEDULED BRDG CHECK, RIGHT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BEARING AND BUSHING PER MM.SDR SWAA072986Bushing · wornDURING SCHEDULED BRDG CHECK, RIGHT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED NR 1 HINGE BUSHING PER MM.SDR SWAA062705Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND R2 DOOR EMERGENCY EXIT EXTERIOR LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA053640Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED SLIDE PER MM.SDR SWAA053387Relay · faultyAIR TURNBACK, SMOKE AND BURNING ELECTRICAL SMELL IN COCKPIT AND CABIN. REMOVED AND REPLACED R3 RELAY IAW MM.SDR SWAA053302Skin · delaminatedDURING SCHEDULED RON, FOUND RT INBD T/E AFT FLAP DELAMINATED. REPAIRED FLAP PER SWA EA.SDR SWAA052288Bushing · failedDURING SCHEDULED C4 CHECK, RT ELEVATOR TAB FAILED THE FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR TAB NR 1 HINGE BUSHINGS & HARDWARE PER MM.SDR SWAA052312Hinge Bracket · crackedDURING SCHEDULED C4 CHECK, FOUND L1 DOOR UPPER HINGE BOX FITTING CRACKED. REMOVED AND REPLACED UPPER HINGE BOX PER SRM.SDR SWAA052116Uplock Sensor · faultyRT MLG UNSAFE LIGHT INDICATION, RECYCLED GEARS AND LIGHT EXTINGUISHED. REMOVED AND REPLACED RT MLG UPLOCK SENSOR PER MM.SDR SWAA050222Lens · looseDURING SCHEDULED PM CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT LENS, LOOSE. REMOVED AND REPLACED LIGHT LENS PER MM.SDR SWAA043676Beam · crackedDURING SCHEDULED D-CHECK, FOUND STUB BEAM AT BS 616, RBL 64, CRACKED. REPAIRED STUB BEAM PER ER.SDR SWAA043645Door Frame · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPARTMENT FRAME AT BS 787, RBL 10, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043644Stop Fitting · crackedDURING SCHEDULED D-CHECK, FOUND FWD CARGO DOOR AFT FRAME, LOWER STOP FITTING, CRACKED. REPAIRED FRAME PER ER.SDR SWAA043642Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND HORIZONTAL STAB FITTING RT AND LT FWD AND AFT CLEVIS LUGS CORRODED. REPAIRED HORIZONTAL STAB PER ER.SDR SWAA043636Structure · warpedDURING SCHEDULED D-CHECK, FOUND RT WING OUTBOARD T/E FORE FLAP, WARPED. REMOVED AND REPLACED RT WING OUTBOARD T/E FORE FLAP PER MM.SDR SWAA043627Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 295 TO BS 299, RBL 55, CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA043626Rib · crackedDURING SCHEDULED D-CHECK, FOUND LT AND RT WINGS LOWER RIB CHORDS AT WBL 135.5, CRACKED. REPAIRED RIB CHORDS PER ER.SDR SWAA043622Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB FROM BS 330 TO BS 335, RBL 55, CORRODED. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA043621Frame · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPT FRAME AT BS 767, RBL 12, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043620Stringer Clip · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 747, STRINGER 26R, CORRODED. REMOVED AND REPLACED STRINGER CLIP PER SRM.
Back to N604SW, cancelled Aug 5, 2019