N306SW, cancelled Feb 18, 2011
Service difficulty reports · 313
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 = 'N306SW' AND deregistration_id = 'N306SW-2011-02-18' 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 = 'N306SW' AND deregistration_id = 'N306SW-2011-02-18' 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 SWAA990939Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAMS, BS 312, LBL 6-RBL 8, BS 294, LBL 21-RBL 24, AND BS 328 RBL 14. REPAIRED BEAM PER SRM.SDR SWAA990938Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 294, LBL 7-11. REPAIRED BEAM PER SRM.SDR SWAA990934Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CRACKED AT BS 500, RBL 14. REPAIRED BEAM PER SRM.SDR SWAA990909Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FWD AND AFT GIRT BAR ATTACH BRACKETS AT FWD ENTRY DOOR FLOOR. REMOVED AND REPLACED BRACKET ASSYS PER MM.SDR SWAA990239Bulb · failedDURING SCHEDULED CHECK, FOUND EMERGENCY LIGHT INOP BEHIND CAPT SEAT. RELAMPED AND OPS GOOD PER M/M.SDR SWAA983131Chord · crackedDURING SCHEDULED SC CHECK, FOUND BS 178 T-CHORD CRACKED. REPAIRED PER SWA RA 1-353-1959.SDR SWAA983130Strap · severedDURING SCHEDULED SC CHECK, FOUND SUPPORT STRAP SEVERED AT BS 178. REPAIRED PER BOEING SRM.SDR SWAA983129Web · crackedDURING SCHEDULED SC CHECK, FOUND 2 BEADED PRESSURE WEB CRACKS AT BS 663. REPAIRED PER SWA RA 1-353-1956.SDR SWAA983128Skin · crackedDURING SCHEDULED SC CHECK, FOUND SEVERAL FUSELAGE SKIN CRACK INDICATIONS AT BS 178. REPAIRED PER BOEING SRM.SDR SWAA982499Angle · brokenDURING SCHEDULED SERVICE CHECK, FOUND FWD B/B DOOR UP LATCH SUPPORT ANGLE BROKEN. REMOVED AND REPLACED SUPPORT ANGLE PER BOEING SRM.SDR SWAA971063Skin · crackedDURING SCHEDULED C2 CHECK, FOUND AFT ENTRY DOOR UPPER HINGE CUTOUT CRACKED .350. REPAIRED PER BOEING SRM.SDR SWAA970628Engine · failed testDURING SCHEDULED B/C CHECK, NR 1 ENGINE FAILED BORESCOPE INSPECTION, HPT BLADES OUT OF LIMITS. REPLACED ENGINE, THRUST LINK ASSEMBLY AND PRE-COOLER PER BOEING M/M.SDR SWAA970102Battery · dischargedDURING SCHEDULED TERMINAL CHECK, FOUND FWD CABIN EMERGENCY TRACK LIGHTS INOP. REPLACED BATTERY PACK PER BOEING M/M.
Back to N306SW, cancelled Feb 18, 2011