Registered aircraft · 26

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 = 'NE' AND g.registrant_city = 'BELLEVUE' 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 = 'NE' AND g.registrant_city = 'BELLEVUE'
  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 = 'NE' AND g.registrant_city = 'BELLEVUE'
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.

N1234RRaysik Michael J RV-4 · S/N 1695Built 1996 · Fitzair LLC N1640YCessna 172C · S/N 17249340Built 1962 · Hall Justin J N16555Piper PA-28R-200 · S/N 28R-7335163Built 1973 · Vampola Timothy D N170RRFouga CM 170 MAGISTER · S/N 209Built 1959 · Magisters Inc N234EBBeech V35 · S/N D-8157Built 1966 · Arbuckle James H N25287Piper PA-38-112 · S/N 38-80A0107Built 1980 · Greenwood John R N2575FChampion 7ECA · S/N 206Built 1965 · Aksarben Flying Club LLC N3035BCessna 195B · S/N 7918Built 1952 · Flying W Aviation Enterprises N3969EAeronca 11BC · S/N 11BC-54Built 1947 · Hill Chad R N402DCCox Dean CHALLENGER · S/N CH2-0101-2044Built 2002 · Watkins Richard L N44152Challenger 2PCWS · S/N CH2-1298-CW-1811Watkins Richard L N4558HMooney M20J · S/N 24-0765Built 1979 · Tjr Inc N477XArbc Inc DBA Lindstrand 77X · S/N 5545Built 2013 · Priority Balloons Ltd N49RMManarin-Johnson LANCAIR IV-P · S/N LIV-093Built 2004 · Freedom Air LLC N512PGAeronca 7AC · S/N 7AC-2446Built 1946 · Grassroots Flying LLC N5720CCessna 170A · S/N 19826Wienk Cody N60078Arbc Inc DBA Lindstrand 77X · S/N 5583Built 2015 · Priority Balloons Ltd N6686RMooney M20E · S/N 429Built 1964 · Anderson Benjamin P N67345Bromley Jeff AVID FLYER MARK IV · S/N 1252DWatkins Richard L N675LFDehavilland TIGER MOTH DH 82A · S/N PG675Built 1944 · Rued John Frederick N7097AAerostar International RX-7 · S/N RX7-3303Built 1994 · Fenster Matthew N754GQDraganfly Innovations DRAGANFLYER X4-ES · S/N 605129Bellevue Fire Dept N8311UCessna 172F · S/N 17252211Built 1964 · Vendetta Consulting LLC N85BBBeech A36 · S/N E-508Built 1973 · Avanti Aviation LLC N8809XCessna 182D · S/N 18253209Built 1961 · Parker James G Jr N99796Ercoupe 415-C · S/N 2419Smith David L

Back to Bellevue, NE