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 SWAA043619Frame · corrodedDURING SCHEDULED D-CHECK, FOUND AFT CARGO COMPT FRAME AT BS 727E, BETWEEN RBL10 AND RBL 20, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043618Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPT FRAME AT BS 500B, BETWEEN LBL 6 AND RBL 6, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043604Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 270 FROM LBL 7 TO RBL 7, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD SECTION PER SRM.SDR SWAA043589Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM SHEAR WEB FROM BS 947 TO BS 1006, RBL 45, CORRODED. REMOVED AND REPLACED WEB PER SRM.SDR SWAA043583Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 500C, BETWEEN LBL 2 AND RBL 20, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043582Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 767, BETWEEN LBL 7 AND LBL 18, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043553Structure · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED BETWEEN BS 380 AND BS 440, STRINGER 8L. REMOVED AND REPLACED STRUCTURE SECTION PER SRM.SDR SWAA043552Structure · crackedDURING SCHEDULED D-CHECK, FOUND STRUCTURE CRACKED BETWEEN BS 787 AND BS 867, STRINGER 8L. REMOVED AND REPLACED STRUCTURE SECTION PER SRM.SDR SWAA043554Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE AT BS 907, STRINGER 4L, CRACKED. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA043551Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FWD CARGO COMPARTMENT FRAME AT BS 500A, BETWEEN LBL 6 AND RBL 6, CORRODED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043550Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 360, STRINGER 8R, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043549Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME AT BS 480, STRINGER 8L, CRACKED. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA043548Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 312, LBL 2, CORRODED. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR SWAA043547Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND FWD ENTRY DOOR EVAC SLIDE FWD AND AFT GIRT BAR FLOOR FITTINGS BRACKETS, CORRODED. REMOVED AND REPLACED FWD AND AFT GIRT BAR FITTINGS PER SRM.SDR SWAA043459Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND 2 EACH CREASE BEAM CHORDS CRACKED AT RIGHT BS 188 AND LEFT BS 188. REMOVED AND REPLACED CREASE BEAM CHORD SECTIONS PER SRM.SDR SWAA041987Fan · overheatedTHIRTY MINUTES PRIOR TO LANDING, ELECTRICAL ODOR IN FWD PART OF CABIN. TURNED OFF GALLEY POWER, RECIRC FAN, GASPER FAN, SMELL SUBSIDED. REMOVED AND REPLACED RECIRC FAN PER MM.SDR SWAA041492Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED. REMOVED AND REPLACED INBOARD FOREFLAP PER MM.SDR SWAA041491Panel · crackedDURING SCHEDULED C4 CHECK, FOUND LEFT KEELBEAM PANEL AT BS 660, BS 700, CRACKED. REPAIRED KEELBEAM PANEL PER SRM.SDR SWAA041469Bearing · wornDURING SCHEDULED C4 CHECK, RT AND LT ELEVATORS FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT AND LT ELEVATOR INPUT ROD BEARINGS PER MM.SDR SWAA041468Slide · out of adjustDURING SCHEDULED C4 CHECK, FOUND R1 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR EVAC SLIDE PER MM.SDR SWAA040477Slide · out of adjustDURING SCHEDULED C3 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040406Bulkhead · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON AFT PRESSURE BULKHEAD WEB AT BS 1016, LBL 2 TO RBL 2. REPAIRED WEB PER ACO.SDR SWAA040405Stiffener · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON AFT PRESSURE BULKHEAD CHANNEL STIFFNERS AT BS 1016, BL 0. REPAIRED PER ACO.SDR SWAA032446Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND L2 DOOR EVACUATION SLIDE RELEASE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA032445Strip · deterioratedDURING SCHEDULED C2 CHECK, FOUND EEPLS STRIP DETERIORATED AT LT AFT END. REMOVED AND REPLACED EEPLS SECTION PER MM.SDR SWAA031942Slide · looseAFT ENTRY DOOR EVACUATION SLIDE FELL OUT OF CONTAINER. SECURED SLIDE ASSY INTO CONTAINER PER MM.SDR SWAA031729Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA031172Light · inoperativeEEPLS SECTION INOP AT MID CABIN. REMOVED AND REPLACED EEPLS SECTION PER MM.SDR SWAA030139Skin · delaminatedDURING SCHEDULED BC3 CHECK, FOUND RT WING INBOARD FOREFLAP UPPER SURFACE DELAMINATED IN A 6 INCH DIAMETER CENTER SECTION. REMOVED AND REPLACED INBOARD FOREFLAP PER MM.SDR SWAA022392Slide · out of positionDURING SCHEDULED C2 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW AND CABLE MISROUTED. REPOSITIONED SLIDE AND REROUTED CABLE PER MM.SDR SWAA022391Cable · misroutedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA021437Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 767, ABOVE STR 13R. REPAIRED SKIN PER SRM.SDR SWAA021179Tab · wornDURING SCHEDULED SERVICE CHECK, SWA SI 11111-55, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED LT ELEVATOR TAB PER MM.SDR SWAA013318Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED (2 EA) AT BS 178, WL201, RBL 5.0 AND LBL 5.0. REPAIRED WEB PER SRM.SDR SWAA012552Skin · crackedDURING SCHEDULED C2 CHECK, FOUND KEEL BEAM SKIN CRACKED 2 INCHES LONG, LH SIDE AT BS 682. REPAIRED SKIN PER SRM.SDR SWAA012539Skin · crackedDURING SCHEDULED C2 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED 3/8 INCH LONG AT BS 817. REPAIRED DOOR PER SRM.SDR SWAA011075Flap · delaminatedDURING SCHEDULED SERVICE CHECK, FOUND RT WING OUTBD AFT FLAP DELAMINATED ON INBOARD END, UPPER AND LOWER SURFACES. REMOVED AND REPLACED AFT FLAP PER MM.SDR SWAA010345Door · out of adjAIR TURNBACK, AIRCRAFT FAILED TO PRESSURIZE DURING CLIMB. NO DOOR WARNING INDICATIONS. ADJUSTED FWD ENTRY DOOR PER MM. PRESSURIZED A/C & FOUND NO LEAKS PER MM.SDR SWAA010113Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND RT WING T/E INBOARD AFT FLAP DELAMINATED AT OUTBOARD LOWER CORNER. REMOVED AND REPLACED AFT FLAP ASSY PER MM.SDR SWAA010112Skin · delaminatedDURING SCHEDULED C3 CHECK, FOUND LT WING T/E INBOARD AFT FLAP DELAMINATED ON OUTBOARD LOWER SURFACE. REPAIRED AFT FLAP PER SRM & RA 1-A57-0608.SDR SWAA010111Light · looseDURING SCHEDULED C3 CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT OUT OF RETAINER AT ROW 16. SECURED LIGHT ASSY PER MM.SDR SWAA000306Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 178 BULKHEAD LT AND RT SIDE CHORDS CRACKED, LBL AND RBL 26. REMOVED AND REPLACED CHORD SECTIONS PER SRM.SDR SWAA000305Light · looseDURING SCHEDULED 1/2D CHECK, FOUND EMERGENCY EXIT LIGHT LOOSE AT FWD GALLEY. REMOVED AND REPLACED EXIT LIGHT ASSY PER MM.SDR SWAA000289Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 986 FLOORBEAM UPPER SURFACE CORRODED, RBL 36. REPAIRED BEAM PER SRM.SDR SWAA991988Light · damagedEEPLS LENS MISSING AT ROW 11. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA982711Light · missingDURING WALKAROUND CHECK, FOUND SMALL SECTION OF FLOOR TRACK LIGHTING MISSING MID CABIN AT EMERGENCY EXIT. REPLACED MISSING SECTION OF FLOOR TRACK LIGHTING AND CHECKED WONDERFUL PER BOEING MM.SDR SWAA982710Wire · brokenDURING WALKAROUND CHECK, FOUND APPROX 4 EMERGENCY EXIT AISLE LIGHTS BETWEEN ROW 11 AND 12 ARE PULLED UP AND WIRES BROKEN. RECONNECTED WIRING TO LIGHT FIXTURES AND SECURED LIGHT LENSES, OPS CHECK GOOD.SDR SWAA982526Wire · looseDURING SCHEDULED WALKAROUND CHECK, FOUND OVERWING EMERGENCY FLOOR TRACK LIGHTING HAS LOOSE WIRE. RELAMPED AND RECONNECTED EMERGENCY FLOOR TRACK LIGHTS PER BOEING SRM.SDR SWAA982502Light · kicked upDURING WALKAROUND CHECK, FOUND EMERGENCY TRACK LIGHTS KICKED UP AT MID CABIN. REINSTALLED TRACK, FOUND RED LIGHT OUT AT WING EXIT ROW AND PLACARDED PER MEL. RECONNECTED RED LAMP AT EMERGENCY EXIT ROW PER BOEING MM.SDR SWAA971058Base · inoperativeDURING WALKAROUND INSPECTION, FOUND EMERGENCY TRACK LIGHTS INOP AT ROW 14. REPLACED LIGHT BASE PER BOEING M/M.
Back to N604SW, cancelled Aug 5, 2019