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 SWAA093008Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA093007Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 500B, BETWEEN BL 0 TO STR 28R. REMOVED AND REPLACED SHEAR TIE PER SWA EA.SDR SWAA093006Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SWA EA.SDR SWAA092875Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 597, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092874Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092808Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 500C, STR 26R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092807Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092806Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092805Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 7L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092804Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 639, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092803Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 967, BETWEEN STR 27L TO STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA092802Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 927, STR 25L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092801Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 927, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA092800Stringer Clip · corrodedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CORRODED AT BS 807, STR 20L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092799Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 807, BETWEEN STR 27L TO STR 27R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA092798Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 787, BETWEEN STR 25L TO STR 26L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA092797Shear Tie · corrodedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CORRODED AT BS 727A, BETWEEN STR 21L TO STR 22L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA092796Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 380, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092795Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727E, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092794Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092793Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 3L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092792Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 6L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092791Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727C, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092790Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA092789Stringer Clip · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER CLIP CRACKED AT BS 727D, STR 4R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA091282Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND BS 178 BULKHEAD WEB CRACKED AT LBL 5.7 TO RBL 5.7. REPAIRED WEB PER EA.SDR SWAA090677Line · rupturedAIR TURNBACK/DECLARED EMERGENCY. LOST A-HYD QUANTITY PASSING THROUGH 20,000FT ON CLIMBOUT. FOLLOWED NORMAL FOM, QRH PROCEDURES. A-SYSTEM PUMPS TURNED OFF BEFORE QUANTITY DEPLETED. NO OTHER DISCREPANCY NOTED. FOUND A-SYSTEM ELEVATOR PCU LINE TO BE RUPTUREDSDR SWAA090049Slide · faultyDURING SCHEDULED HC1 CHECK, FOUND R1 DOOR EMERGENCY EVACUATION SLIDE TWISTED DURING DEPLOYMENT TEST. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA086081Lens · looseFOUND LT OVERWING EXIT LIGHT LOOSE. SECURED LENS PER MM.SDR SWAA084852Skin · corrodedFUSELAGE SKIN CORRODED AT BS 847, BETWEEN STR 27R AND STR 27L. REPAIRED SKIN PER SRM.SDR SWAA084682Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 512B, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA084681Skin · crackedDURING SCHEDULED MV2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 502D, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA084495Slide · low pressureR1 DOOR EMERGENCY EVAC SLIDE PRESSURE GAUGE INDICATED OUT OF LIMITS. REMOVED AND REPLACED EVAC SLIDE PER MM.SDR SWAA083562Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND FWD CARGO DOOR SKIN CRACKED AT DOOR HANDLE CUTOUT. REPAIRED SKIN PER SWA EA.SDR SWAA083563Skin · delaminatedDURING SCHEDULED HC2 CHECK, FOUND RT WING NR 7 SPOILER UPPER SURFACE DELAMINATED. REMOVED AND REPLACED SPOILER PER MM.SDR SWAA072781Keelbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND RIGHT KEEL BEAM CRACKED AT BS 540. REPAIRED KEEL BEAM PER SRM.SDR SWAA072780Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 986.5, BETWEEN LBL 43 AND RBL 43. REPAIRED CHORD PER ER.SDR SWAA072770Door Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND E&E DOOR CUTOUT RIGHT FWD CORNER CORRODED AT BS 328, RBL 15.47. REPAIRED INNER CHORD PER SRM.SDR SWAA072773Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE SKIN CRACKED AT R1 DOOR UPPER FWD CORNER BS 310. REPAIRED SKIN PER ER.SDR SWAA072767Spar · crackedDURING SCHEDULED 22Y CHECK, FOUND LEFT WING REAR SPAR UPPER CHORD CRACKED AT STA 274.14. REPAIRED CHORD PER ER.SDR SWAA072768Spar · crackedDURING SCHEDULED 22Y CHECK, FOUND RIGHT WING REAR SPAR UPPER CHORD CRACKED AT STR 2, STA 114. REPAIRED CHORD PER ER.SDR SWAA072769Spar · crackedDURING SCHEDULED 22Y CHECK, FOUND RIGHT WING REAR SPAR UPPER CHORD CRACKED AT STA 224.14. REPAIRED CHORD PER ER.SDR SWAA072771Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND LEFT WING UPPER SKIN CORRODED AT BETWEEN STA 119 AND STA 126, FWD SPAR. REPAIRED SKIN PER ER.SDR SWAA072772Skin · corrodedDURING SCHEDULED 22Y CHECK, FOUND LEFT WING UPPER SKIN CORRODED AT STA 252, FWD SPAR. REPAIRED SKIN PER ER.SDR SWAA072738Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA072735Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE AFT GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA072736Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA072737Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED FITTING PER SRM.SDR SWAA072734Stringer Splice · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER SPLICE CRACKED AT BS 360, STR 7L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA072739Crease Beam · tornDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB TORN BETWEEN BS 986 AND BS 1019, RBL 40 AND RBL 45. REMOVED AND REPLACED WEB PER SRM.
Back to N658SW, cancelled Mar 15, 2018