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 SWAA081036Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081037Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081038Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 597, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081039Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081040Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081035Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA081031Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081032Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 5R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081030Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 22L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA081033Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080863Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED FRAME PER SWA EA.SDR SWAA080862Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 887, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080861Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 787, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080860Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080864Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482, STR 8R AND STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080865Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 482A, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080868Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080859Stringer Clip · crackedDURING SCHEDULED 16Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 482A, STR 4R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA080867Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA080866Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA080915Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CHORD CORRODED AT BS 360, RBL 45 TO RBL 60. REPAIRED FLOORBEAM CHORD PER SRM.SDR SWAA080832Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CORRODED AT BS 794, STR 27R. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA080566Slide · out of adjustL1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA080240Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 803, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA076101Glowstrip · wornDURING SCHEDULED MV4 CHECK, FOUND EEPLS PHOTOLUMINESCENT STRIP WORN AT ROW 2 DEF. REMOVED AND REPLACED STRIP PER MM.SDR SWAA076082Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 749, STR 18L. REPAIRED SKIN PER SWA EA.SDR SWAA076081Skin · crackedDURING SCHEDULED MV1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 803, STR 24L. REPAIRED SKIN PER SWA EA.SDR SWAA075792Window · failedDIVERSION - FLIGHT DECK L1 WINDOW SHATTERED AND ARCED. REMOVED AND REPLACED L1 WINDOW PER MM.SDR SWAA074755Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 934, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA074555Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA074463Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR LOWER HINGE CUTOUT CRACKED. REPAIRED SKIN PER SWA EA.SDR SWAA072381Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 482B, STR 10L. REPAIRED SKIN PER SWA EA.SDR SWAA071141Light · inoperativeDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA071016Glowstrip · debondedDURING SCHEDULED 18Y CHECK, FOUND FWD RT CABIN EEPLS PHOTOLUMINESCENT STRIP DISBONDED. REMOVED AND REPLACED PHOTOLUMINESCENT STRIP PER MM.SDR SWAA071001Fitting · looseDURING SCHEDULED BRDG CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING LOOSE. SECURED GIRT BAR FITTING PER SRM.SDR SWAA063749Hydraulic System · leakingA-HYDRAULIC SYSTEM QUANTITY DROPPED TO ZERO, LOW PRESSURE LIGHT ILLUMINATED. REMOVED AND REPLACED NR 1 GROUND SPOILER PER MM.SDR SWAA063499Sign · looseRIGHT OVERWING EMERGENCY EXIT SIGN LOOSE. SECURED SIGN PER MM.SDR SWAA063295Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 940, STR 25R. REPAIRED SKIN PER SRM.SDR SWAA063294Pressure Panel · crackedDURING SCHEDULED C3 CHECK, FOUND NLG W/W CEILING PANEL CUTOUT CRACKED AT RT BS 250 AND LT BS 250. REPAIRED CEILING PANEL CUTOUT PER SWA EA.SDR SWAA063293Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 887, STR 24R. REPAIRED SKIN PER SWA EA.SDR SWAA063179Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT BULL NOSE LIGHT INOP AT ROW 3 ABC. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062541Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 782.5, STR 20L. REPAIRED SKIN PER SRM.SDR SWAA061865Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FWD SERVICE DOOR CUTOUT CENTER STUB FRAME CRACKED BENEATH UPPER HINGE. REPAIRED STUB FRAME PER SWA EA.SDR SWAA061864Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA052754Skin · delaminatedDURING SCHEDULED RON CHECK, FOUND RT WING INBOARD T/E AFT FLAP DELAMINATED. REPAIRED AFT FLAP PER SWA EA & SRM.SDR SWAA050631Lens · looseLT OVERWING EMERGENCY EXIT LIGHT LENS LOOSE. SECURED EMERGENCY LIGHT LENS PER MM.SDR SWAA050557Slide · dislodgedL1 DOOR EVAC SLIDE FELL OUT OF CONTAINER. REINSTALLED L1 DOOR EVAC SLIDE PER MM.SDR SWAA042708Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT WING INBOARD T/E FLAP DELAMINATED. REMOVED AND REPLACED RT WING INBOARD T/E FLAP PER MM.SDR SWAA042389Transmission · inoperativeNO FLAP EXTENSION WITH NORMAL HYD, ALT FLAPS USED TO EXTEND LEADING EDGE. ALT FLAP DRIVE C/B TRIPPED. REMOVED AND REPLACED NR 3, 5 AND 6 FLAP TRANSMISSIONS AND JACKSCREWS PER MM.SDR SWAA042297Window Post · crackedDURING SCHEDULED 1/4D CHECK, FOUND L1 COCKPIT UPPER WINDOW POST CRACKED. REPAIRED WINDOW POST PER SRM.
Back to N528SW, cancelled Mar 27, 2018