N528SW, cancelled Mar 27, 2018
Service difficulty reports · 353
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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 = 'N528SW' AND deregistration_id = 'N528SW-2018-03-27' 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 SWAA970544Floorbeam · damageDURING SCHEDULED D-CHECK, FOUND FLOORBEAM DAMAGED AT BS 312, AT LBL 18 TO 45. REPAIRED PER BOEING SRM.SDR SWAA970543Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORROSION AT BS 947, AT LBL 5, WL 208. REPAIRED PER BOEING SRM.SDR SWAA961447Battery · dischargedDURING WALKAROUND INSPECTION, FOUND FWD RIGHT FLASHLIGHT NOT TESTING. REPLACED BATTERY PER BOEING M/M.
Back to N528SW, cancelled Mar 27, 2018