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.
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
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.
N117WFDJI AGRAS T40 · S/N 1581F574B235W00100P3N12600Cessna 172M · S/N 17262103N12651Cessna 172M · S/N 17262146N13200Cessna 172M · S/N 17262567N13405Cessna 172M · S/N 17262734N13644Cessna 172M · S/N 17262904N147CHHylio AG-272 · S/N 17906070233N18PSBeech T-34B · S/N BG-327N20157Cessna 172M · S/N 17261053N20376Cessna 172M · S/N 17261237N2858QCessna 172L · S/N 17259858N3734NBeech 35R · S/N D-944-R9N40238Robinson Helicopter R22 BETA · S/N 1474N486HBDJI AGRAS T40 · S/N 1581F574B2354001009CN5409JCessna 172N · S/N 17273782N55219Piper PA-28-180 · S/N 28-7305337N59VLCessna 172L · S/N 17259905N6KGBeech D-45 · S/N BG-250N71BKBeech G35 · S/N D-4401N727RCCessna 172M · S/N 17263887N733FCCessna 172N · S/N 17268253N733TXCessna 172N · S/N 17268545N7540GCessna 172L · S/N 17259240N7575GCessna 172L · S/N 17259275N757BBCessna 152 · S/N 15279600N7747GCessna 172L · S/N 17259447N7781GCessna 172L · S/N 17259481N888CMCessna 172M · S/N 17267424N8995UCessna 150M · S/N 15078045N9630QCessna 172M · S/N 17265714N9796VCessna 172M · S/N 17264506
Back to Weyers Cave, VA