Jacksonville, AR
Registered aircraft · 16
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'AR' AND g.registrant_city = 'JACKSONVILLE' ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_state = 'AR' AND g.registrant_city = 'JACKSONVILLE' ORDER BY g.n_number
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.
N1511HHylio AG 230 · S/N 17906100228N2158PBoeing N2S-3 · S/N 75-6861N2384EAeronca 7AC · S/N 7AC-5963N339PGCosentino Garey A PEGASUS · S/N A-339-PEGN3642MPiper PA-12 · S/N 12-2497N368GRBell 47G-2 · S/N 1258N48709Aeronca 0-58B · S/N 0-58B-7672N63047Cessna 150M · S/N 15077061N6654SCessna 150H · S/N 15067454N7122JPiper PA-32-260 · S/N 32-7300032N7159GCessna 172K · S/N 17258859N7188FCessna 150F · S/N 15063788N758HACessna R172K · S/N R1723098Registration pendingN78182Cessna 172K · S/N 17257515N9050KPiper PA-28R-201T · S/N 28R-7803060N927HRKraynak Megan N RV-10 · S/N 41838
Back to Jacksonville, AR