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 = 'NV' AND g.registrant_city = 'WELLINGTON' 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 = 'NV' AND g.registrant_city = 'WELLINGTON'
  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 = 'NV' AND g.registrant_city = 'WELLINGTON'
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.

N1185JAero Commander 112 · S/N 178Built 1974 · Birk Ronald G N149ERBergantz PITTS S-1-S · S/N 1-2Built 1975 · Ohlau Mark A N152PKCessna 150D · S/N 15060090Built 1963 · Duby James C N185PTCessna 185C · S/N 185-0760Built 1964 · Hansen Peter N N18PTLeider George K LEIDER-THORP T-18 · S/N 2000Hansen Peter N N2770SCessna 150G · S/N 15066670Built 1967 · Birk Ronald G N300SDSteven Deckard HIGHLANDER · S/N JA580-03-20Deckard Steven W N3RHCorben Baby Ace D · S/N REH-1Ohlau Mark A N42428Cessna 182L · S/N 18259014Built 1968 · Hantzsche Jackson R N43PKKrugh Patrick M STEEN SKYBOLT · S/N 2004Digiuseppe David A N4874TPiper PA-28R-200 · S/N 28R-7235128Smith Richard R Sr N53719Bellanca 7GCBC · S/N 858-75Built 1975 · Allen Scott P N588TBCessna 421C · S/N 421C0064Built 1976 · Vlot Cole T N61876Cessna 172M · S/N 17264861Built 1975 · Ferrara James L Jr N714SSCessna 150M · S/N 15079403Built 1977 · Pierce Jeanne E N72051Luscombe 8A · S/N 3478Built 1946 · Deckard Steven W N77304Cessna 140 · S/N 11746Deckard Steven N7744KPiper PA-20 · S/N 20-567Built 1950 · Ohlau Mark A N90CRRosser Jere E RV-4 · S/N 1053Built 1993 · Allen Scott P N9301YBeech 95-55 · S/N TC-6Built 1960 · Oxx William A Trustee N97651Stinson 108 · S/N 108-651Ramstad Craig

Back to Wellington, NV