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 SWAA074402Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR LOWER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA074401Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 885, BETWEEN STR 24R TO STR 25R. REPAIRED SKIN PER SWA EA.SDR SWAA074400Sign · missingAFT CABIN EMERGENCY EXIT SIGN MISSING. INSTALLED EXIT SIGN PER MM.SDR SWAA072807Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072610Slide · out of adjustDURING SCHEDULED C1 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA072300Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 972, STR 21L. REPAIRED SKIN PER SWA EA.SDR SWAA072299Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 770, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA071436Bottle · low pressureL1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA070083Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA064144Skin · corrodedDURING SCHEDULED SPV CHECK, FOUND LT WING UPPER SKIN CORRODED AT WING STA 75, STR 7. REPAIRED SKIN PER ER.SDR SWAA064132Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA064076Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME SECTION PER ER.SDR SWAA063978Crease Beam · crackedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 616 TO BS 639, STR 17L. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA063959Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA063958Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063957Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063956Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063955Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063954Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R AND STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063953Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063952Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063951Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B, STR 8L AND STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063950Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L AND STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063869Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA063285Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 944, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA062396Actuator · crackedLT WING INBOARD NR 4 GROUND SPOILER OUTBOARD ACTUATOR HOUSING CRACKED. REMOVED AND REPLACED NR 4 OUTBOARD ACTUATOR PER MM.SDR SWAA062053Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA062011Web · crackedDURING SCHEDULED C2 CHECK, FOUND BULKHEAD WEB CRACKED AT BS 1016, STR 6L. REPAIRED WEB SECTION PER SRM.SDR SWAA060661Lens · missingDURING SCHEDULED C1 CHECK, FOUND FWD CABIN EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED LENS PER MM.SDR SWAA060014Web · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 664, LBL 42. REPAIRED WEB PER SWA EA.SDR SWAA054148Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, FWD FRAME LOWER STOP FITTING. REPAIRED FRAME PER SWA EA.SDR SWAA054094Door Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO DOOR AFT FRAME CRACKED AT NR 5 STOP FITTING. REMOVED AND REPLACED AFT CARGO DOOR PER MM.SDR SWAA054093Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT L1 DOOR CUTOUT, LOWER FWD CORNER. REPAIRED FRAME PER SRM.SDR SWAA054064Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FLOORBEAM CORRODED AT BS 1016, RBL 30.5. REPAIRED FLOORBEAM PER SRM.SDR SWAA054063Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 385 TO BS 387, STR 4R. REPAIRED SKIN PER SWA EA.SDR SWAA054044Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED BETWEEN BS 498A TO BS 500A, STR 12L. REPAIRED SKIN PER SWA EA.SDR SWAA054027Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND RT WING RIB LOWER CHORD CRACKED AT WBL 135.5, BETWEEN STR 2 AND STR 3. REPAIRED RIB PER SRM AND SWA ACO.SDR SWAA054026Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 20R. REPAIRED FRAME PER SWA EA.SDR SWAA054025Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 20L. REPAIRED FRAME PER SWA EA.SDR SWAA054024Skin · chafedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CHAFED AT DORSAL FIN BLADE SEAL, BETWEEN BS 889 TO BS 919, LBL 7. REPAIRED SKIN PER SWA EA.SDR SWAA054023Skin · chafedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CHAFED AT DORSAL FIN BLADE SEAL, BETWEEN BS 925 TO BS 927, LBL 9 & RBL 9. REPAIRED SKIN PER SWA EA.SDR SWAA053997Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 344, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053996Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 520, STR 16L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053995Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 615, STR 17R. REPAIRED FRAME PER SRM.SDR SWAA053994Shear Tie · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14R TO STR 15R. REPAIRED SHEAR TIE PER SRM.SDR SWAA053993Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED WEB CRACKED AT BS 664, LBL 32. REPAIRED BEADED WEB PER SWA EA.SDR SWAA053976Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053975Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 931, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA053957Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA053946Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 320, R1 DOOR CUTOUT, AFT LOWER CORNER. REPAIRED SKIN PER SRM.
Back to N511SW, cancelled Jan 2, 2019