N657SW, cancelled Mar 15, 2018
Service difficulty reports · 446
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 = 'N657SW' AND deregistration_id = 'N657SW-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 = 'N657SW' AND deregistration_id = 'N657SW-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 SWAA052790Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 663, STR 10R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA052789Nut Plate · crackedDURING SCHEDULED 1/2D CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE UPPER AFT ANCHOR NUT PLATE CRACKED. REMOVED AND REPLACED NUT PLATE PER MM.SDR SWAA052788Pressure Panel · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE BEADED PRESSURE WEB CRACKED AT BS 663, LBL 31 & RBL 39. REPAIRED BEADED WEB PER SRM.SDR SWAA052543Bracket · crackedDURING SCHEDULED C1 CHECK, FOUND R2 DOOR EMERGENCY EVAC SLIDE FWD ATTACH BRACKET CRACKED. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA052512Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CORRODED BETWEEN BS 259 TO BS 312, STR 14L. REPAIRED SKIN PER BFG ER.SDR SWAA052101Hinge · brokenR1 DOOR UPPER HINGE ASSY BROKEN. REMOVED AND REPLACED UPPER HINGE ASSY PER MM.SDR SWAA051268Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN AT BS 907 TO BS 1016, FROM STR 26L TO STR 26R. REMOVED AND REPLACED BELLY SKIN SECTION PER SRM.SDR SWAA051267Frame · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE FRAME ASSY AT BS 500, FROM STR 26L TO STR 27L. REPAIRED FRAME PER SRM.SDR SWAA051266Frame · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE LOWER FRAME AT BS 1088, FROM LBL 13 TO RBL 15. REPAIRED FRAME PER BFG ER.SDR SWAA051265Shear Tie · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE LOWER FRAME SHEAR TIE AT BS 360, BL 0. REPAIRED SHEAR TIE PER SRM.SDR SWAA051264Strap · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE LOWER FRAME STRAP AT BS 360, FROM RBL 14 TO LBL 14. REPAIRED FRAME PER BFG ER & SRM.SDR SWAA051263Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN LAP AT BS 1016 TO BS 1088, STR 16R. REPAIRED SKIN PER BFG ER.SDR SWAA051262Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON LOWER FUSELAGE SKIN AT BS 350 TO BS 360, BL 0. REPAIRED SKIN PER BFG ER.SDR SWAA051261Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN AT BS 1016 TO BS 1088, FROM STR 26L TO STR 26R. REMOVED AND REPLACED BELLY SKIN SECTION PER BFG ER.SDR SWAA051260Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN LAP JOINT AT BS 1016 TO BS 1088, STR 24R. REPAIRED SKIN PER BFG ER.SDR SWAA051259Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN LAP JOINT AT BS 1016 TO BS 1088, STR 16L. REPAIRED SKIN PER BFG ER.SDR SWAA051258Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN LAP JOINT AT BS 1016 TO BS 1088, STR 4L. REPAIRED SKIN PER BFG ER.SDR SWAA051257Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN LAP JOINT AT BS 540 TO BS 727, STR 10L. REPAIRED SKIN PER BFG ER.SDR SWAA051256Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN LAP JOINT AT BS 540 TO BS 727, STR 10R. REPAIRED SKIN PER BFG ER.SDR SWAA051255Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN LAP JOINT AT BS 290 TO BS 360, STR 4R. REPAIRED SKIN PER BFG ER.SDR SWAA051254Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN LAP JOINT AT BS 259 TO BS 305, STR 19L. REPAIRED SKIN PER BFG ER.SDR SWAA051253Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT EQUIPMENT COOLING EXHAUST AFT CUTOUT. REPAIRED SKIN PER BFG ER.SDR SWAA051242Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 908 TO BS 950, STR 14L. REPAIRED SKIN PER BFG ER.SDR SWAA051241Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 908 TO BS 950, STR 10L. REPAIRED SKIN PER BFG ER.SDR SWAA051240Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 908 TO BS 1016, STR 4R. REPAIRED SKIN PER BFG ER.SDR SWAA051239Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 259 TO BS 360, STR 24L. REPAIRED SKIN PER BFG ER.SDR SWAA051238Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 259 TO BS 360, STR 19R. REPAIRED SKIN PER BFG ER.SDR SWAA051237Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 907 TO BS 1016, STR 20R. REPAIRED SKIN PER BFG ER.SDR SWAA051236Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 727C TO BS 907, STR 25R. REPAIRED SKIN PER BFG ER.SDR SWAA051235Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 360 TO BS 500C, STR 26R. REPAIRED SKIN PER BFG ER.SDR SWAA051234Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 907 TO 1016, STR 14R. REPAIRED SKIN PER BFG ER.SDR SWAA051233Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 986 TO BS 1016, STR 14L. REPAIRED SKIN PER BFG ER.SDR SWAA051232Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 727D TO 951, STR 20L. REPAIRED SKIN PER BFG ER.SDR SWAA051231Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 259 TO BS 360, STR 24R. REPAIRED SKIN PER BFG ER.SDR SWAA051230Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 350 TO 500C, STR 19L. REPAIRED SKIN PER BFG ER.SDR SWAA051229Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 360 TO 500C, STR 19R. REPAIRED SKIN PER BFG ER.SDR SWAA051228Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN LAP JOINT CORRODED AT BS 259 TO 360, STR 14L. REPAIRED SKIN PER BFG ER.SDR SWAA051220Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CORRODED BETWEEN BS 178 TO BS 259, STR 19R & STR 24R. REPAIRED SKIN PER PAE ER.SDR SWAA051219Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CORRODED BETWEEN BS 360 TO BS 500D, STR 26L. REPAIRED SKIN PER PAE ER.SDR SWAA051218Skin · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CORRODED BETWEEN BS 727C TO BS 907, STR 25L. REPAIRED SKIN PER PAE ER.SDR SWAA051173Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT BS 188, LBL 29, WL 208. REPAIRED FRAME PER SRM.SDR SWAA051113Stringer · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON STRINGER AT BS 1010, STR 26R. REPAIRED STRINGER PER SRM.SDR SWAA051112Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 616, STR 5L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051111Splice · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON STRINGER SPLICE AT BS 362, STR 27L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA051001Stringer · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE STRINGER BETWEEN BS 967 TO BS 1016, STR 25L. REPAIRED STRINGER PER SRM.SDR SWAA050979Bear Strap · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON FUSELAGE SKIN BEAR STRAP BETWEEN BS 947 TO BS 967, BETWEEN STR 23L TO STR 27R. REPAIRED BEAR STRAP SECTION PER SRM.SDR SWAA050764Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FLOOR WEB CRACKED RT SIDE BETWEEN BS 188 & BS 196, WL 208. REPAIRED WEB PER SRM.SDR SWAA050746Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA OUTBOARD CHORD CRACKS AT BS 188, LBL 29 & RBL 29, WL 207. REPAIRED CHORD PER SRM.SDR SWAA050596Shear Tie · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON SHEAR TIE AT BS 344, LBL 8-12, WL 148. REPAIRED SHEAR TIE PER SRM.SDR SWAA050595Shear Tie · corrodedDURING SCHEDULED SPECIAL VISIT, FOUND CORROSION ON SHEAR TIE AT BS 380, LBL 5 TO RBL 5, WL 148. REPAIRED SHEAR TIE PER SRM.
Back to N657SW, cancelled Mar 15, 2018