Registered aircraft · 22

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 = 'MD' AND g.registrant_city = 'CHESTERTOWN' 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 = 'MD' AND g.registrant_city = 'CHESTERTOWN'
  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 = 'MD' AND g.registrant_city = 'CHESTERTOWN'
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.

N107SMTest Spol Sro TST-14M BONUS · S/N 14010906Built 2006 · Dierker Robert R N135BDSchweizer SGS 1-35 · S/N 24Built 1975 · Dierker Robert R N154KKrapf James P KITFOX FOUR · S/N 1569Built 1995 · Jones Robert Douglas N192BDSchweizer SGS 1-26B · S/N 192Built 1963 · Dierker Robert R N220MASocata TBM 700 · S/N 248Registration pendingBuilt 2002 N233BDSchweizer SGS 2-33B · S/N 231Built 1972 · Dierker Robert R N2695DCessna 170B · S/N 20847Ross David N286RDRans Designs S-7LS · S/N 0308500Built 2008 · If Its To Be LLC N3331KGlobe GC-1B · S/N 1324Built 1946 · Wright Wayne M N34343Cessna 177B · S/N 17701772Built 1972 · Wright Wayne M N3811JCessna 150G · S/N 15065111Built 1966 · Wright Wayne M DBA N3853ASchweizer SGS 1-26A · S/N 12Built 1956 · Mellies Thomas N470BDSchweizer SGS 1-26D · S/N 470Built 1970 · Dierker Robert R N48UGTest TST-10 · S/N 10021805Built 2005 · Dierker Robert R N5537Let L-23 SUPER BLANIK · S/N 928003Built 1992 · Wright Wayne M N55SWLohr Frederick T SEAWIND 3000 · S/N 039Lohr Frederick T N5686XAyres S-2R · S/N 2395RBuilt 1977 · Wright Wayne M N626NRPiper PA-39 · S/N 39-82Built 1970 · Jones Robert D N6722SCessna 150H · S/N 15067522Built 1967 · Campbell J Tyler N7797VAyres S-2R · S/N 2452RBuilt 1978 · Wright Wayne M DBA N78403Piper J-3C · S/N 23144Built 1947 · Lohr Frederick T N865CBAeronca 7AC · S/N 7AC-183Built 1945 · Jennings Christopher R

Back to Chestertown, MD