N348SW, cancelled Jul 16, 2012
Service difficulty reports · 282
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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 = 'N348SW' AND deregistration_id = 'N348SW-2012-07-16' 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 SWAA043339Cable · misroutedDURING SCHEDULED SERVICE CHECK, FOUND L2 DOOR EVAC SLIDE GIRT BAR CABLE MISROUTED. REROUTED L2 DOOR CABLE PER MM.SDR SWAA042413Skin · crackedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN AT BS 517, STRINGER 10R, BS 506, STRINGER 10L, CRACKED. REPAIRED SKIN PER SRM.SDR SWAA042414Skin · crackedDURING SCHEDULED C4 CHECK, FOUND RIGHT WING NR 6 L/E SLAT SKIN CRACKED. REPAIRED RIGHT WING NR 6 L/E SLAT SKIN PER SRM.SDR SWAA041696Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND 3 EA FUSELAGE SKIN CRACKS AT BS 930 TO BS 947, BETWEEN STRINGERS 21R & 24R. REPAIRED SKIN PER SWA EA & SRM.SDR SWAA041532Glowstrip · loosePHOTO LUMINESCENT STRIP LOOSE AT RT ROW 7 AND RT ROW 8. SECURED STRIP PER MM.SDR SWAA040851Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FWD CARGO DOOR FRAME CUTOUT AT BS 440, LOWER STOP CRACKED. REPAIRED FRAME PER T1-653-044.SDR SWAA040822Lens · missingDURING SCHEDULED 1/2D CHECK, FOUND EMERGENCY EXIT LIGHT LENS MISSING IN BULLNOSE AT ROW 3 ABC. REINSTALLED EMERGENCY EXIT LIGHT LENS PER MM.SDR SWAA040821Rib · crackedDURING SCHEDULED 1/2D CHECK, FOUND LT WING RIB LOWER CHORD AT WS 135.5, BETWEEN S-2 AND S-3, CRACKED. REPAIRED LT WING RIB CHORD PER ACO.SDR SWAA040812Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND L1 DOOR EVAC SLIDE AFT GIRT BAR MOUNT FITTING CORRODED. REMOVED AND REPLACED L1 DOOR EVAC SLIDE MOUNT FITTING PER SRM.SDR SWAA040811Light · looseDURING SCHEDULED 1/2D CHECK, FOUND BULLNOSE EMERGENCY EXIT LIGHT LOOSE AT ROW 14 ABC. SECURED EMERGENCY EXIT LIGHT PER MM.SDR SWAA040799Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EA STRINGER CLIPS CRACKED AT BS 380, STR 26L & STR 26R. REMOVED AND REPLACED STRINGER CLIPS PER SRM.SDR SWAA040791Stringer Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND STRINGER CLIP CRACKED AT BS 727B, STR 22R. REMOVED AND REPLACED CLIP PER SRM.SDR SWAA040790Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 33 TO RBL 39. REPAIRED FLOORBEAM PER SRM.SDR SWAA040743Skin · delaminatedDURING SCHEDULED 1/2D CHECK, FOUND NR 2 AND NR 5 L/E SLAT TRAILING EDGES DELAMINATED. REPAIRED SLATS PER SRM.SDR SWAA040742Web · corrodedDURING SCHEDULED 1/2D CHECK, FOUND WEB CORRODED AT BS 360 TO BS 380, STR 17R. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA040722Clip · crackedDURING SCHEDULED 1/2D CHECK, FOUND 2 EA STRINGER CLIPS CRACKED AT BS 787, STR 25L AND BS 807, STR 25L. REMOVED AND REPLACED STR CLIPS PER SRM.SDR SWAA040726Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CORRODED AT BS 500, STR 27R. REPAIRED SHEAR TIE PER SRM.SDR SWAA040725Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 65, WL 208. REPAIRED FRAME PER T1-153-018.SDR SWAA040724Fitting · corrodedDURING SCHEDULED 1/2D CHECK, FOUND RT MLG FWD STABILIZER BAR ATTACH FITTING CORRODED. REMOVED AND REPLACED FITTING PER MM.SDR SWAA040723Shear Tie · corrodedDURING SCHEDULED 1/2D CHECK, FOUND SHEAR TIE CORRODED AT BS 500, STR 27L. REPAIRED SHEAR TIE PER SRM.SDR SWAA040721Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM UPPER CAP CORRODED AT BS 986.5, LBL 5 TO RBL 5. REPAIRED BEAM PER T1-453-037.SDR SWAA040714Floor Support · corrodedDURING SCHEDULED 1/2D CHECK, FOUND AFT CARGO COMPT LONGITUDINAL FLOOR SUPPORT CORRODED AT BS 772, LBL 17 AND RBL 17. REPAIRED SUPPORTS PER SWA EA.SDR SWAA032487Skin · delaminatedDURING SCHEDULED A2 CHECK, FOUND LT WING OUTBD T/E FLAP DELAMINATED AT INBD END. REMOVED AND REPLACED FLAP ASSY PER MM.SDR SWAA032366Fan · overheatedELECTRICAL ODOR THROUGH OUT THE CABIN. REMOVED AND REPLACED A/C RECIRC FAN PER MM.SDR SWAA032187Skin · crackedDURING SCHEDULED C1 CHECK, FOUND AFT CARGO DOOR SKIN CRACKED AT UPPER AFT CORNER. REPAIRED DOOR SKIN PER SWA EA.SDR SWAA031557Slide · out of limitsDURING SCHEDULED PM CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE PRESS INDICATOR OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA031522Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED (2 EA) AT STR 21L, BS 967 AND BS 973. REPAIRED SKIN PER SRM.SDR SWAA031437Skin · delaminatedDURING SCHEDULED C4 CHECK, FOUND RT ELEVATOR TAB DELAMINATED AT NR 3 HINGE. REMOVED AND REPLACED RT ELEVATOR TAB PER MM.SDR SWAA031422Bushing · wornDURING SCHEDULED C4 CHECK, SWA SI 11139-55, RT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED RT ELEVATOR TAB INPUT ROD HARDWARE AND BUSHING.SDR SWAA031421Bushing · wornDURING SCHEDULED C4 CHECK, SWA SI 11139-55, LT ELEVATOR TAB FAILED FREE PLAY CHECK. REMOVED AND REPLACED ELEVATOR TAB INPUT ROD HARDWARE, BUSHING AND ALL HINGE ATTACH POINT HARDWARE PER MM.SDR SWAA031310Stiffener · crackedDURING SCHEDULED SPECIAL VISIT, FOUND LT VERTICAL CHORD CRACKED AT BS 179, LBL 5.7. REPAIRED VERTICAL CHORD PER SRM.SDR SWAA031309Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND BULKHEAD WEB CRACKED AT BS 178, WL 234, LBL 13. REPAIRED BULKHEAD WEB PER SRM.SDR SWAA030656Window Post · crackedDURING SCHEDULED C3 CHECK, FOUND RT COCKPIT WINDOW C POST CRACKED. REPAIRED POST PER SRM.SDR SWAA022786Slide · looseFWD ENTRY DOOR EMERGENCY EVACUATION SLIDE COMING OUT OF CONTAINER. REINSTALLED SLIDE ASY PER MM.SDR SWAA022027Flap · peelingDURING WALK AROUND INSPECTION, FOUND PREVIOUS REPAIR PEELING OFF AT LT T/E INBD FORE FLAP. REMOVED AND REPLACED LT T/E INBD FORE FLAP PER MM.SDR SWAA021262Slide · out of positionFWD ENTRY DOOR EMERGENCY EVAC SLIDE PRESS IND OUT OF VIEW. REPOSITIONED SLIDE PER MM.SDR SWAA021242Lens · looseDURING SCHEDULED C4 CHECK, FOUND OVERHEAD BIN BULL NOSE EMERGENCY EXIT LIGHT LENS LOOSE AT ROW NR 14 ABC. SECURED LENS PER MM.SDR SWAA021241Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND EMERGENCY EXIT LIGHTS AT FWD AND AFT ENTRY DOORS WITH SEVERAL BULBS INOP. RELAMPED LIGHTS PER MM.SDR SWAA020459Lens · looseDURING SCHEDULED BC3 CHECK, FOUND EMERGENCY EXIT LIGHT LENS LOOSE AT LT OVERWING EXIT. SECURED LENS PER MM.SDR SWAA012832Slide · looseFWD ENTRY DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE PER MM.SDR SWAA012422Fitting · corrodedDURING SCHEDULED 1/4D CHECK, FOUND BOTH AFT DOOR EVACUATION SLIDE GIRT BAR FLOOR ATTACH BRACKETS CORRODED. REMOVED AND REPLACED ATTACH BRACKETS PER MM.SDR SWAA012051Light · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT INOP RT AFT EXTERIOR. RELAMPED LIGHT PER MM.SDR SWAA011954Battery Pack · dischargedDURING SCHEDULED RON CHECK, FOUND CABIN EMERGENCY EXIT LIGHTS INOP. RECHARGED BATTERY PACKS PER MM.SDR SWAA011607Web · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND VERTICAL BEAM WEB CRACKED AT BS 180, RBL 17.1. REPAIRED WEB PER SRM.SDR SWAA011615Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND BULKHEAD WEB CRACKED AT BS 178, LBL 6 & WL 200. REPAIRED WEB PER SRM.SDR SWAA011613Stiffener · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND VERTICAL STIFFENER CRACKED AT MLG WW BS 663, LBL 6. REPAIRED PER SWA RA.SDR SWAA011557Slide · out of positionAFT SVC DOOR EMERGENCY EVAC SLIDE FELL OUT OF CONTAINER. INSTALLED EMERGENCY EVAC IN CONTAINER PER MM.SDR SWAA011400Tab · wornDURING SCHEDULED C4 CHECK, FOUND PLAY AT LT ELEVATOR TAB. REMOVED AND REPLACED TAB ASSY PER MM.SDR SWAA010229Bracket · looseDURING SCHEDULED C3 CHECK, FOUND AFT SVC DOOR EMERGENCY EVAC SLIDE GIRT BRACKET LOOSE. SECURED GIRT BRACKET PER MM.SDR SWAA010107Slide · dislodgedAFT SVC DOOR EMERGENCY EVAC SLIDE ASSY FELL OUT OF CONTAINER. REINSTALLED EVAC SLIDE ASSY PER MM.
Back to N348SW, cancelled Jul 16, 2012