N511SW, cancelled Jan 2, 2019
Service difficulty reports · 300
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 = 'N511SW' AND deregistration_id = 'N511SW-2019-01-02' 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 = 'N511SW' AND deregistration_id = 'N511SW-2019-01-02' 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 SWAA053945Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 660, BL 0. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053944Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 46.5 TO LBL 46.5. REMOVED AND REPLACED FLOORBEAM UPPER CAP PER SRM.SDR SWAA053929Stiffener · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BULKHEAD ANGLE STIFFENER CORRODED AT BL 0. REPAIRED ANGLE STIFFENER PER ACO & SRM.SDR SWAA053928Stiffener · corrodedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BULKHEAD CHANNEL STIFFENER CORRODED AT BL 0. REPAIRED CHANNEL STIFFENER PER ACO & SRM.SDR SWAA053927Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 328, STR 17R. REPAIRED SKIN PER SRM.SDR SWAA053913Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND BS 1016 AFT PRESSURE BLKHD DOME WEB PANEL NR 6 CRACKED AT 9 O'CLOCK POSITION. REPAIRED DOME WEB PER SWA EA.SDR SWAA050967Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA043191Cover · looseEEPLS LIGHT STRIP FROM ROW 1 ABC TO ROW 3 ABC, LOOSE. REMOVED AND REPLACED EEPLS STRIP PER MM.SDR SWAA042405Skin · corrodedDURING SCHEDULED C4 CHECK, FOUND LT WING SKIN AT WING STATION 132, STRINGER 3, CORRODED. REPAIRED SKIN PER EA.SDR SWAA040280Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 932, STRINGER 24L. REPAIRED SKIN PER SRM.SDR SWAA031471Door Frame · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD SERVICE DOOR AFT FRAME CRACKED AT NR 4 STOP FITTING. REPAIRED FRAME PER SRM.SDR SWAA030394Housing · defectiveDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT MID CABIN OVERHEAD. REMOVED AND REPLACED BATTERY PACK HOUSING PER MM.SDR SWAA021178Flap · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT OTBD AFT T/E FLAP DELAMINATED. REMOVED AND REPLACED RT OTBD AFT T/E FLAP PER MM.SDR SWAA012626Slide · unserviceableDURING SCHEDULED SERVICE CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA011857Flashlight · inoperativeEMERGENCY FLASHLIGHT INOP AT AFT UPPER POSITION. REMOVED AND REPLACED FLASHLIGHT PER MM.SDR SWAA011242Track · looseDURING SCHEDULED C4 CHECK, FOUND EEPLS TRACK LOOSE AT ROWS 3 & 7. REPAIRED TRACK PER MM.SDR SWAA010545Window · crackedAIR TURNBACK - DURING CLIMB, R2 COCKPIT WINDOW CRACKED. REMOVED AND REPLACED R2 WINDOW & WINDOW HEAT CONTROLLER PER MM. OPS CHECK GOOD PER MM.SDR SWAA010109Light · debondedDURING SCHEDULED C3 CHECK, FOUND EEPLS STRIP (PHOTO-LUMINESCENT) DISBONDED AT ROW 7. SECURED LIGHTING STRIP PER MM.SDR SWAA002749Splice · crackedDURING SCHEDULED D-CHECK, FOUND 2 CRACKS AT STR 4L SPLICE, BS 908. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA002763Light · brokenDURING SCHEDULED D-CHECK , FOUND FWD ENTRY DOOR EMERGENCY EXIT LIGHT BROKEN. REMOVED AND REPLACED LIGHT ASSY PER MM.SDR SWAA002671Lens · damagedDURING SCHEDULED D CHECK, FOUND ALL FOUR EMERGENCY EVAC SLIDE PRESS INDICATORS DIFFICULT TO READ. REPAIRED VIEW PLATES PER MM.SDR SWAA002639Beam · crackedDURING SCHEDULED D CHECK, FOUND 14 EA. CRACKS AT BS 178 BULKHEAD VERTICAL BEAMS, WL 226 TO WL 231.75, RBL 17.1 & WL 226 TO WL 232.5, LBL 17.1. REPAIRED VERTICAL BEAMS PER RA 1-553-2403.SDR SWAA002638Bulkhead · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND 4 EA. BS 178 BULKHEAD WEB CRACKS AT RBL 5 TO LBL 5, WL 188 TO WL 201. REPAIRED BULKHEAD WEBS PER ACO 7154-53.SDR SWAA002484Fitting · crackedDURING SCHEDULED D CHECK AT DALFORT, FOUND RT & LT MLG AFT BEAM FITTINGS CRACKED. R&R BEAM FITTINGS PER ACO 6384-57.SDR SWAA002433Floorbeam · corrodedDURING SCHEDULED D CHECK AT DALFORT, FOUND FLOOR BEAM CORRODED AT BS 986.5, RBL 4.75. REPAIRED FLOOR BEAM PER SRM.SDR SWAA002111Slide · dislodgedDURING FWD ENTRY DOOR CLOSURE, EMERGENCY EVAC SLIDE ENGAGED FRAME AND FELL OUT OF CONTAINER. REINSTALLED SLIDE ASSY PER MM.SDR SWAA001807Cover · looseEEPLS TRACK COVER PULLED LOOSE AT ROW 7. INSTALLED TRACK COVER PER MM.SDR SWAA001541Cover · crackedDURING SCHEDULED C2 CHECK, FOUND EEPLS TRACK COVER CRACKED AT FWD END. REMOVED AND REPLACED TRACK COVER PER MM.SDR SWAA000119Cover · missingEEPLS TRACK COVER MISSING ON ROWS 9-10. INSTALLED AND SECURED COVER PER MM.SDR SWAA991311Skin · delaminatedDURING SCHEDULED C2 CHECK, FOUND NR 5 L/E SLAT DELAMINATED ON UPPER AFT INBOARD CORNER. REPAIRED SLAT PER SRM.SDR SWAA982735Intercostal · crackedDURING SCHEDULED BC3 CHECK, FOUND DOOR UPLOCK INTERCOSTAL CRACKED. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982530Skin · dentedDURING SCHEDULED RON CHECK, FOUND DENTED LEADING EDGE OF LT HORIZONTAL STABILIZER (CENTER SEC) DENT CAUSE ELONGATION OF SOME RIVETS HOLES. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982460Angle · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORRODED RT Z ANGLE AT AFT SERVICE DOOR CUTOUT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982412Angle · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORRODED TRANSITION ANGLE LT AT BS 460 TO 520, LBL 24. REPLACED PER BOEING SRM.SDR SWAA982387Dome Nuts · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORRODED 3 DOME NUTS AT BS 468, BL 0 FUSELAGE. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982386Web · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORRODED DOORWAY LOWER WEB. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981793Splice · failedDURING WALKAROUND CHECK, FOUND TWO OVERWING RED STRIP LIGHTS AND TWO WHITE STRIP LIGHTS INOP. REPAIRED WIRE SPLICE AND 8ABC PER BOEING MM.SDR SWAA981772Wire · inoperativeDURING WALKAROUND CHECK, FOUND TWO OVERWING RED STRIP LIGHTS AND TWO WHITE STRIP LIGHTS INOP. REPAIRED WIRE SPLICE 8ABC PER BOEING MM.SDR SWA980661Retract Mech · lack of lubeAFTER TAKEOFF GEAR WOULD NOT COME UP, PULLED TRIGGER LOCK OVERRIDE TO RISE AFTER GEAR RETRACTED, TAKEOFF WARNING HORN AND CDU STUCK. USED QRH PULLED P62 CB HORN OFF, AND CDU OK. AIR RETURN TO PHX, AND MADE AN UNEVENTFUL LANDING. ADJUSTED GROUND SENSE CABLE SDR SWAA970529Skin · gougedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 784, AT S28R. REPAIRED PER BOEING SRM.SDR SWAA961394Skin · gougedDURING SCHEDULED BC3 CHECK, FOUND FUSELAGE SKIN GOUGED AT BS 970, AT STRINGER 19L. REPAIRED SKIN PER SWA RA 1-553-1566.SDR SWAA960992Light · dischargedDURING SCHEDULED C2 CHECK, FOUND CABIN UPPER EMERGENCY FLASHLIGHT NOT TESTING. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA960732Slide · deployedINADVERTENT SLIDE DEPLOYMENT AT FWD SERVICE DOOR. REPLACED SLIDE ASSEMBLY PER BOEING M/M.SDR SWAA960637Wire · brokenDURING WALK-AROUND, FOUND EMERGENCY EXIT LIGHTING WIRES BROKEN, 4 WHITE LIGHTS INOP AT ROW FWD OF OVERWING EXIT. REPAIRED AND OP CHECKED PER BOEING M/M.SDR SWAA960593Skin · gougedDURING SCHEDULED B/C1 CHECK, FOUND FUSELAGE SKIN GOUGED 14 INCHES BELOW AFT ENTRY. REPAIRED PER BOEING SRM.SDR SWAA960523Skin · dentedDURING SCHEDULED SV CHECK, FOUND LT HORIZ STAB L/E DENTED 2 PLACES. REPAIRED PER BOEING SRM.SDR SWAA960174Floor Beam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOOR BEAM AFT FLANGE CORRODED AT BS 312 LBL 15. REPAIRED PER BOEING SRM.SDR SWAA960173Angle · crackedDURING SCHEDULED 1/2 D-CHECK, FOUND 3.3 INCH CRACK IN RADIUS OF RT CREASE BEAM I/B CHORD ANGLE AT BS 294, RBL 54. REPAIRED PER BOEING SRM AND TYPICAL REPAIR T1-A53-023.SDR SWAA960172Floor Beam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOOR BEAM NUTPLATE HOLE CORRODED AT BS 986.5 RBL 30. REPAIRED PER BOEING SRM.SDR SWAA960171Floor Beam · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND FLOOR BEAM NUTPLATE HOLE CORRODED AT BS 986.5. REPAIRED PER BOEING SRM.
Back to N511SW, cancelled Jan 2, 2019