N305SW, cancelled Sep 1, 2011
Service difficulty reports · 324
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 = 'N305SW' AND deregistration_id = 'N305SW-2011-09-01' 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 = 'N305SW' AND deregistration_id = 'N305SW-2011-09-01' 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 SWAA031441Skin · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE SKIN BULGING AT BS 500 + 10, STR 28R. REPAIRED SKIN PER SRM.SDR SWAA031400Floor Support · corrodedDURING SCHEDULED D CHECK, FOUND FLOOR SUPPORT CORRODED BETWEEN BS 1006 AND BS 1016, BETWEEN LBL 5 AND LBL 10, WL 208. REPAIRED FLOOR SUPPORT PER SRM.SDR SWAA031392Stringer · corrodedDURING SCHEDULED D CHECK, FOUND STRINGER CORRODED BETWEEN BS 807 AND BS 815, STR 26R. REMOVED AND REPLACED CORRODED SECTION OF STRINGER PER SRM.SDR SWAA031401Structure · corrodedDURING SCHEDULED D CHECK, FOUND UPPER TEE STRUCTURE CORRODED AT BS 1016, WL 208, BETWEEN LBL 5 AND LBL 28. REPAIRED TEE STRUCTURE PER SRM.SDR SWAA031349Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIPS CRACKED (2 EA) AT STR 26R, BS 787 AND BS 792. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA031346Drag Angle · corrodedDURING SCHEDULED D CHECK, FOUND VERTICAL FIN ATTACH CLEVIS DRAG ANGLES CORRODED LT SIDE (2 EA). REMOVED AND REPLACED VERTICAL FIN DRAG ANGLES PER SRM.SDR SWAA031345Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (2 EA) BETWEEN STR 8R AND STR 9R, BS 480 AND BS 847. REPAIRED FRAMES PER SRM.SDR SWAA031344Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAMES CRACKED (3 EA) BETWEEN STR 8L AND STR 9L, BS 727E, BS 807 AND BS 847. REPAIRED FRAMES PER SRM.SDR SWAA031289Shear Tie · crackedDURING SCHEDULED D-CHECK, FOUND SHEAR TIE CRACKED AT BS 967, STR 7L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA031297Stringer · corrodedDURING SCHEDULED D CHECK, FOUND STRINGER CORRODED AT BS 500 + 15, STR 26R. REPAIRED STRINGER PER SRM.SDR SWAA031287Stringer Clip · corrodedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CORRODED AT BS 767, WL148, RBL 15. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA031286Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 887, BETWEEN STR 8L AT STR 9L. REPAIRED FRAME PER SRM.SDR SWAA031257Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 360, BETWEEN STR 8L AND STR 9L. REPAIRED FRAME PER SRM.SDR SWAA031256Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER CLIP CRACKED AT BS 616, STR 8L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA031237Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER TIE CLIP CRACKED AT BS 727A, STR 6L. REMOVED AND REPLACED STRINGER TIE CLIP PER SRM.SDR SWAA031255Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, BETWEEN STR 8R AND STR 9R. REPAIRED FRAME PER SRM.SDR SWAA031238Frame · corrodedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 500C, BETWEEN STR 26L AND STR 27L. REPAIRED FRAME PER SRM.SDR SWAA031236Splice · crackedDURING SCHEDULED D CHECK, FOUND STRINGER SPLICE CRACKED AT BS 907, STR 4L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA031218Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIES CORRODED (2 EA) AT BS 747, WL 148, RBL 10 AND BS 847, WL 148, BL 0. REMOVED AND REPLACED SHEAR TIES PER SRM.SDR SWAA031213Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, BETWEEN STR 7L AND STR 8L. REPAIRED FRAME PER SRM.SDR SWAA031239Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 13R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA031186Stringer · corrodedDURING SCHEDULED D CHECK, FOUND STRINGER CORRODED AT BS 500C, STR 24R. REPAIRED STRINGER PER SRM.SDR SWAA031180Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER TIE CLIPS CRACKED (4 EA) BS 616 AT STR 5R, BS 727 AT STR 7L, BS 727C AT STR 4R AND BS 727E AT STR 5L. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA031177Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND STRINGER TIE CLIPS CRACKED (2 EA) AT STR 7L, BS 727B AND BS 727D. REMOVED AND REPLACED STRINGER TIE CLIPS PER SRM.SDR SWAA031191Beam · crackedDURING SCHEDULED D CHECK, FOUND RT OUTBD LOWER VERTICAL BEAM CRACKED AT BS 188, WL 203 TO WL 214 AT RBL 30. REPAIRED VERTICAL BEAM PER SRM.SDR SWAA031176Shear Tie · corrodedDURING SCHEDULED D CHECK, FOUND SHEAR TIE CORRODED AT BS 727D, WL 14 AND RBL 9. REPAIRED SHEAR TIE PER SRM.SDR SWAA031178Frame · crackedDURING SCHEDULED D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 178, WL 232. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA031151Stringer Clip · crackedDURING SCHEDULED D CHECK, FOUND 2 EA STRINGER CLIPS CRACKED, STRINGER 5R, BS 727B AND BS 727E. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA030717Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED (5 EA) ABOVE STR 10R, AT BS 445, BS 470, BS 500, BS 500A AND BS 500B. REPAIRED SKIN PER SRM.SDR SWAA030716Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 475, STR 16R. REPAIRED SKIN PER SRM.SDR SWAA030300Charger · inoperativeDURING SCHEDULED RON, FOUND EEPLS INOP AT ROWS 9, 7 AND 11. REMOVED AND REPLACED BATTERY CHARGER AND BATTERY PER MM.SDR SWAA030250Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND RT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA030200Arm · corrodedDURING SCHEDULED A2 CHECK, SWA SI 11251-32, FOUND BOTH LT/RT MLG CLEVIS BEAM ARMS CORRODED. REMOVED AND REPLACED BOTH LT/RT MLG CLEVIS BEAM ARMS PER MM.SDR SWAA030199Trunnion Pin · corrodedDURING SCHEDULED A2 CHECK, SWA SI 11251-32, FOUND BOTH LT AND RT MLG TRUNNION PINS CORRODED. REMOVED AND REPLACED BOTH LT AND RT MLG TRUNNION PINS PER MM.SDR SWAA022966Battery · dischargedDURING SCHEDULED C1 CHECK, FOUND LT OVERWING EMERGENCY EXIT LIGHT INOP. REMOVED AND REPLACED BATTERY PER MM.SDR SWAA022909Battery · dischargedDURING SCHEDULED SPECIAL VISIT, FOUND EMERGENCY EXIT LIGHTS AT ROW NR 7, NR 9, NR 11, NR 19 AND NR 20 LT INOP. REMOVED AND REPLACED BATTERY (M1135) PER MM.SDR SWAA022908Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND PAX WINDOW CUTOUTS CRACKED AT RT WINDOWS NR 29 AND NR 35. REPAIRED SKIN PER BFG ER.SDR SWAA022907Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED AT BS 769, STR 10R. REPAIRED SKIN PER SRM.SDR SWAA022879Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND PAX WINDOW CUTOUTS CRACKED AT WINDOWS NR 12, NR 30, NR 32 AND NR 33. REPAIRED SKIN PER BFG ER & SRM.SDR SWAA022819Splice · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER SPLICE CRACKED AT BS 360, STRINGER 14L. REMOVED AND REPLACED STRINGER SPLICE PER SRM.SDR SWAA022799Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER CLIPS CRACKED (2 EA) AT STR 4L, BS 400 AND BS 420. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA022663Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 14L AND STR 15L. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA022662Stringer Clip · crackedDURING SCHEDULED SPECIAL VISIT, FOUND STRINGER CLIP CRACKED AT BS 767, STR 13R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA022661Frame · brokenDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME BROKEN AT BS 767, STR 13R. REPAIRED FRAME PER SRM.SDR SWAA022633Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND SHEAR TIE CRACKED AT BS 360, BETWEEN STR 13L AND STR 14L. REPAIRED SHEAR TIE PER SRM.SDR SWAA021687Frame · corrodedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 967, BL O. REPAIRED FRAME PER SRM.SDR SWAA021665Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 520, STR 4L. REPAIRED SKIN PER SRM.SDR SWAA021571Skin · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SKIN CRACKED (3 EA) 1.5 LONG AT STR 10R, BS 382, BS 500 PLUS 5 AND BS 500 PLUS 13. REPAIRED SKIN PER SWA RA AND SRM.SDR SWAA021464Cover · looseOVERHEAD EMERGENCY EXIT LIGHT COVER LOOSE AT OVERWING EXIT'S. REMOVED AND REPLACED EXIT LIGHT ASSY PER MM.SDR SWAA020853Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 727D, ABOVE STR 20L. REPAIRED SKIN PER SRM.
Back to N305SW, cancelled Sep 1, 2011