Registered aircraft · 18

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 = 'MO' AND g.registrant_city = 'ROCK PORT' 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 = 'MO' AND g.registrant_city = 'ROCK PORT'
  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 = 'MO' AND g.registrant_city = 'ROCK PORT'
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.

N1476SCessna 182P · S/N 18265023Built 1976 · Bk1 Farms LLC N1802MAir Tractor AT-802A · S/N 802A-0678Built 2016 · Meyerkorth Aviation LLC N182EQCessna 182M · S/N 18259646Built 1969 · Athen Daniel R N20700Air Tractor AT-802A · S/N 802A-0486Built 2012 · Meyerkorth Aviation LLC N2132JPiper PA-28-181 · S/N 28-7990216Built 1978 · Holley William M N3450FCessna 182J · S/N 18257450Built 1966 · Peeler Max H N50JMBeech V35B · S/N D-10141Built 1978 · Minter Michael D Jr Trustee N510XPAir Tractor AT-502A · S/N 502A-3128Built 2018 · Meyerkorth Aviation LLC N518LDPowrachute PEGASUS · S/N A278PEGBuilt 2004 · Rech Daniel L N5836JCessna A185E · S/N 18501805Built 1970 · Meyerkorth Aviation LLC N587DLDJI AGRAS T50 · S/N 1581F6BUB235V001009965l Precision Spraying LLC N715YFlight Design CTSW · S/N 06-07-10Built 2006 · Garst Charlee Miles N720TBeech V35B · S/N D-9813Built 1975 · Minter Michael D Jr N802EMAir Tractor AT-802 · S/N 802-0784Built 2019 · Meyerkorth Aviation LLC N8486WPiper PA-28-180 · S/N 28-2730Built 1965 · Burke Richard A N88287Bellanca 8GCBC · S/N 103-74Built 1974 · Meyerkorth Aviation LLC N89435Cessna 140 · S/N 8467Built 1946 · Lucas Caleb D N8955LEavision EA-J150 · S/N JMZJK150UAV6025952025l Precision Spraying LLC

Back to Rock Port, MO