Weyers Cave, VA

Registered aircraft · 31

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 = 'WEYERS CAVE'
  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.

N117WFDJI AGRAS T40 · S/N 1581F574B235W00100P3Houff CorporationN12600Cessna 172M · S/N 17262103Built 1973 · Kelley Aircraft LLCN12651Cessna 172M · S/N 17262146Built 1973 · Kelley Aircraft LLCN13200Cessna 172M · S/N 17262567Built 1973 · Classic Aircraft Sales LLCN13405Cessna 172M · S/N 17262734Built 1973 · Kelley Aircraft LLCN13644Cessna 172M · S/N 17262904Built 1974 · Kelley Aircraft LLCN147CHHylio AG-272 · S/N 17906070233Houff CorpN18PSBeech T-34B · S/N BG-327Built 1957 · Select AirpartsN20157Cessna 172M · S/N 17261053Built 1972 · Kelley Aircraft LLCN20376Cessna 172M · S/N 17261237Built 1972 · Kelley Aircraft LLCN2858QCessna 172L · S/N 17259858Built 1971 · Kelley Aircraft LLCN3734NBeech 35R · S/N D-944-R9Built 1947 · Select Aerospace IndustriesN40238Robinson Helicopter R22 BETA · S/N 1474Blue Ridge Community CollegeN486HBDJI AGRAS T40 · S/N 1581F574B2354001009CBlye Daniel LongN5409JCessna 172N · S/N 17273782Built 1980 · Kelley Aircraft LLCN55219Piper PA-28-180 · S/N 28-7305337Built 1973 · Wilkinson Thomas WN59VLCessna 172L · S/N 17259905Built 1971 · Kelley Aircraft LLCN6KGBeech D-45 · S/N BG-250Select Aerospace Industries IncN71BKBeech G35 · S/N D-4401Built 1955 · Select Aerospace Industries IncN727RCCessna 172M · S/N 17263887Built 1974 · Kelley Aircraft LLCN733FCCessna 172N · S/N 17268253Built 1976 · Kelley Aircraft LLCN733TXCessna 172N · S/N 17268545Built 1977 · Kelley Aircraft LLCN7540GCessna 172L · S/N 17259240Built 1970 · Kelley Aircraft LLCN7575GCessna 172L · S/N 17259275Built 1970 · Kelley Aircraft LLCN757BBCessna 152 · S/N 15279600Built 1977 · Kelley Aircraft LLCN7747GCessna 172L · S/N 17259447Built 1970 · Kelley Aircraft LLCN7781GCessna 172L · S/N 17259481Built 1970 · Kelley Aircraft LLCN888CMCessna 172M · S/N 17267424Built 1976 · Kelley Aircraft LLCN8995UCessna 150M · S/N 15078045Built 1976 · Kelley Aircraft LLCN9630QCessna 172M · S/N 17265714Built 1975 · Kelley Aircraft LLCN9796VCessna 172M · S/N 17264506Kelley Aircraft LLC
Back to Weyers Cave, VA