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

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 = 'IA' AND g.registrant_city = 'MANCHESTER' 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 = 'IA' AND g.registrant_city = 'MANCHESTER'
  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 = 'IA' AND g.registrant_city = 'MANCHESTER'
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.

N1324DDJI AGRAS T40 · S/N 1581F574B22BJ0010671Deutmeyer Rick N157ALEa Vision J-150 · S/N JMZKJ150UAV602596056Deutmeyer Rick A N1793GBeech 35-B33 · S/N CD-515Georgen Auto LLC N265DCDJI AGRAS T50 · S/N 63TBLAW0020004V Bock Pumping II LLC N27449Piper PA-31-325 · S/N 31-7812025Built 1977 · Airchoice LLC N35714Cessna 172I · S/N 17256928Skyhawk Rising LLC N442VAFisher James E VANS ACFT INC RV-14A · S/N 140411Built 2020 · Fisher James E N488RJRaytheon HAWKER 800XP · S/N 258404Built 1999 · Airchoice LLC N489UTEa Vision J100 · S/N EAVUAV502586354Mattice Garrett J N4921JPiper PA-28R-180 · S/N 28R-30642Built 1968 · Herdrich Sean D N5596VRathbun Robert M KOLB MARK II · S/N 001Built 2005 · Necker Brad G N56930DJI AGRAS T50 · S/N 63YBM9L0020096Felton Noah J N584QAHuida Tech HD580 · S/N 212985300C725Moorman Ben D N651MRMaxwell G E/Rezabek J D ZODIAC CH601 XL · S/N 6-5168Built 2005 · Mercer Steven M N7893DPiper PA-22-150 · S/N 22-5516Built 1957 · Moes John E N8185SCessna 150F · S/N 15061785Built 1965 · Janssen Christopher M

Back to Manchester, IA