N528SW, cancelled Mar 27, 2018
Service difficulty reports · 353
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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 SWAA085782Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 870, STR 23R. REPAIRED SKIN PER SWA EA.SDR SWAA085315Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND BELLY SKIN CRACKED AT BS 450, BL 0 TO RBL 1.5. REPAIRED SKIN PER PAE ER.SDR SWAA085314Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND BELLY SKIN CRACKED AT BS 410, AFT BL 0. REPAIRED SKIN PER PAE ER.SDR SWAA085313Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND BELLY SKIN CRACKED AT BS 390, RBL 1.5 TO RBL 3 AFT. REPAIRED SKIN PER PAE ER.SDR SWAA082139Slide · out of adjustR1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA081671Lens · looseLEFT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS PER MM.SDR SWAA081643Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, RBL 1.5. REPAIRED SKIN PER ER.SDR SWAA081641Skin · delaminatedDURING SCHEDULED 16Y CHECK, FOUND RT WING INBOARD FORE FLAP UPPER SKIN DELAMINATED AT OUTBOARD END. REPAIRED FLAP PER SRM.SDR SWAA081648Slide · low pressureDURING SCHEDULED 16Y CHECK, R1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA081642Skin · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BETWEEN BS 390 AND BS 410, RBL 1.5 TO RBL 3. REPAIRED SKIN PER ER.SDR SWAA081640Tab · debondedDURING SCHEDULED 16Y CHECK, FOUND LT ELEVATOR TAB DISBONDED AT NR 2 UPPER HINGE CUTOUT. REPAIRED TAB PER ER.SDR SWAA081639Tab · debondedDURING SCHEDULED 16Y CHECK, FOUND LT ELEVATOR TAB DISBONDED AT NR 1 UPPER HINGE CUTOUT. REPAIRED TAB PER ER.SDR SWAA081502Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 2 DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA081503Door Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REPAIRED FRAME PER SRM.SDR SWAA081490Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 667, LBL 24. REPAIRED CHORD PER SRM.SDR SWAA081501Shear Tie · corrodedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CORRODED AT BS 482A, STR 27L TO STR 28L. REPAIRED SHEAR TIE PER SRM.SDR SWAA081491Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 3L. REPAIRED FRAME PER ER.SDR SWAA081459Flap · delaminatedDURING SCHEDULED 16Y CHECK, FOUND LT WING OUTBOARD T/E AFT FLAP DELAMINATED AT INBOARD END. REPAIRED FLAP PER SRM.SDR SWAA081402Slat · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 2 L/E SLAT CRACKED. REPAIRED SLAT PER BOEING DRAWING AND SRM.SDR SWAA081392Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 24L. REPAIRED FRAME PER SRM.SDR SWAA081371Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 31 TO LBL 45. REPAIRED FLOORBEAM PER ER.SDR SWAA081372Rib · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING LOWER RIB CHORD CRACKED AT STA 135, STR 2. REPAIRED CHORD PER ACO.SDR SWAA081247Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA081236Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294, STR 12L. REPAIRED FRAME PER SRM.SDR SWAA081205Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME INBOARD CHORD CRACKED AT BS 616, LBL 64. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA081176Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 420, STR 16R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081175Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME WEB CRACKED AT BS 303, STR 4L. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081157Slat · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 2 L/E SLAT CRACKED AT OUTBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA081158Slat · crackedDURING SCHEDULED 16Y CHECK, FOUND LT WING NR 1 L/E SLAT CRACKED AT OUTBOARD T/E. REPAIRED SLAT PER SRM.SDR SWAA081159Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 907, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081143Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 360, STR 14R. REPAIRED SHEAR TIE PER SRM.SDR SWAA081142Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 295, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA081122Crease Beam · corrodedDURING SCHEDULED 16Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 415, RBL 68. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081123Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 294, RBL 53, WL 208. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA081124Stringer Splice · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA081125Stringer Splice · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA081126Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 4L CRACKED AT BS 887. REPAIRED STRINGER PER SRM.SDR SWAA081127Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081103Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081111Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 559, STR 17R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081112Stringer · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER 15L CRACKED AT BS 380. REPAIRED STRINGER PER SRM.SDR SWAA081113Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081114Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081110Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081079Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA081078Fitting · corrodedDURING SCHEDULED 16Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA081077Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 21L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081073Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081080Shear Tie · crackedDURING SCHEDULED 16Y CHECK, FOUND SHEAR TIE CRACKED AT BS 277, STR 8L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA081034Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.
Back to N528SW, cancelled Mar 27, 2018