Registered aircraft · 23

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'LA' AND g.registrant_city = 'OAK GROVE' ORDER BY g.n_number

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 = 'LA' AND g.registrant_city = 'OAK GROVE'
  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 = 'LA' AND g.registrant_city = 'OAK GROVE'
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.

N22KVPiper PA-38-112 · S/N 38-79A0046Built 1978 · Clack Justin N2401LCessna 172H · S/N 17255601Delta Ridge Farms LLC N2538GChampion 7ECA · S/N 411Built 1967 · Ferrell Herman H N3227WDJI AGRAS T50 · S/N 1581F6BUB243P0018TWVWomack Zachary N32989Piper J5A · S/N 5-412Wiggins Cory L N4546WDJI AGRAS T50 · S/N 1581F6BUB248T001D967Womack Zackary N462ACessna 140A · S/N 15283Delta Ridge Farms LLC N5029SPiper PA-28R-200 · S/N 28R-35775Built 1970 · Chop Bert D N50DTBellanca 8GCBC · S/N 167-75Built 1975 · Harrell Ag Aviation LLC N5416CCessna 170A · S/N 19450Built 1950 · Harper Jason Prentis N5475DBeech H35 · S/N D-4994Delta Ridge Farms LLC N548RLDJI AGRAS T100 · S/N 1581F8ZLC25AV0023N7ZRoss Jacob M N559RLDJI AGRAS T100 · S/N 1581F8ZLC25B6002CFQJRoss Jacob M N6801GCessna 150L · S/N 15072301Delta Ridge Farms LLC N76171Cessna 140 · S/N 10568Delta Ridge Farms LLC N76885Cessna 140 · S/N 11319Delta Ridge Farms LLC N77424Cessna 120 · S/N 11865Delta Ridge Farms LLC N821DCCarley Dennis S ZENIAR ZODIAC · S/N 6-3227Built 1998 · Ables Rickey D N8329KUniversal Stinson 108-1 · S/N 108-1329Built 1946 · Ferrell Herman H N915LFAmerican Champion 8GCBC · S/N 390-98Built 1998 · Lingo Joshua B N9431ACessna 140A · S/N 15252Built 1949 · Delta Ridge Farms LLC N962RSHarjer Darryl J TEAM ROCKET F1 · S/N 094Built 2017 · Paris Casey N97572Stinson 108 · S/N 108-572Ferrell Herman H

Back to Oak Grove, LA