Registered aircraft · 17

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

N1068SAnglin Special Aero Planes J-3 KITTEN · S/N 003Built 1984 · Andrezej Sitarz N122JPPiper AEROSTAR 601P · S/N 61P-0535227Built 1978 · Zatika Francis N125TBBalazs Thomas BALAZS ZENAIR ZODIAC · S/N 63824Sitarz Andrezej N151PCAmerican Champion 8KCAB · S/N 884-2001Built 2001 · Wear Thomas M N211LFFlesner Larry Gene KR-2 MODIFIED · S/N 5850-57Martine Zachary N223GLBellanca 7KCAB · S/N 337-73Built 1973 · Kushner Herbert A N27234Prince Gorden E ZENAIR CRICKET MC-12 · S/N MC-12-0119Built 1983 · Velednitsky Boris N28739Grumman American Avn. AA-5B · S/N AA5B0785Built 1978 · Velednitsky Boris N33MKBeech F33A · S/N CE1478Built 1990 · Fessele Martin N388RVAve Stephen RV8 · S/N 80787Built 2000 · Glasbrenner Lutz N4701LPiper PA-28-180 · S/N 28-4014Trainor Jonathan P N5655RMaule M-5-180C · S/N 8049CBuilt 1984 · Kavalieros James A N58490Intermountain Flying Club RV-4 · S/N 1094Built 1997 · Kushner Herbert A N6586PPiper PA-24 · S/N 24-1708Ingram James D N68575Bellanca 7ECA · S/N 879-72Built 1972 · Kushner Herbert A N70861Cessna 182M · S/N 18259397Built 1968 · Importico William J N91016Cessna T207 · S/N 20700011Built 1969 · Gosselin Edward M Trustee

Back to Bridgewater, NJ