N692SW, cancelled Sep 7, 2017
Service difficulty reports · 434
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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 = 'N692SW' AND deregistration_id = 'N692SW-2017-09-07' 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 SWAA070524Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 28L CORRODED AT BS 362. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA070531Torque Tube · corrodedDURING SCHEDULED 22Y CHECK, FOUND LEFT INBOARD FORE FLAP INBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA070523Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 747, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070530Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND LT WING INBOARD MID FLAP OUTBOARD T/E DELMAINATED. REPAIRED MID FLAP PER SRM.SDR SWAA070528Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, 2 O'CLOCK POSITION. REPAIRED WEB PER SRM.SDR SWAA070529Bulkhead · crackedDURING SCHEDULED 22Y CHECK, FOUND AFT PRESSURE BULKHEAD WEB CRACKED AT BS 1016, 4 O'CLOCK POSITION. REPAIRED WEB PER SRM.SDR SWAA070526Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 727E, STR 19R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA070525Shear Tie · corrodedDURING SCHEDULED 22Y CHECK, FOUND SHEAR TIE CORRODED AT BS 787, STR 26R. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA070527Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA070317Fitting · corrodedDURING SCHEDULED 22Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR FITTING CORRODED. REMOVED AND REPLACED GIRT BAR FITTING PER SRM.SDR SWAA070316Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 344, STR 11R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070315Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 25R CORRODED AT BS 908. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA070300Skin · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RIGHT WING INBOARD FORE FLAP UPPER SURFACE DELAMINATED AT OUTBOARD END. REPAIRED FORE FLAP PER SRM.SDR SWAA070299Wedge · delaminatedDURING SCHEDULED 22Y CHECK, FOUND RT WING INBOARD MID FLAP WEDGE LOWER SKIN DELAMINATED AT OUTBOARD END. REPAIRED MID FLAP WEDGE PER SRM.SDR SWAA070298Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 500, STR 24L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070297Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 400, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070296Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 22R CORRODED AT BS 848. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA070295Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 23R CORRODED AT BS 848. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA070294Stringer · corrodedDURING SCHEDULED 22Y CHECK, FOUND STRINGER 24R CORRODED AT BS 848. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA070245Torque Tube · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT WING INBOARD MID FLAP INBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA070244Torque Tube · corrodedDURING SCHEDULED 22Y CHECK, FOUND RT WING INBOARD MID FLAP OUTBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA070243Torque Tube · corrodedDURING SCHEDULED 22Y CHECK, FOUND LT WING INBOARD MID FLAP OUTBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA070242Torque Tube · corrodedDURING SCHEDULED 22Y CHECK, FOUND LT WING INBOARD MID FLAP INBOARD TORQUE TUBE CORRODED. REMOVED AND REPLACED TORQUE TUBE PER MM.SDR SWAA070220Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 21R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070219Stringer Clip · crackedDURING SCHEDULED 22Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 767, STR 20R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA070214Carriage · corrodedDURING SCHEDULED 22Y CHECK, FOUND LT WING INBOARD MID FLAP OUTBOARD CARRIAGE CORRODED. REMOVED AND REPLACED MID FLAP CARRIAGE PER MM.SDR SWAA070130Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, RBL 5, WL 208. REMOVED AND REPLACED FLOORBEAM SECTION PER SRM.SDR SWAA064275Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA064057Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA063724Slide · out of adjustL2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062939Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND SIDEWALL EMERGENCY EXIT LIGHT INOP AT L1 DOOR. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062938Slide · out of adjustDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED EVAC SLIDE PER MM.SDR SWAA062937Lamp · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT EXTERIOR LIGHT INOP AT R1 DOOR. REMOVED AND REPLACED LIGHT BULB PER MM.SDR SWAA062674Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 14L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062673Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 14L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062672Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 14L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062671Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA062670Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 348, STR 15L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062669Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR FRAME CUTOUT, FWD FRAME CRACKED AT BS 440, NR 1 AND NR 5 DOOR STOP FITTINGS. REMOVED AND REPLACED FRAME SECTION PER BOEING DRAWING AND SRM.SDR SWAA062668Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 291.5, STR 16R. REPAIRED FRAME SECTION PER ER.SDR SWAA062597Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 750, STR 18L. REPAIRED SKIN PER SRM.SDR SWAA062537Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 14L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062536Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 348, STR 15L. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062535Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 745, STR 19R. REPAIRED SKIN PER SWA EA.SDR SWAA062502Door Frame · corrodedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR FRAME CUTOUT, FWD FRAME CORRODED AT STR 24R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA062501Shear Tie · crackedDURING SCHEDULED SPV CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA062442Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 807, STR 14L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062441Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 767, STR 14L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062440Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 348, STR 15L. REPAIRED FRAME SECTION PER SRM.SDR SWAA062423Stringer Splice · crackedDURING SCHEDULED SPV CHECK, FOUND STRINGER SPLICE CRACKED AT BS 358, STR 16L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.
Back to N692SW, cancelled Sep 7, 2017