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

N118BRDJI MAVIC AIR 2S · S/N 3YTBK41003005UReyna William L Jr N120HACessna 340A · S/N 340A0295Built 1977 · Astley Mark C N126DBSchweizer SGS 1-26E · S/N 516Built 1971 · Black-Nixon C Dianne N12801Cessna 172M · S/N 17262271Built 1973 · Cone Ted N128UHSchleicher ASW-28 · S/N 28010Built 2000 · Nixon Henry N163HLPiper PA-46-600TP · S/N 4698163Built 2021 · Skywood Aviation LLC N226SMCessna 182T · S/N 18281153Sarahmaura Aviation Inc N24WRSchleicher ASW-24E · S/N 24861Nixon Henry M N271DWChristen Industries PITTS S-2B · S/N 5136Built 1988 · Bundock David N293QVAlexander Schleicher ASW 27-18 E · S/N 29750Built 2018 · Nixon Henry M N338BRDJI PHANTOM 3 PROFESSION · S/N P76DCG3 1011407Noseprint Pet Furtography LLC DBA N3650Glasflugel STD LIBELLE 201B · S/N 166Built 1970 · Nixon Henry M N426CBEclipse Aerospace EA500 · S/N 550-1013Built 2017 · Echo Alpha Inc N543FLPiper PA-28-140 · S/N 28-7125376Built 1971 · Morpac Aviation Inc N63761Rolladen-Schneider OHG LS3-A · S/N 3286Nixon Henry M N6888HCessna 172M · S/N 17265628N6888h LLC N7067DPiper PA-18A 150 · S/N 18-5607Built 1957 · Black C Dianne N820BRRaytheon A36 · S/N E-3011Built 1996 · Skywood Aviation LLC N8544CPiper PA-22-135 · S/N 22-1256Built 1953 · Nixon H M N888NADassault FALCON 2000 · S/N 77Built 1999 · Ideavillage Products Corp N91894Schweizer SGS 1-26 · S/N 2Built 1954 · Nixon H M N9227TPiper PA-28-236 · S/N 28-8511020Built 1985 · Gpa Aviation Club Inc N9691JPiper PA-28-180 · S/N 28-3880Built 1967 · Saporito Erik

Back to Wayne, NJ