N658SW, cancelled Mar 15, 2018
Service difficulty reports · 512
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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 = 'N658SW' AND deregistration_id = 'N658SW-2018-03-15' 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 SWAA072662Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 706, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072663Lens · crackedDURING SCHEDULED 22Y CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LENS CRACKED. REMOVED AND REPLACED LENS PER MM.SDR SWAA072605Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 520, STR 12R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072604Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA072597Girt Bar · corrodedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA072596Girt Bar · corrodedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA072600Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 355, STR 28R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA072599Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 15L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA072595Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND LEFT AND RIGHT HORIZONTAL STAB FITTING CLEVIS LUG FACES CORRODED. REPAIRED FITTING PER SRM.SDR SWAA072603Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 343, LBL 12, WL 156. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072601Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 312, RBL 1. REPAIRED WEB PER ER.SDR SWAA072598Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND ZEE CHORD CORRODED AT BS 270, BETWEEN LBL 11 AND RBL 11, WL 208. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA072602Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CHORD CRACKED AT BS 188, LBL 33, WL 208. REMOVED AND REPLACED CHORD PER SRM.SDR SWAA072371Stringer Splice · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, STR 27R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA072370Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 520, BETWEEN RBL 8 AND RBL 13. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072369Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 744A, RBL 25. REPAIRED FLOORBEAM PER SRM.SDR SWAA072323Slat · crackedDURING SCHEDULED 22Y CHECK, FOUND LEFT WING NR 1 L/E SLAT CRACKED AT LOWER INBOARD END. REPAIRED SLAT PER SRM.SDR SWAA072320Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072319Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072321Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED ANAD REPLACED STRINGER SPLICE PER SRM.SDR SWAA072322Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA072318Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 294, LBL 13 TO RBL 12. REMOVED AND REPLACED FLOORBEAM CHORD PER SRM.SDR SWAA072234Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072236Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 520, RBL 7 TO LBL 7. REPAIRED SHEAR TIE PER SRM.SDR SWAA072235Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT RADIO ALTIMETER ANTENNA CUTOUT BS 450, LBL 2. REPAIRED SKIN PER SRM.SDR SWAA072204Stringer · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 16R CRACKED AT BS 504C. REPAIRED STRINGER PER ER.SDR SWAA072205Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 440, STR 20L. R&R STRINGER CLIP PER SRM.SDR SWAA072203Shear Tie · crackedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. R&R SHEAR TIE PER SRM.SDR SWAA072200Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072201Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, STR 8L AND STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072199Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 867, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072202Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 847, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072198Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072197Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072196Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072195Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 559, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072151Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, STR 7L. REPAIRED WEB PER ER.SDR SWAA072150Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727B. STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072152Crease Beam · crackedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CRACKED BETWEEN BS 277 AND BS 294.5, LBL 52. R&R CREASE BEAM WEB PER SRM.SDR SWAA072080Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072082Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER SWA EA.SDR SWAA072081Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 8L. REPAIRED FRAME PER SWA EA.SDR SWAA072083Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 188, RBL 33, WL 208. REPAIRED FRAME PER SRM.SDR SWAA072053Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 578, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072054Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 685, STR 4L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072049Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA072051Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 807 TO BS 827, RBL 70. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA072052Crease Beam · corrodedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 787 TO BS 797, RBL 70. REMOVED AND REPLACED CREASE BEAM WEB PER SRM.SDR SWAA072050Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 986, STR 22L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA072048Structure · crackedDURING SCHEDULED 22Y CHECK, FOUND LT WING INBOARD MID FLAP CRACKED AT LOWER OUTBOARD END. REMOVED AND REPLACED FLAP PER MM.
Back to N658SW, cancelled Mar 15, 2018