Registered aircraft · 19

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

N1041XPiper PA-28-180 · S/N 28-7505199Built 1975 · Gyllensten Scott N11528Cessna 150L · S/N 15075490Built 1973 · Streeter Derek N144DJRobinson Helicopter R44 · S/N 2467Built 2017 · Saybrook Offshore LLC N19GJPiper PA-28-180 · S/N 28-7405020Built 1973 · Jmd Aviation LLC N210SQBradley Roderick W MURPHY RENEGADE · S/N REN 575Built 1995 · Bradley Roderick W N320DRLancair LC42-550FG · S/N 42064Built 2005 · Montgomery Machine LLC N411GJBeech A36 · S/N E-2586Built 1990 · Guardian Jet LLC N4437HMooney M20J · S/N 24-0732Sander Elliot G N529JNLawrence W Nelson HALCYON54K · S/N 2011-54K-1Built 2011 · Nelson Lawrence W N711BGCessna P210N · S/N P21000806Built 1982 · Saybrook Offshore LLC N7694VCessna 177RG · S/N 177RG0904Built 1976 · Markowski John J N790XTMark George Tower MONI · S/N 00127Tower Mark G N8308VPiper PA-32R-301T · S/N 32R-8129016Built 1980 · Cleary Paul D N84KGMaule M-5-180C · S/N 8047CGinz Peter M N9084NPiper PA-28-181 · S/N 2890164Rose John K N90YCDassault FALCON 900EX · S/N 250Built 2010 · American Cruise Lines Inc N933XAndrews Richard S III RV6-A · S/N 60515Built 2005 · Andrews Richard S III N95967Cessna 182Q · S/N 18266693Built 1978 · Hadley Nicholas J N9841GCessna 172L · S/N 17259741Built 1971 · Yoxall Jennifer S

Back to Guilford, CT