Winchester, VA
Registered aircraft · 57
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 = 'WINCHESTER' 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 = 'WINCHESTER' 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.
N100JRPiper PA-31-310 · S/N 31-599N1017EBellanca 7GCAA · S/N 342-77N1042SCessna 172N · S/N 172-68662N1841EAeronca 7AC · S/N 7AC-5408N201NUMooney M20J · S/N 24-0277N2084RCessna 182G · S/N 18255284N20985Piper PA-28-181 · S/N 28-7990029N2356JBeech 23 · S/N M-314N24564Piper J4A · S/N 4-649N25JRBeech 95-55 · S/N TC-132N279CKChristopher Kirk RV10 · S/N 42382N3167MPiper PA-12 · S/N 12-1599N320RXOram G/Viver J 320 · S/N 962-320-802N322CSCessna 182T · S/N 18282341N3342ZPiper PA-22-150 · S/N 22-7282N3493CCessna 170B · S/N 26536N34JVP Z L -Warszawa-Cnpsl PZL-104 WILGA 35A · S/N 107334N3547BPiper PA-31-350 · S/N 31-8052017N35VPHawker Beechcraft B300 · S/N FL-788N450JWBoeing IB75A · S/N 75-789N49090Cessna 152 · S/N 15283415N5059GBellanca 7ECA · S/N 1343-80N5076ACessna 310E · S/N 310M0018N50871Cessna 150J · S/N 15069610N50MDEngel Maynard/Douglas ACRO SPORT II · S/N PA604N53424Piper PA-32R-301T · S/N 3257259N5357ECessna 172N · S/N 17271840N5474RCessna 172F · S/N 17253035N5608CCessna 140A · S/N 15541N56905Boeing A75L3 · S/N 75-328N5705HPiper PA-16 · S/N 16-316N5773UPiper PA-28-140 · S/N 28-26597N588KWVans RV-12IS · S/N 121240N611SRSalvatore J Leone TITAN T-51 · S/N M06SV6COHK0106N6429VCessna 172RG · S/N 172RG0690N6713XCessna 310F · S/N 3100013N6747WPiper PA-28-140 · S/N 28-20871N703MRJerry ST. Andre STARDUSTER TOO · S/N 1331N7242FPiper PA-28-140 · S/N 28-25155N74660Grumman American Avn. AA-5B · S/N AA5B-0328N756KZCessna R182 · S/N R18201100N759HPCessna 182Q · S/N 18266009N7805YPiper PA-30 · S/N 30-884N8023JMurphy George M LAK X · S/N 001N80934Piper PA-28-181 · S/N 28-8090105N8275PPowrachute AIRWOLF 912ULS · S/N A293ULSN84SVDassault FALCON 2000EX · S/N 291N853PPilatus P3-05 · S/N 491-40N8623EPiper PA-28-181 · S/N 28-7690182N88176Piper J3C-65 · S/N 15793
Back to Winchester, VA