N661SW, cancelled Jul 20, 2012
Service difficulty reports · 408
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 = 'N661SW' AND deregistration_id = 'N661SW-2012-07-20' 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 = 'N661SW' AND deregistration_id = 'N661SW-2012-07-20' 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 SWAA981932Bracket · brokenDURING SCHEDULED TRAN CHECK, FOUND (AFT CARGO BAY) SUPPORT BRACE BRACKETS BROKEN AT BS 727, LBL 1 AND RBL 2 (2) PLACES, WL 163. 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 SWAA981919Floorbeam · damagedDURING SCHEDULED TRAN CHECK, FOUND FRAME TO FLOORBEAM SUPPORT DAMAGED FASTENER AT BS 616, RBL 64.5, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981918Floorbeam · damagedDURING SCHEDULED TRAN CHECK, FOUND FRAME TO FLOORBEAM SUPPORT DAMAGED FASTENER AT BS 616, LBL 64.5, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981917Support · corrodedDURING SCHEDULED TRAN CHECK, FOUND CORRODED FLOOR SUPPORT AT BS 308, RBL 11, WL 208. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA981916Bulkhead · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED 178 BULKHEAD, RBL 6-7, WL 199. REPAIRED PER BOEING SRM.SDR SWAA981915Frame · misdrilledDURING SCHEDULED TRAN CHECK, FOUND FRAME WITH EIGHT HOLES AT BS 1006 WL 300, RBL 5. REPAIRED PER BOEING SRM.SDR SWAA981914Bulkhead · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED AT BS 178 BULKHEAD, LBL 4, WL 199-202. REPAIRED PER BOEING SRM.SDR SWAA981890Bulkhead · crackedDURING SCHEDULED TRAN CHECK, FOUND CRACKED BS 178 BULKHEAD, RBL 4, WL 199-202. REPAIRED PER BOEING SRM.
Back to N661SW, cancelled Jul 20, 2012