Registered aircraft · 22

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 = 'CT' AND g.registrant_city = 'NORWALK' 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 = 'CT' AND g.registrant_city = 'NORWALK'
  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 = 'CT' AND g.registrant_city = 'NORWALK'
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.

N129DPaqua David ACRO SPORT II · S/N 1858Built 2008 · Paqua David N252VLMooney M20K · S/N 25-1130Built 1987 · Jagerfly Ltd N29365Waco UPF-7 · S/N 5392Wiemer Karl J N314LTPiper PA-28RT-201 · S/N 28R-7918115Built 1979 · Jacobelli Raphael P N3246UCessna 182F · S/N 18254646Built 1963 · Gregory Group LLC N4131LPiper PA-32R-301T · S/N 3257068Registration pendingBuilt 1998 N416GPLearjet 60 · S/N 416Mpc Equipment LLC N444RRPiper PA46-500TP · S/N 4697278Built 2006 · Access Yacht Sales Inc N477RPiper PA32-301FT · S/N 3232006Built 2003 · Radtke Jeffrey A N5050XBeech C35 · S/N D-3150Built 1952 · Grevatt Douglas E N5066RCessna 172M · S/N 17263304Built 1974 · Burke William M N523LTDiamond Aircraft Ind DA 40 · S/N 40.856Lima Tango LLC N55VCGates Learjet 55B · S/N 130Built 1986 · R.T. Vanderbilt Holding Company Inc N5908ECessna 150 · S/N 17408Built 1959 · Encarnacion Rosario Joel Alberto N61DEPiper PA-32-300 · S/N 32-7940030Built 1979 · Bergabo Bjorn E N65621Waco UPF-7 · S/N 5576Wiemer Karl J N7305JPiper PA-28-140 · S/N 28-24636Built 1968 · Mallozzi Anthony M N7341JPiper PA-28-140 · S/N 28-24696Built 1968 · Ricciardi John A N7556VCessna 177RG · S/N 177RG0852Built 1976 · Wennerstrom Kirk N813RECessna 560 · S/N 560-0799Built 2008 · Richmond 135 LLC N8525PPiper PA-24-400 · S/N 26-105Built 1965 · Thorstenson Joseph N9121HCessna 172M · S/N 17265955Built 1975 · Twenty-One Flyers Inc

Back to Norwalk, CT