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 = 'PA' AND g.registrant_city = 'HANOVER' 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 = 'PA' AND g.registrant_city = 'HANOVER'
  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 = 'PA' AND g.registrant_city = 'HANOVER'
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.

N100MHDehavilland TIGER MOTH DH 82A · S/N A17-122Owen Kingsley B N10DLPiper PA46R-350T · S/N 4692073Built 2008 · Moul Daniel P N10FXBert Floyd S PITTS S1S · S/N 10ABuilt 1989 · Fox Christopher K N137DMMooney M20J · S/N 24-0919Built 1979 · Zartman Grant M N22725Piper J4 · S/N 4426Built 1938 · Gebhart Daniel T N23DGAerotek PITTS S-2A · S/N 2061Gebhart Daniel T N29901Waco UPF-7 · S/N 5398Built 1940 · Blue Sky Adventures LLC N3534EPiper J3L-65 · S/N 6309Built 1941 · Fox Christopher K N3934HHorn Frank W III PIONEER 300 · S/N 0077Built 2013 · Horn Frank W III N49301Beech F17D · S/N 250Blue Sky Adventures LLC N526MAAviat A-1B · S/N 2142Built 2001 · Blue Sky Adventures LLC N567YStearman C3-P · S/N 5039Blue Sky Adventures LLC N58554Cessna 182P · S/N 18262137Mocking Bird Aviation LLC N5MBPiper J3C-65 · S/N 20849Built 1946 · Mahler Steven N601GVApplefeld Gerald A ZODIAC CH 601 HD · S/N 6-3216Built 2003 · Applefeld Gerald A N6349Fox WILLIE TWO · S/N 001Built 1980 · Fox Christopher Kirk N659ZQDJI PHANTOM 3 PROFESSION · S/N P76DCH04016742Cistone Alexander S N734XPiper PA-28-180 · S/N 28-7405079Built 1974 · Mahler Steven N789RPCessna 421C · S/N 421C0009Built 1975 · Brindle Concepts LLC N8000Piper PA-30 · S/N 30-682Built 1965 · Burns Christopher G N83217Aeronca 7AC · S/N 7AC-1878Built 1946 · Wtflying Club LLC N8815MBeech S35 · S/N D-7334Built 1964 · Gidusko James Patrick II N8925YPiper PA-39 · S/N 39-81Blue Sky Adventures LLC

Back to Hanover, PA