N305SW, cancelled Sep 1, 2011
Service difficulty reports · 324
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 = 'N305SW' AND deregistration_id = 'N305SW-2011-09-01' 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 = 'N305SW' AND deregistration_id = 'N305SW-2011-09-01' 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 SWAA990814Frame · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FRAME AT BS 1016, WL 192, RT SIDE. REPAIRED FRAME PER EO 99-532P.SDR SWAA990792Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM AROUND FASTENER HOLES AT BS 947, LBL 5-RBL 5. REPAIRED FLOORBEAM PER SRM.SDR SWAA990775Frame · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACKED FRAME AT BS 328 , WL 184. REPAIRED FRAME PER SRM.SDR SWAA990774Frame · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FRAME AT BS 986 , WL 208. REPAIRED FRAME PER SRM.SDR SWAA990771Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 312,LBL 14 - RBL 14, INSIDE CABIN. REPAIRED PER SRM.SDR SWAA990770Skin · crackedDURING SCHEDULED 1/2D CHECK, FOUND KEEL BEAM LOWER SKIN CUT OUT AT BS 717 CRACKED. REPAIRED SKIN PER SRM.SDR SWAA990760Bulkhead · crackedDURING SCHEDULED 1/2D CHECK, FOUND 4 EA CRACKS AT BS 178 BULKHEAD, BETWEEN LBL 10 - RBL 13. REPAIRED CRACKS PER SRM.SDR SWAA990751Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 294.5, LBL 14-RBL 11. REPAIRED BEAM PER SRM.SDR SWAA990750Bracket · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FWD ENTRY GIRT BAR ATTACH BRACKET CORRODED AT FLOOR. REMOVED AND REPLACED BRACKET PER MM.SDR SWAA990679Skin · crackedDURING SCHEDULED SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED 8 INCHES LONG AT BS 500C, STRINGER 3L. REPAIRED PER SRM.SDR SWAA990027Skin · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 745, BETWEEN S19 AND 20L. REPAIRED PER BOEING SRM.SDR SWAA982734Skin · crackedDURING WALKAROUND CHECK, FOUND APPROX 4 INCHES SKIN CRACKED, LEFT SIDE BETWEEN CABIN WINDOWS 11 AND 12. REPAIRED PER BOEING SRM.SDR SWAA981412Web · crackedDURING SCHEDULED CI CHECK, FOUND UPPER WEB CRACKED AT NUT PLATE HOLE RIVET RT AND LT. REPAIRED PER BOEING TI-A53-001.SDR SWAA981411Web · crackedDURING SCHEDULED CI CHECK, FOUND NOSE GEAR ACTUATOR VERTICAL WEB ATTACH CRACKED 2 LONG, 6 IN FROM FWD END. REPAIRED PER BOEING SRM.SDR SWAA981410End Cap · missingDURING SCHEDULED CI CHECK, FOUND EMERGENCY EXIT TRACK LIGHTING FWD END CAP MISSING. INSTALLED MISSING EGRESS LIGHTING END CAP AT FWD END PER BOEING MM.SDR SWAA970952Skin · crackedDURING WALKAROUND CHECK, FOUND A 3 INCH CRACK LT SIDE BETWEEN CABIN WINDOWS 8 AND 9. REPAIRED PER BOEING SRM.SDR SWAA970947Skin · crackedDURING SCHEDULED B/C2 CHECK, FOUND AFT SERVICE DOORWAY HINGE CUTOUT CRACKED IN UPPER AND LOWER RADIUS. REPAIRED PER SWA RA 1-353-1717.SDR SWAA970815Stringer · crackedDURING SCHEDULED SERVICE CHECK, FOUND STRINGER 25R CRACKED AT BS 294.5. REPLACED PER BOEING M/M.SDR SWAA970740Skin · damagedGROUND EQUIPMENT CONTACTED RIGHT SIDE OF AIRCRAFT JUST BEHIND AND ABOVE RIGHT NOSE GEAR DOOR. REPAIRED SKIN PER BOEING SRM.SDR SWAA970694Skin · damageFUSELAGE SKIN DAMAGED BY GROUND EQUIPMENT BELOW AFT CARGO BIN DOOR. TEMP REPAIRED FOR MX FERRY FLIGHT TO TRAMCO AT SEA. REPAIRED PER BOEING SRM.SDR SWAA961332Support · corrodedDURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 727D PLUS 5, WL 156, RBL 6. REPLACED CORRODED SECTION PER BOEING SRM.SDR SWAA960938Skin · gougedDURING SCHEDULED BC1 CHECK, FOUND FUSELAGE SKIN REPAIR DOUBLER BELOW AFT ENTRY DOOR GOUGED AT BS 967. REPLACED PER SWA RA 1-353-1510.SDR SWAA960186Skin · crackedDURING SCHEDULED C3 CHECK, FOUND FWD SERVICE DOOR SKIN CRACKED AT TOP AFT CORNER AT UPPER RIVET. REPAIRED PER BOEING SRM.SDR SWAA950738Relay · malfunctionedEN ROUTE, NUMBER 1 TRANSFER BUSS CIRCUIT BREAKER TRIPPED. RESET BREAKER, BUT TRIPPED AGAIN. CABIN PRESSURE BEGAN TO CLIMB IN AUTO. AIRCRAFT DESCENDED TO 10,000, DIVERTED TO DAL AND MADE AN UNEVENTFUL LANDING. INSPECTED, REPLACED R3 RELAY AND PERFORMED BUSS
Back to N305SW, cancelled Sep 1, 2011