Registered aircraft · 18

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

N12SEChristen Industries CHRISTEN EAGLE-II SE · S/N 0001Built 1981 · Boyce Michael D II N137PPBuddy F Henson HENSON PANTHER · S/N P075Ervc Holdings LLC N15079Piper PA-28-140 · S/N 28-7225585Built 1972 · Rea Robert III N218PPCessna 172M · S/N 172-67520Built 1976 · Sumrell James E III N2375ZBeech 23 · S/N M-99Built 1962 · Morrissett Jay Dean N3175FCessna 182J · S/N 18257275Built 1966 · Estes Bernard R N38TDCessna 150L · S/N 15073098Lewis Brian D N42072Cessna 182L · S/N 18258844Built 1968 · Rempe Richard Henry N4917GCessna 172N · S/N 17273464Built 1979 · Carter Richard W N494JVDJI AGRAS T40 · S/N 64TBL7D00200BRVirginia Aerial Applicators LLC N5935ACessna 172 · S/N 28535Built 1956 · Dunn James Blair Jr N634DPPrizio David P GLASTAR · S/N 5634Ervc Holdings LLC N80303Mack Thomas V RANS S-7S COURIER · S/N 1003335SBuilt 2004 · White David A N8298YPiper PA-30 · S/N 30-1437Built 1967 · Estes Bernard R N888LWNavion NAVION A · S/N NAV-4-1283Built 1948 · Schaffer Gary W N93659Ercoupe 415-C · S/N 982Built 1946 · Morrissett Jay D N9655JPiper PA-28-180 · S/N 28-3822Built 1966 · Dunn James Blair Jr N9FZAmerican Legend AL18 · S/N AL-1204Built 2015 · Fosdick William P

Back to Bumpass, VA