N338SW, cancelled Oct 26, 2012
Service difficulty reports · 300
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 = 'N338SW' AND deregistration_id = 'N338SW-2012-10-26' 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 = 'N338SW' AND deregistration_id = 'N338SW-2012-10-26' 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 SWAA981973Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME BETWEEN STR 8R AND STR 9R AT BS 867 AND BS 827. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981972Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME BETWEEN STR 8L AND STR 9L AT BS 827. REPAIRED PER TRAMCO EWO NR 98-0751.SDR SWAA981971Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME BETWEEN STR 8L AND STR 9L AT BS 747. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981970Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME BETWEEN STR 8L AND STR 9L AT BS 727D. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981931Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 380 BELOW STR 8 RT. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981930Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 440 BELOW STR 8 RT. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981929Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 500A BELOW STR 8 RT. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981928Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 500C BELOW STR 8 RT. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981927Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 500A BELOW STR 8 LT. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981926Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 480 BELOW STR 8 LT. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981925Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 440 BELOW STR 8 LT. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981924Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME AT BS 400 BELOW STR 8 LT. REPAIRED PER TRAMCO EWO NR 98-0751. REPAIRED PER BOEING SRM.SDR SWAA981922Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED INTERCOSTAL AT BS 500B TO 500C, RBL 26, WL 159. REPAIRED PER BOEING SRM.SDR SWAA981921Stringer · damagedDURING SCHEDULED D-CHECK, FOUND STRINGER TIE CLIP MECHANICALLY DAMAGED AT BS 787, STR 21 RT. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981920Angle · corrodedDURING SCHEDULED D-CHECK, FOUND AFT GALLEY SERVICE DOORWAY THRESHOLD Z ANGLES CORRODED. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981906Clip · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER CLIP CRACKED IN AFT CARGO BAY AT BS 867, STR 24R. REPAIRED PER BOEING SRM.SDR SWAA981905Bulkhead · corrodedDURING SCHEDULED D-CHECK, FOUND BULKHEAD SUPPORT ANGLE AT BS 500D, RBL 24 TO LBL 24, WL 156 CORRODED SURFACE AROUND NUT PLATE . REPAIRED PER BOEING SRM.SDR SWAA981904Skin · dentedDURING SCHEDULED D-CHECK, FOUND DENTED SKIN AT BS 367, 1 BELOW STR 5L. REPAIRED PER BOEING SRM.SDR SWAA981903Web · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB AT STR 7L, BS 295 FWD OF FWD ENTRY DOOR. REPAIRED PER BOEING SRM.SDR SWAA981902Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED UPPER SURFACE OF WEB AT WL 208, BS 390, RBL 70. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981901Support · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 294-312, LBL 12, WL 208 CORRODED. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981900Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER 8R AT BS 344. REPAIRED PER BOEING SRM.SDR SWAA981899Frame · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED FRAME BETWEEN STR 8L AND 9L AT BS 867. REPAIRED PER BOEING SRM.SDR SWAA981898Angle · damagedDURING SCHEDULED D-CHECK, FOUND NR 1 PYLON ANGLE LOWER EDGE OF I/B FLAP CUTOUT DAMAGED. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981897Keel Beam · chafedDURING SCHEDULED D-CHECK, FOUND KEEL BEAM FLANGE RT OUT BOARD CHAFED AROUND FASTENER HOLES AT BS 712.5 TO 725, RBL 6. REPAIRED PER BOEING SRM.SDR SWAA981895Shear Tie · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED SHEAR TIE BETWEEN STR 22R AND 23R AT BS 907 AND STR 23R AND 24R AT BS 907. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981894Shear Tie · damagedDURING SCHEDULED D-CHECK, FOUND DAMAGED SHEAR TIE BETWEEN STR 21R AND 22R AT BS 907. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981893Frame · gougedDURING SCHEDULED D-CHECK, FOUND AFT CARGO BAY FWD DOOR FRAME NR 5 STOP PAD FITTING WITH DEEP GOUGES. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981892Stringer · crackedDURING SCHEDULED D-CHECK, FOUND STRINGER 5 RT LOWER CHORD CRACKED AT BS 1142. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981889Skin · dentedDURING SCHEDULED D-CHECK, FOUND SKIN DENTED AT BS 890 BETWEEN STRINGERS 25-26 RT. REPAIRED PER BOEING SRM. REPAIRED PER BOEING SRM.SDR SWAA981888Bulkhead · crackedDURING SCHEDULED D-CHECK, FOUND BS 178 BULKHEAD CRACKED LBL 1, WL 186. REPAIRED PER BOEING SRM.SDR SWAA981887Bulkhead Chord · crackedDURING SCHEDULED D-CHECK, FOUND VERTICAL CHORD CRACKED ON AFT SIDE OF 178 BULKHEAD, LBL 5.7, WL 184. REPAIRED PER BOEING SRM.SDR SWAA981886Bracket · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED AT BS 344, LBL 60, WL 208 ON GIRT BAR BRACKET MOUNT PAD. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981885Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED AT BS 270 Z ANGLE, LBL 12 TO RBL 12. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981883Angle · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED SUPPORT ANGLE AT BS 984, LTBL 53, WL 207. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981872Web · corrodedDURING SCHEDULED D-CHECK, FOUND CRACKED WEB AT BS 986.5 - 1016, LBL 35-45, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981871Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORRODED ON CREASE BEAM WEB AT BS 727B-727C, WL 208, LBL 60. REPAIRED PER BOEING SRM.SDR SWAA981870Web · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON CREASE BEAM WEB AT BS 727A-727B, WL 208. REPAIRED PER BOEING SRM.SDR SWAA981869Support · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 992, WL 208, LBL 24. REPAIRED PER BOEING SRM.SDR SWAA981868Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD UPPER SURFACE CORRODED AT BS 1008 & 1014, WL 208, LBL 30.5 & LBL 6.0. REPAIRED PER BOEING SRM.SDR SWAA981867Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD UPPER SURFACE CORRODED AT BS 986.5, WL 208, LBL 4.75, LBL 13.5 & LBL 30.5. REPAIRED PER BOEING SRM.SDR SWAA981866Floorbeam · gougedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD UPPER SURFACE FWD EDGE GOUGED AT BS 986, WL 208, RBL 44. REPAIRED PER BOEING SRM.SDR SWAA981822Support · crackedDURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 312-328, LBL 12, WL 208 CRACKED. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981821Stiffener · crackedDURING SCHEDULED D-CHECK, FOUND FLOOR STIFFENER CRACKED AT BS 538, RBL 2, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981820Frame · crackedDURING SCHEDULED D-CHECK, FOUND FRAME CRACKED AT BS 616, WL 201, LBL 65. REMOVED AND REPLACED PER TRAMCO EWO NR 98-0743.SDR SWAA981819Frame · dentedDURING SCHEDULED D-CHECK, FOUND FRAME DENTED AT BS 907, WL 172, LBL 24. REMOVED AND REPLACED PER TRAMCO EWO NR 98-0774.SDR SWAA981815Intercostal · corrodedDURING SCHEDULED D-CHECK, FOUND INTERCOSTAL CORRODED AT BS 787-791, STR 25R IN AFT CARGO BAY. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA970451Skin · crackedDURING SCHEDULED BC1 CHECK, FOUND A 2.5 INCH FUSELAGE SKIN CRACK AT BS 870, AT S24R. REPAIRED PER BOEING SRM.SDR SWAA961276Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 880, ABOVE S25R. REPAIRED PER BOEING SRM.SDR SWAA960020Floorbeam · corrodedDURING SCHEDULED MAINT CHECK, FOUND FLOORBEAM CORROSION AT BS 772 LBL 12.25 RBL 3, RBL 7.5, RBL 8.25 AND RBL 13.25. REPAIRED PER BOEING SRM.
Back to N338SW, cancelled Oct 26, 2012