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 = 'NJ' AND g.registrant_city = 'WILLIAMSTOWN' 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 = 'NJ' AND g.registrant_city = 'WILLIAMSTOWN'
  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 = 'NJ' AND g.registrant_city = 'WILLIAMSTOWN'
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.

N135CKCessna 208B · S/N 208B0776Built 1999 · Stellar Aviation LLC N1536YCessna 172C · S/N 17249236Built 1962 · Ck Aviation LLC N1721FCessna 172H · S/N 17255116Built 1966 · Centerline Flying Club Inc N1965SBeech S35 · S/N D-7653Built 1964 · N1965s LLC N2741UCessna 172D · S/N 17250341Built 1963 · Nickel Aviation LLC N336PPiper PA-31T · S/N 31T-7400003Built 1974 · N336p LLC N34019Cessna 177B · S/N 17701599Built 1970 · Kortum Ronald L N4992DCessna 182A · S/N 51092Built 1958 · Skydive Cross Keys LLC N555KMBeech V35 · S/N D-8361Built 1966 · Verrill Christopher R N5653WPiper PA-28-150 · S/N 28-840Built 1962 · Crump William J N5785GCessna 150K · S/N 15071285Built 1969 · Brown Colin M N6109HPiper J3C-65 · S/N 19269Built 1946 · Skydive Cross Keys LLC N6814HCessna 172M · S/N 17265594Built 1975 · Uniform Gulf Aviation LLC N76112Cessna 140 · S/N 10509Built 1946 · Fanslau Nathaniel R N780SAvions Mudry ET Cie CAP 10B · S/N 87Built 1978 · N780s LLC N8051NPiper PA-28-140 · S/N 28-25298Built 1969 · Sapienza Gregory T N910KFEwing G/Boyer J SERIES 5 · S/N S9604-0173Built 1997 · Kortum Ronald L N9801CNorth American SNJ-5 · S/N 90-669Built 1943 · Mazure John T

Back to Williamstown, NJ