N660SW, cancelled Sep 19, 2016
Service difficulty reports · 531
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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 = 'N660SW' AND deregistration_id = 'N660SW-2016-09-19' 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 SWAA051638Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, LEFT SIDE, WL 208. REPAIRED STUB FRAME PER SRM.SDR SWAA051617Splice · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CORRODED AT BS 360, BETWEEN STR 27L & STR 28R. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA051620Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 887, STR 9L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051619Stringer · crackedDURING SCHEDULED D-CHECK, FOUND BS 1016 AFT PRESS BULKHEAD RADIAL STRINGER CRACKED AT 8 O'CLOCK POSITION. REPAIRED RADIAL STRINGER PER SRM.SDR SWAA051618Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 360, STR 27L TO STR 28L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051622Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CRACKED AT BS 727A + 17.5, RBL 44 & RBL 46, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA051621Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RIGHT SIDE, WL 208. REPAIRED STUB FRAME PER SRM.SDR SWAA051610Wedge · delaminatedDURING SCHEDULED D-CHECK, FOUND NR 5 L/E SLAT UPPER INBOARD T/E WEDGE DELAMINATED. REPAIRED NR 5 SLAT PER SRM.SDR SWAA051609Wedge · delaminatedDURING SCHEDULED D-CHECK, FOUND NR 4 L/E SLAT UPPER INBOARD T/E WEDGE DELAMINATED. REMOVED AND REPLACED NR 4 SLAT PER MM.SDR SWAA051608Skin · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D + 7, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA051607Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 363, STR 25R. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA051606Spar · crackedDURING SCHEDULED D-CHECK, FOUND LT & RT WING REAR SPAR UPPER CHORDS CRACKED AT MLG BEAM 2ND INBOARD CUTOUT HOLE. REMOVED AND REPLACED REAR SPAR UPPER CHORDS PER BFG ER.SDR SWAA051594Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND COCKPIT FLOORBEAM UPPER CHORD CORRODED AT BS 260, LBL 9 TO RBL 9, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA051593Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE BS 1016 PRESS BULKHEAD DOME WEB CRACKED AT BL 0, WL 249. REPAIRED WEB PER BFG ER.SDR SWAA051592Lug · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT VERTICAL STAB FWD & AFT FAILSAFE CLEVIS LUG FACES CORRODED. REPAIRED LUG FACES PER BFG ER.SDR SWAA051591Lug · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT VERTICAL STAB FITTING FWD & AFT PRIMARY CLEVIS LUG FACES CORRODED. REPAIRED LUG FACES PER BFG ER.SDR SWAA051590Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 986, ABOVE L2 DOOR UPPER AFT CUTOUT. REPAIRED FRAME PER SRM.SDR SWAA051571Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 908, STR 4L & STR 4R. REMOVED AND REPLACED STR SPLICE PER SRM.SDR SWAA051570Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED AT BS 727A, STR 2R. REMOVED AND REPLACED STR CLIP PER SRM.SDR SWAA051569Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051568Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051573Stringer · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CRACKED AT BS 620, STR 4L. REPAIRED STRINGER PER SRM.SDR SWAA051572Skin · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN TEAR STRAP CORRODED AT BS 370, STR 25L. REPAIRED SKIN PER SRM.SDR SWAA051550Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 616, BETWEEN STR 1 & STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051549Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 597, BETWEEN STR 2L & STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051548Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 597, BETWEEN STR 2R & STR 9R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051547Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 578, STR 2L & STR 8R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051558Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 727E, STR 22R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051557Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727E, STR 23R TO STR 24R. REPAIRED FRAME PER SRM.SDR SWAA051556Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 351 TO BS 370, STR 22L. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA051555Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 727C, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051554Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 706, STR 2L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051553Fitting · corrodedDURING SCHEDULED D-CHECK, FOUND LT & RT HORIZONTAL STAB FITTING LUG FACES CORRODED. REPAIRED LUG FACES PER SRM.SDR SWAA051552Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 663, STR 1, STR 2L & STR 2R. REPAIRED FRAME PER SRM.SDR SWAA051551Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 616, STR 7R TO STR 8R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051538Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 500A, STR 16R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051536Splice · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER SPLICE CRACKED AT BS 536, STR 10R. REMOVED AND REPLACED SPLICE PER SRM.SDR SWAA051534Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CORRODED AT BS 500B, STR 27R. REPAIRED STRINGER PER SRM.SDR SWAA051533Shear Tie · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SHEAR TIE CORRODED AT BS 500C, BETWEEN STR 26L TO STR 27L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051542Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA051541Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051540Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA051539Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 9L & STR 9R. REPAIRED FRAME PER SRM.SDR SWAA051537Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 500D, STR 3R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA051535Frame · corrodedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 767, LBL 10. REPAIRED FRAME PER SRM.SDR SWAA051427Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 344, STR 11R & STR 13R. REMOVED AND REPLACED CLIPS PER SRM.SDR SWAA051428Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE STRINGER CLIP CRACKED AT BS 360, STR 8L. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA050395Slide · reads lowDURING SCHEDULED RON, FOUND L2 DOOR EVAC SLIDE LOW PRESSURE IND. REMOVED AND REPLACED L2 DOOR EVAC SLIDE PER MM.SDR SWAA050206Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN AT BS 500C, STRINGER 16L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA050096Skin · crackedDURING SCHEDULED C4 CHECK, FOUND 3 EACH FUSELAGE SKIN CRACKS BETWEEN BS 440 AND BS 480, STRINGER 10R. REPAIRED SKIN SECTIONS PER EA.
Back to N660SW, cancelled Sep 19, 2016