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 SWAA041814Slide · out of adjustDURING SCHEDULED 1/4D CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041813Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 480, LBL 18, CORRODED. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA041812Stringer · corrodedDURING SCHEDULED 1/4D CHECK, FOUND STRINGER 27L AT BS 500D, CORRODED. REMOVED AND REPLACED STRINGER SECTION PER SRM.SDR SWAA041811Shear Tie · corrodedDURING SCHEDULED 1/4D CHECK, FOUND SHEAR TIE AT BS 767, BETWEEN STRINGER 25R AND STRINGER 26R, CORRODED. REPAIRED SHEAR TIE PER SRM.SDR SWAA041776Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FUSELAGE SKIN AT BS 303.9, STRINGER 20L, CRACKED. REPAIRED SKIN PER EA.SDR SWAA041698Slide · out of adjustR2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA041125Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 515, STRINGER 12R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA041124Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN AT BS 767, STRINGER 19R, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA040730Fitting · brokenLT WING OUTBD FORE FLAP ATTACH FITTING BROKEN. REMOVED AND REPLACED LT WING OUTBD FORE FLAP PER MM.SDR SWAA040515Slide · out of adjustDURING SCHEDULED A2 CHECK, FOUND R2 DOOR EVAC SLIDE OUT OF ADJUST. ADJUSTED R2 DOOR EVAC SLIDE PER MM.SDR SWAA040393Flap · delaminatedRT WING OUTBOARD AFT FLAP T/E DELAMINATED. REPAIRED RT WING T/E FLAP PER SRM.SDR SWAA040083Skin · crackedDURING SCHEDULED C4 CHECK, FOUND SKIN CRACKS AT BS 520, STRINGER 10R AND BS 747, STRINGER 23R. REPAIRED SKIN CRACKS PER SRM.SDR SWAA032357Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 727E -747, STR 21R. REPAIRED SKIN PER SRM.SDR SWAA032356Skin · bulgedDURING SCHEDULED SPECIAL VISIT, FOUND RT WING OUTBD MID FLAP SKIN BULGED. REMOVED AND REPLACED FLAP PER MM.SDR SWAA032355Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BS 178 BULKHEAD WEB CRACKED AT WL 201, RBL 5.5. REPAIRED WEB PER SRM.SDR SWAA032152Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 847, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA031409Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) BS 767 AT STR 24L AND BS 870 AT STR 24R. REPAIRED SKIN PER SRM.SDR SWAA030646Light · inoperativeDURING SCHEDULED C1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED EXIT LIGHT ASSY PER MM.SDR SWAA030645Light · inoperativeDURING SCHEDULED C3 CHECK, FOUND SEVERAL LOWER EMERGENCY EXIT LIGHTS AT BOTH CABIN SVC DOORS AND FWD ENTRY DOOR LAMPS INOP. RELAMPED EXIT LIGHTS PER MM.SDR SWAA030642Cable · misroutedDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE CABLE MISROUTED. REROUTED CABLE PER MM.SDR SWAA030644Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FUSELAGE SKIN CRACKED JUST AFT OF BS 727E, STR 24L. REPAIRED SKIN PER SRM.SDR SWAA022458Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRY DOOR EMERGENCY EXIT LIGHT INOP. RELAMPED EXIT LIGHT PER MM.SDR SWAA022081Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD LOWER CORNER OF AFT SVC DOOR CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA022050Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 747, STR 22R. REPAIRED SKIN PER SRM.SDR SWAA021742Circuit Board · faultyNOSE GEAR RED UNSAFE LIGHT REMAINED ILLUMINATED AFTER RAISING GEAR HANDLE. REMOVED AND REPLACED PRINTED CIRCUIT BOARDS M983 AND M1215 PER MM.SDR SWAA020704Slide · out of positionAFT ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA020456Slide · out of positionDURING SCHEDULED C1 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA013451Spar · corrodedDURING SCHEDULED D-CHECK, FOUND LT STAB UPPER REAR SPAR CHORD CORRODED 37 INCHES FROM OUTBOARD END. REPAIRED SPAR CHORD PER SRM.SDR SWAA013450Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 294, WL 208 AND LBL 47. REPAIRED FLOORBEAM PER BFG ER.SDR SWAA013449Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 312, WL 254 AND LBL 61. REPAIRED FRAME PER SRM.SDR SWAA013431Skin · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 468, UNDER NR 1 DME ANTENNA. REPAIRED SKIN PER SRM.SDR SWAA013408Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED, BS 1104, STRINGER 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA013407Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEB CORRODED, BS 867 AND BS 887, LT SIDE. REPAIRED CREASE BEAM PER SRM.SDR SWAA013406Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND 2 EA STRINGER CLIPS CRACKED, BS 663, STRINGERS 10L AND 10R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA013389Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED, BS 360, BETWEEN STRINGERS 14L AND 15L. REPAIRED SHEAR TIE PER SRM.SDR SWAA013388Stringer Clip · crackedDURING SCHEDULED D-CHECK, FOUND 2 EA STRINGER CLIPS CRACKED, BS 597, STRINGERS 5L AND 7L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA013387Crease Beam · corrodedDURING SCHEDULED D-CHECK, FOUND CREASE BEAM WEBS CORRODED, BS 790 RT SIDE AND BS 639 TO 663 LT SIDE. REPAIRED WEB SECTIONS PER SRM.SDR SWAA013372Stringer · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER 24L CORRODED, BS 500B+9. REPAIRED STRINGER SECTION PER SRM.SDR SWAA013371Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION AT FLOORBEAM UPPER CHORD, BS 312, LBL 20 TO RBL 22, WL 208. REMOVED AND REPLACED UPPER CHORD SECTION PER SRM.SDR SWAA013373Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT 2 EA PLACES, BS 616, LBL65 AND RBL 65, WL 200. REPAIRED FRAME PER SRM.SDR SWAA012846Cover · looseDURING SCHEDULED C4 CHECK, FOUND EEPLS COVER LOOSE AT ROW 1. SECURED COVER PER MM.SDR SWAA012744Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED ( 3 EA )AT BS 178, BETWEEN LBL 1.0 & LBL 12.0, BETWEEN WL 187 & WL 218. REPAIRED WEB PER SRM.SDR SWAA012718Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND WEB CRACKED AT BS 178, WL 187 & RBL 1.0. REPAIRED WEB PER SRM.SDR SWAA012684Intercostal · crackedDURING SCHEDULED SPECIAL VISIT, FOUND INTERCOSTAL CRACKED AT BS 178, LBL 24 & WL 207. REPAIRED INTERCOSTAL PER SRM.SDR SWAA012690Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND VERTICAL BEAM WEBS CRACKED (2 EA) AT BS 178, RBL 17.1 & WL 235, LBL 17.1 & WL 227. REMOVED AND REPLACED WEBS PER SRM.SDR SWAA012689Angle · crackedDURING SCHEDULED SPECIAL VISIT, FOUND L ANGLES CRACKED ( 2 EA ) AT BS 178, WL 207, LBL 24 & RBL 24. R&R ANGLES PER SRM.SDR SWAA012012Track · looseDURING SCHEDULED C3 CHECK, FOUND EEPLS TRACK LOOSE AT ROW 8. SECURED EEPLS PER MM.SDR SWAA012019Slat · crackedDURING SCHEDULED C3 CHECK, FOUND 2 EA CRACKS AT # 5 L/E SLAT LOWER SKIN AFT ROW OF RIVETS, CRACKS ARE 1 & 5/8 IN LENGTH. REPAIRED SKIN PER SRM.SDR SWAA011004Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD UPPER CORNER OF AIRSTAIR DOOR CUTOUT. REPAIRED SKIN PER SWA RA.SDR SWAA010998Flap · delaminatedDURING SCHEDULED C2 CHECK, FOUND LT WING OUTBOARD FOREFLAP DELAMINATED AT T/E, INBOARD CORNER. REMOVED AND REPLACED FOREFLAP PER MM.
Back to N692SW, cancelled Sep 7, 2017