Augusta, KS
Cancelled registrations · 218
Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'KS' AND d.registrant_city = 'AUGUSTA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"
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 d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code WHERE d.registrant_state = 'KS' AND d.registrant_city = 'AUGUSTA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
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.
N4362ABeech B-55 · S/N TC-1333N4667ABeech V35B · S/N D-9132N3310XCessna 310L · S/N 310L0160N3680ABeech 95-B55 (T42A) · S/N TC-1334N4085QCessna 402 · S/N 402-0185N4271ABeech A36 · S/N E-208N4089ABeech 70 · S/N LB-29N4187ABeech V35B · S/N D-9122N4055ABeech E-55 · S/N TE-788N4090ABeech 95-B55 · S/N TC-1323N4094ABeech E-55 · S/N TE-791N4160ABeech A36 · S/N E-205N2414ABeech 95-B55 (T42A) · S/N TC-1316N3529ABeech B-55 · S/N TC-1317N4049ABeech A36 · S/N E-197N4054ABeech V35B · S/N D-9100N4087ABeech V35B · S/N D-9105N4058ABeech 58 · S/N TH-10N4154ABeech V35A · S/N D-9113N8861Dehavilland DHC-6 TWIN OTTER · S/N 277N4067ABeech A36 · S/N E-198N3469ABeech V35B · S/N D-9074N3946ABeech V35B · S/N D-9085N3953ABeech A36 · S/N E-192N3507ABeech 95-B55 (T42A) · S/N TC-1303N3465ABeech E-55 · S/N TE-773N3062ABeech 36 · S/N E-184N2841ABeech 95-B55 · S/N TC-1295N2906ABeech D55 · S/N TE-761N2757ABeech 36 · S/N E-174N925BABeech B90 · S/N LJ-402N3170ABeech 70 · S/N LB-19N3426ABeech 65-B80 · S/N LD424N1082ABeech D55 · S/N TE-751N1439ABeech 36 · S/N E-171N2326ABeech D55 · S/N TE-750N2109ABeech A23-24 · S/N MA-358N8109RBeech D55 · S/N TE-742N1632ABeech V35A · S/N D-9037N2290ABeech D55 · S/N TE-749N2627ABeech V35A · S/N D-9043N1448ABeech D55 · S/N TE-737N8003RBeech D55 · S/N TE-728N7992RBeech 36 · S/N E-168N8098RBeech 36 · S/N E-169N1223ABeech D55 · S/N TE-734N8114RBeech V35A · S/N D-9025N1134ABeech V35A · S/N D-9005N7984RBeech D55 · S/N TE-713N7988RBeech 95-B55 (T42A) · S/N TC-1239
Back to Augusta, KS