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 SWAA063607Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063606Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063605Beltframe · crackedDURING SCHEDULED 18Y CHECK, FOUND BELT FRAME CRACKED AT BS 420, STR 13L. REPAIRED BELT FRAME PER SWA EA.SDR SWAA063575Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063574Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, STR 8L. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA063561Pressure Panel · crackedDURING SCHEDULED 18Y CHECK, FOUND BEADED PRESSURE WEB CRACKED AT BS 664, RBL 40. REPAIRED PRESSURE WEB PER SRM.SDR SWAA063534Beltframe · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 380, STR 13L. REPAIRED BELTFRAME IAW SWA EA.SDR SWAA063533Bracket · looseDURING SCHEDULED 18Y CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE FWD GIRT BAR BRACKET LOOSE. REMOVED AND REPLACED GIRT BAR BRACKET FASTENERS IAW SRM.SDR SWAA063532Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME SECTION IAW SWA EA.SDR SWAA063531Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 8R. REPAIRED FRAME SECTION IAW SWA EA.SDR SWAA063530Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME SECTION IAW SWA EA.SDR SWAA063529Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME SECTION IAW SWA EA.SDR SWAA063528Skin · crackedDURING SCHEDULED 18Y CHECK, FOUND LT WING NR 2 L/E SLAT LOWER SURFACE CRACKED AT OB AUX TRACK LOCATION. REPAIRED SLAT IAW SRM.SDR SWAA063493Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FUSELAGE BELTFRAME CRACKED AT BS 360, STR 16L. REPAIRED BELTFRAME PER SWA EA.SDR SWAA063379Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 907 TO BS 927, STR 17L. REPAIRED CREASE BEAM WEB PER SRM.SDR SWAA063378Crease Beam · corrodedDURING SCHEDULED 18Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 727B TO BS 727C, STR 17L. REPAIRED CREASE BEAM WEB PER SWA EA.SDR SWAA063377Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063376Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063375Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 10L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063374Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 11L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063373Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 294.5, STR 13L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063372Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 14L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063357Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 360, STR 5L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063356Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 10R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063355Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15R. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA063354Stringer Clip · crackedDURING SCHEDULED 18Y CHECK, FOUND STRINGER CLIP CRACKED AT BS 277, STR 15L. REMOVED AND REPLACED STRINGER CLIP PER SRM.SDR SWAA061906Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 420, BL 0. REPAIRED SKIN PER SWA EA.SDR SWAA061905Frame · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE FRAME CRACKED AT AFT CARGO DOOR CUTOUT FWD FRAME, UPPER STOP FITTING. REPAIRED FRAME SECTION PER SWA EA.SDR SWAA061904Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR FRAME, LOWER HINGE CUTOUT. REPAIRED SKIN PER EA AND SRM.SDR SWAA061903Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACKED AT AFT ENTRY DOOR FRAME, UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR SWAA060718Battery Pack · no testDURING SCHEDULED A1 CHECK, MID CABIN EMERGENCY BULLNOSE EXIT LIGHTS BATTERY PACK FAILED TEST. REMOVED AND REPLACED BATTERY PACK PER MM.SDR SWAA054021Sign · brokenLT CABIN EMERGENCY EXIT SIGN BROKEN. REMOVED AND REPLACED EXIT SIGN PER MM.SDR SWAA053885Slide · low pressureR2 DOOR EMERGENCY EVAC SLIDE PRESSURE INDICATED OUT OF LIMITS. REMOVED AND REPLACED SLIDE PER MM.SDR SWAA053427Skin · corrodedDURING SCHEDULED C4 CHECK, FOUND FUSELAGE SKIN CORRODED AT BS 986.5, BL 0. REPAIRED SKIN PER SRM.SDR SWAA053165Bulb · inoperativeDURING SCHEDULED SERVICE CHECK, FOUND EMERGENCY EXIT LIGHT INOP AT ROW 13. RELAMPED LIGHT PER MM.SDR SWAA051676Actuator · faultyUPON NORMAL GEAR EXTENSION, RT MAIN GEAR DID NOT INDICATE EXTENDED, RED LIGHT ILLUMINATED. MANUALLY EXTENDED RT MAIN GEAR, NORMAL INDICATIONS, GREEN LIGHT ILLUMINATED. REMOVED AND REPLACED UPLOCK ACTUATOR PER MM.SDR SWAA051523Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE BULKHEAD WEB CRACKED AT BS 178, LBL 25, WL 207. REPAIRED WEB PER SRM.SDR SWAA051522Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND 2 EA FUSELAGE FLOOR WEB CRACKS BETWEEN BS 188 TO BS 196, LBL 30 & RBL 30, WL 208. REPAIRED WEB SECTIONS PER SRM.SDR SWAA051502Bulkhead · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE BULKHEAD WEB CRACKED AT BS 178, LBL 25, WL 207. REPAIRED WEB PER SRM.SDR SWAA051501Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FLOOR WEB CRACKED AT BS 188 TO BS 196, LBL 30, WL 208. REPAIRED WEB PER SRM.SDR SWAA051500Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, LT SIDE, WL 208. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA051458Shear Tie · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE SHEAR TIE CRACKED AT BS 178 BLKHD, RBL 31, WL 208. REMOVED AND REPLACED SHEAR TIE PER SRM.SDR SWAA051423Web · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FLOOR WEB CRACKED AT BS 188 TO BS 196, RBL 30, WL 208. REPAIRED WEB PER SRM.SDR SWAA051406Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RT SIDE, WL 208. REMOVED AND REPLACED STUB FRAME PER SRM.SDR SWAA050675Skin · crackedDURING SCHEDULED C2 CHECK, FOUND FUSELAGE SKIN CRACK AT BS 500D, STR 10R. REPAIRED SKIN PER SWA EA.SDR SWAA050673Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND R1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED R1 DOOR SLIDE PER MM.SDR SWAA050668Keelbeam · corrodedDURING SCHEDULED C2 CHECK, FOUND CORROSION ON KEELBEAM, LT SIDE, BS 500D. REPAIRED KEEL BEAM PER SWA EA.SDR SWAA050674Slide · out of adjustDURING SCHEDULED C2 CHECK, FOUND L1 DOOR EMERGENCY EVAC SLIDE OUT OF ADJUST. ADJUSTED L1 DOOR SLIDE PER MM.SDR SWAA050327Light · crackedDURING SCHEDULED A2 CHECK, FOUND EMERGENCY EXIT LIGHT HOUSING AT ROW 1 DEF, CRACKED. REMOVED AND REPLACED LIGHT ASSEMBLY PER MM.SDR SWAA043397Skin · corrodedDURING SCHEDULED C1 CHECK, FOUND CORROSION BULGE AT FUSELAGE SKIN BS 440, STR 22R. REPAIRED SKIN PER SRM.
Back to N348SW, cancelled Jul 16, 2012