N307SW, cancelled Jul 26, 2012
Service difficulty reports · 471
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 = 'N307SW' AND deregistration_id = 'N307SW-2012-07-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 = 'N307SW' AND deregistration_id = 'N307SW-2012-07-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 SWAA981941Intercostal · corrodedDURING SCHEDULED 1/2 D-CHECK, FOUND CORRODED INTERCOSTAL CLIP NUT HOLES AT BS 950, RBL 40. REPAIRED PER BOEING SRM.SDR SWAA981940Skin · gougedDURING SCHEDULED 1/2 D-CHECK, FOUND SKIN PLATE I/B OF RT HORIZ STAB GOUGED/WORN. REMOVED AND REPLACED PER BOEING SRM.\N\N\N\N\N\N\N\N\N\N\N\N\N\N\NREPAIRED PER BOEING SRM.SDR SWAA981939Skin · gougedDURING SCHEDULED 1/2 D-CHECK, FOUND SKIN PLATE I/B OF LT HORIZ STAB GOUGED/WORN. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981792Stringer · crackedDURING SCHEDULED D-CHECK, FOUND CRACKED STRINGER CLIP AT BS 380, STR 22L, WL 170. REPAIRED PER BOEING SRM.SDR SWAA981791Angle · crackedDURING SCHEDULED D-CHECK, FOUND L-ANGLE CRACKED AT BS 300.9 WL 257 LBL 53. REPAIRED PER BOEING SRM.SDR SWAA981790Intercostal · crackedDURING SCHEDULED D-CHECK, FOUND WEB INTERCOSTAL CRACKED AT BS 294, WL 216, LBL 57. REPAIRED PER BOEING SRM.SDR SWAA981789Skin · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN CRACKED AT FWD SERVICE DOORWAY AFT LOWER SKIN CUTOUT AT BS 327, WL 210. REPAIRED PER BOEING SRM.SDR SWAA980369Skin · crackedDURING SCHEDULED C2 CHECK, FOUND CRACK ON L/E SKIN AT KRUEGER FLAP SEAL DOOR CUTOUT. REPAIRED PER SWA RA 1-357-0538.SDR SWAA980368Slide · out of dateDURING SCHEDULED C2 CHECK, FOUND L-2 EMERGENCY EVACUATION SLIDE OUT OF DATE. REMOVED AND REPLACED PER BOEING MM.SDR SWAA980106Skin · crackedDURING SCHEDULED TERM CHECK, FOUND 6 IN FUSE SKIN CRACK RT SIDE ABOVE AND AFT OF NR 12 CABIN WINDOW. REPAIRED PER BOEING SRM.SDR SWAA980105Skin · crackedDURING SCHEDULED TERM CHECK, FOUND 1.5 CRACK IN FUSELAGE EXTERIOR SKIN BS 943 STR 24L. REPAIRED PER BOEING SRM.SDR SWAA971062Skin · crackedDURING SCHEDULED C1 CHECK, FOUND RIGHT AFT SERVICE DOOR FRAME LOWER HINGE CUTOUT CRACKED FROM RADIUS UNDER EXISTING DOUBLER. REPAIRED PER BOEING SRM.SDR SWAA971053Skin · crackedDURING SCHEDULED C1 CHECK, FOUND RIGHT AFT SERVICE DOOR FRAME LOWER HINGE CUTOUT CRACKED FROM RADIUS UNDER EXISTING DOUBLER. REPAIRED PER BOEING SRM.SDR SWAA970959Switch · inoperativeDURING SCHEDULED RON CHECK, FOUND E TRACK LIGHTS INOP. REPLACED OVERHEAD SWITCH IN COCKPIT PER BOEING M/M.SDR SWAA970395Start Valve · malfunctionedAT FL330, NR 2 ENGINE START VALVE OPEN LIGHT ILLUMINATED, UNABLE TO MAINTAIN CABIN PRESSURE. DESCENDED TO 8,000 FT, START VALVE LIGHT EXTINGUISHED. ON ANOTHER ATTEMPT TO USE NR 2 BLEED AT FL 290, SAME SCENARIO OCCURED. DESCENDED TO FL 250, ALL OPERATED OK FSDR SWAA970099Floorbeam · crackedDURING SCHEDULED C1 CHECK, FOUND FLOORBEAM STRAP CRACKED IN RIGHT FWD E AND E BAY COMPARTMENT. REPAIRED PER SWA RA 1-353-1136.SDR SWAA961254Controller · failedRETURNED DUE TO RT WING/BODY OVERHEAT ILLUMINATING. AFTER ISOLATING SYSTEM, AIRCRAFT WOULD NOT HOLD PRESSURIZATION. REMOVED AND REPLACED PRESSURE CONTROLLER AND CONTROL PANEL PER BOEING M/M.SDR SWAA961184Strap · crackedDURING SCHEDULED C4 CHECK, FOUND FLOORBEAM STRAP UNDERNEATH FWD ENTRY DOOR CRACKED. REPAIRED PER BOEING SRM.SDR SWAA961183Light · inoperativeDURING SCHEDULED C4 CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING AT ROW 3DEF INOP. REPLACED LIGHT ASSEMBLY PER BOEING M/M.SDR SWAA960434Splice · looseIN FLIGHT, RED NOSE GEAR LIGHT ILLUMINATED, NO AIR NOISE NOTED. CYCLED GEAR HANDLE, NO HELP. ON GEAR EXTENSION HAD ALL GREEN INDICATION. INSPECTED AND FOUND A WIRE PULLED FROM SPLICE IN NOSE W/W. REPAIRED PER BOEING M/M.SDR SWAA950319Eel Battery · dischargedDURING SCHEDULED SERVICE CHECK, FOUND FWD ENTRYWAY EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY PACK AND HOUSING PER BOEING M/M.
Back to N307SW, cancelled Jul 26, 2012