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 = 'VA' AND g.registrant_city = 'CENTREVILLE' 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 = 'VA' AND g.registrant_city = 'CENTREVILLE'
  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 = 'VA' AND g.registrant_city = 'CENTREVILLE'
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.

N10300Cessna 150L · S/N 15074832Registration pendingBuilt 1973 N17142Cessna 177B · S/N 17702507Built 1976 · 10ds Ltd N18WLCessna 180K · S/N 18053178Built 1981 · Miller Christopher M N19676Cessna 172L · S/N 17260659Built 1972 · Whitman David L Jr N2512PPiper PA-22-150 · S/N 22-2874Miller Christopher M N394MMPiper PA 46-350P · S/N 4636518Built 2010 · N654nm LLC N4293HMooney M20J · S/N 24-0697Built 1978 · Helleberg John R N4808DCessna 172N · S/N 17272364Built 1979 · Lmnb LLC N525TBeech 95-A55 · S/N TC-360Built 1962 · Chomchird Jon Attaporn N527MLBeech 95-C55 · S/N TE-217Built 1966 · Moss Herman D N5324EBeech K35 · S/N D-5819Built 1959 · Fox James M N5402LGrumman American Avn. AA-5 · S/N AA5-0302Built 1973 · Chomchird Attaporn J N541ASTextron T240 · S/N T24002135Built 2017 · Bc One LLC N6008XPiper PA-30 · S/N 301836Built 1969 · Mangum Gary W N635RCessna 310 · S/N 35092Built 1955 · Robertello Gerald W N6636VBellanca 17-31A · S/N 32-32Built 1970 · Moss Herman D N664RCessna 310D · S/N 39082Built 1960 · Robertello Gerald J N725AACirrus Design SR22 · S/N 10669Built 2025 · Moon Flying LLC N78TCessna 310 · S/N 35012Built 1954 · Robertello Gerald J N7948BCessna 172 · S/N 29748Built 1957 · Gruber Barbara L N8646RSchweizer SGU 2-22C · S/N 148Built 1962 · Whitman David L Jr N87199Cessna 310R · S/N 310R0298Built 1975 · Moss Herman D

Back to Centreville, VA