Registered aircraft · 21

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

N111MLLoyd SPEZIO SPORT TUHOLER · S/N 1Built 1977 · Arcara Sebastiano N147KGKurt Grasso GRASSOCAT · S/N KG1951Built 2017 · Grasso Kurt D N1858XCessna 182H · S/N 18255958Built 1964 · Salem Aero Club Inc N2079RPiper PA-28-180 · S/N 28-5455Built 1969 · Brian K Vittorini N2192TPiper PA-28-180 · S/N 28-7205043Built 1971 · Mazza Frank N25510Balloon Works FIREFLY 8B-15 · S/N F8B-417Blair John C N2697JCessna 150G · S/N 15065697Built 1966 · Salem Aero Club Inc N28004Piper J3C-65 · S/N 4510Built 1940 · Vittorini Brian K N31489Blair John C PATM 56 · S/N 5Built 1982 · Blair John C N34321Meyers OTW-160 · S/N 65Griffin Terry M N356JBAmerican Champion 7GCBC · S/N 1334-2002Built 2002 · Bokash Greg N5356AGalaxy Balloons GALAXY 7 · S/N GLX-1267Built 1987 · Blair John C N6277HPiper J3C-65 · S/N 19453Built 1946 · Jersey Tailwheels LLC N6827GCessna 150L · S/N 15072327Built 1970 · Brooks Jeffrey C N7516HCameron Balloons US O-65 · S/N 5812Built 1992 · Filler Joseph A N77123Cessna 140 · S/N 11581Built 1946 · Cardillo Jeffrey Douglas N889Sharpe SA-1 · S/N 1Built 1957 · Grasso Kurt D N8923HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1567Built 1975 · Grasso Kurt D N8958HGrumman Acft ENG Cor-Schweizer G-164A · S/N 1593Built 1975 · Shoemaker Joseph C Jr N9040VTitan TORNADO II · S/N D99912SOHK0348Built 1999 · Glessner Leslie O N9513TCameron Balloons US O-84 · S/N 5597Built 1990 · Blair Delbert R

Back to Bridgeton, NJ