OpenAirDocs.org
Bridgewater, VA

Registered aircraft · 135

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
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 = 'BRIDGEWATER'
  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.

N1235WBalony Kubicek Spol Sro BB30Z · S/N 864Built 2011 · Star Ballooning LLCN1400EBeech E18S · S/N BA-227Built 1956 · Dynamic Avlease IncN14AGulfstream Aerospace G-IV · S/N 1132Built 1987 · Dynamic Avlease IncN1525LFirefly Balloons FIREFLY 9B-15 · S/N F9B-2003Built 2003 · Star Ballooning LLCN1670UKrueger Jerry D TORNADO II · S/N 41619351Built 2002 · Baxter Jeremy MN20286Cessna 172M · S/N 17261159Built 1972 · Shenvair LLCN22NBeech E-90 · S/N LW48Built 1973 · Dynamic Avlease IncN26EBeech E-90 · S/N LW-62Dynamic Avlease IncN321FBeech A200 · S/N BC-70Built 1979 · Dynamic Avlease IncN321PBeech A200C · S/N GR-10Built 1980 · Dynamic Avlease IncN32PBeech 65-A90-1 · S/N LM-31Built 1966 · Dynamic Avlease IncN35PHawker Beechcraft B300 · S/N FL-730Dynamic Avlease IncN35QHawker Beechcraft B300 · S/N FL-739Dynamic Avlease IncN37HBeech 65-A90-1 · S/N LM-48Built 1967 · Dynamic Avlease IncN38VBeech 65-A90-1 · S/N LM-105Built 1968 · Dynamic Avlease IncN40RBeech 200 · S/N BC-7Built 1975 · Dynamic Avlease IncN40YRaytheon A200CT · S/N BP-30Built 1982 · Dynamic Avlease IncN41JBeech 65-A90-1 · S/N LM-89Built 1967 · Dynamic Avlease IncN42ZBeech 200 · S/N BC28Built 1976 · Dynamic Avlease IncN43ABeech A200 · S/N BC-73Built 1979 · Dynamic Avlease IncN44UBeech 200T · S/N BT-14Dynamic Avlease IncN469NTravel Air 4000 · S/N 1383Built 1929 · Dynamic Aviation Group IncN46LBeech A200 · S/N BC-56Built 1978 · Dynamic Avlease IncN47EDouglas DC3C · S/N 13816Built 1943 · Dynamic Avlease IncN48QBeech B200C · S/N BL48Built 1981 · Dynamic Avlease IncN49RBeech A200 · S/N BD02Built 1975 · Dynamic Avlease IncN50EBeech 200C · S/N BL7Built 1979 · Dynamic Avlease IncN50XBeech B200 · S/N BB-1239Built 1985 · Dynamic Avlease IncN52LBeech Acft B200T · S/N BT-31Dynamic Avlease IncN53WBeech B200C · S/N BL-53Built 1982 · Dynamic Avlease IncN541MCBeech 65-A90-1 · S/N LM-39Dynamic Avlease IncN54FBeech B200C · S/N BL-46Built 1982 · Dynamic Avlease IncN55ABeech B200C · S/N BL-55Built 1982 · Dynamic Avlease IncN57BBeech B200C · S/N BL-67Built 1983 · Dynamic Avlease IncN58QBeech 200C · S/N BL8Dynamic Avlease IncN59MBeech B200 · S/N BB-1419Dynamic Avlease IncN60CBeech 65-A90-1 · S/N LM-11Built 1968 · Dynamic Avlease IncN61QBeech 65-A90-1 · S/N LM-92Built 1968 · Dynamic Avlease IncN62VBeech 65-A90-1 · S/N LM-74Built 1967 · Dynamic Avlease IncN64CBeech 65-A90-1 · S/N LM-32Built 1967 · Dynamic Avlease IncN65UBeech 65-A90-1 · S/N LM-87Built 1967 · Dynamic Avlease IncN65VBeech 65-A90-1 · S/N LM-113Built 1968 · Dynamic Avlease IncN66WBeech 65-A90-1 · S/N LM-68Built 1967 · Dynamic Avlease IncN67BBeech 65-A90-1 · S/N LM-59Built 1967 · Dynamic Avlease IncN67KBeech 65-A90-1 · S/N LM-24Built 1967 · Dynamic Avlease IncN7007GBeech 65-A90-1 · S/N LM-02Dynamic Aviation Group IncN7010LBeech 65-A90-1 · S/N LM-07Dynamic Aviation Group IncN7014LBeech 65-A90-1 · S/N LM-10Dynamic Aviation Group IncN7018FBeech 65-A90-1 · S/N LM-13Dynamic Aviation Group IncN70292Beech 65-A90-1 · S/N LM-18Dynamic Aviation Group Inc
Back to Bridgewater, VA