Registered aircraft · 33

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 = 'NEWTON' 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 = 'NEWTON'
  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 = 'NEWTON'
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.

N101DKKrause Richard M SKYBOLT · S/N 1001Tremper John D N1134VAeronca 7AC · S/N 7BCM-444Built 1946 · Johnson Gustav M N11423Mooney M20J · S/N 24-1178Built 1981 · Boland Aviation LLC N11TPPizzuti Thomas M SH2 · S/N 1017Built 1992 · Tienken Henry N N14401Piper PA-23-250 · S/N 27-3722Built 1967 · Berggren Ryan N15616Piper PA-28-180 · S/N 28-7305098Built 1972 · Jpd Aviation LLC N162THThomas L Heaton ROTORWAY EXEC 162F · S/N 6633Built 2012 · Heaton Thomas L N17760DJI AGRAS T40 · S/N 1581F574B226M001009XVirginia Ag Drones LLC N17905Schweizer SGS 1-26E · S/N 528Built 1972 · Johnson Gustar M N1950JJudge Russell M SHARK 600 · S/N 144Built 2023 · Judge Russell M N201JGMooney M20J · S/N 24-0011Built 1976 · Berggren Ryan J N203SJPiper PA-32-300 · S/N 32-40037Corrado Christopher N210WKCessna 210 · S/N 57088Built 1960 · Corrado Christopher N2794XRaven Industries RALLY RX7 · S/N RX7-407Hunziker Edward A N3672UCessna 182G · S/N 18255072Built 1963 · D W Clark LLC N3852ASchweizer SGS 1-26A · S/N 8Built 1953 · Johnson Gustav M N397MWCessna T182T · S/N T18208397Built 2005 · Mccann Shawn Edward N4479LCessna 172G · S/N 17254574Built 1966 · Gravenstede Nelson F N5281GCessna 305A · S/N 22618Built 1951 · Gravenstede Nelson F N5671LAmerican AA-1 · S/N AA1-0071Built 1969 · Judge Russell M N5721LAmerican AA-1 · S/N AA1-0121Built 1969 · Berggren Ryan J N5914MCessna 310P · S/N 310P0214Built 1969 · Bogie Aviation LLC N6170YPiper PA-23-250 · S/N 27-3391Built 1966 · Ge Org Advanced Systems LLC N67BMGlobe GC-1B · S/N 1251Oswin William R Jr N680USchweizer SGS 1-26B · S/N 302Built 1965 · Johnson Gustav M N71287Cessna 182M · S/N 18259563Built 1969 · Bogie Aviation LLC N7386GCessna 172K · S/N 17259086Built 1970 · Crosswind Flyers Inc N76235Piper PA-28-235 · S/N 28-7610138Kirby Coray S N8528KPiper J3C-65 · S/N 19375Tremper John D N8605NPiper PA-28-140 · S/N 28-7125429Built 1971 · Tremper John D N9391XCessna 182E · S/N 18253791Built 1962 · Gravenstede Nelson F N95296Taylorcraft BC12-D · S/N 9696Built 1946 · Gravenstede Nelson F N98729Piper J3C-65S · S/N 18957Aviation Consultants Inc

Back to Newton, NJ