Conway, AR
Cancelled registrations · 51
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 = 'AR' AND d.registrant_city = 'CONWAY' 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 = 'AR' AND d.registrant_city = 'CONWAY' 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.
N990JADassault FALCON 900B · S/N 147N43637Taylorcraft BC12-D · S/N 7296N52722Beech C18S · S/N 7779N53APBeech C-45H · S/N 51-11600N528HCChallenger CHALLENGER I C/W · S/N CHCW 0692-155N232FCBell OH-58C · S/N 71-20627N230FCBell OH-58C · S/N 68-16688N3646DAerostar International RX 8 · S/N RX8-3062N153GFBell OH-58C · S/N 70-15055N4158VCessna 170 · S/N 18490N6570Grumman G-164A · S/N 710N308RHBeech 200 · S/N BB-109N6264Weaver BOWERS FLY-BABY · S/N 728N2607CPiper PA-38-112 · S/N 38-79A0257N3597RBeech A23 · S/N M-778N930SAFlight Design CTLS · S/N 08-02-05N25211Cessna 152 · S/N 15280530N3761QRyan Aeronautical ST3KR · S/N 1404N5227ACessna 310 · S/N 35427N2780PPiper PA-18A 150 · S/N 18-4414N2598JCessna 150E · S/N 15061098N37662Mcguire VOLKSPLANE · S/N 53439AN6477KCessna 150M · S/N 15077720N733SJCessna 172N · S/N 17268510N50913Ferguson John W FERGUSON HAWK · S/N 001N61745Cessna 172M · S/N 17264770N6818TCessna 310D · S/N 39118N8339KPiper PA-28RT-201T · S/N 28R-8131079N3968PPiper PA-22-150 · S/N 22-3648N3784APiper PA-22-135 · S/N 22-2026N7395QCessna 182P · S/N 18261035N7423UBalloon Works FIREFLY 7 · S/N F7356N540KBBlalock M K PITTS SIK · S/N 70384KN617DBeech C35 · S/N D2875N92RLLegate Ralph N LEGATE STITS SKYCOUP · S/N 33026RLN575HCBeech E-90 · S/N LW67N222GMPiper PA-30 · S/N 30-985N9357CCessna 180 · S/N 31755N6182CNorth American T-28A · S/N 50-295N9409ZBeech C-45H · S/N 52-10860N3661EAeronca 7AC · S/N 7AC-6976N523BBeech 35 · S/N D1494N1884NCessna 120 · S/N 12128N9987Travel Air L-4000 · S/N 1163N75036Cessna AT-17 · S/N 4293N77107Cessna 140 · S/N 11565N25010Piper J3L · S/N 3596N13921Fleet 9 · S/N 506N9944Curtiss Wright TRAVEL AIR 4000 · S/N 1128N25362Luscombe 8A · S/N 1238
Back to Conway, AR