Lynchburg, VA
Registered aircraft · 92
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 = 'LYNCHBURG' 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 = 'LYNCHBURG' 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.
N103GRCessna 560XL · S/N 560-5327N1058RRaytheon 58 · S/N TH-1791N107DWWoodruff David L RANS S/14 AIRAILE · S/N 0295083N1306MCessna 172S · S/N 172S10336N145TACessna 500 · S/N 500-0145N156SEBuckeye Powered Parachutes 582 DREAM MACHINE · S/N 3466N1793QCessna 150L · S/N 15073093N18100Cessna 150L · S/N 15073785N187JWMooney M20F · S/N 700056N189TPiper PA-18-105 SPECIAL · S/N 18-2303N2040THead Balloons AX9-118 · S/N 339N2225ACessna 172S · S/N 172S10467N226ETEdgar T Harris JR ZODIAC 650B · S/N 65-8937N233ESBeech F33A · S/N CE-1683N276SACessna 172S · S/N 172S11276N29049Piper PA-28-181 · S/N 28-7990429N31113Head Balloons AX8-105 · S/N 299N3113THead Balloons AX9-118 · S/N 295N318Cessna R172E · S/N R172-0006First renewal noticeN333ADCessna 150M · S/N 15078954Registration pending, pending cancellationN3488WPiper PA-32-260 · S/N 32-367N348RTHawker Beechcraft B200GT · S/N BY-127N3748HCessna 210D · S/N 21058248N385WZPowrachute AIRWOLF 912 · S/N A116ULSN4032UCessna 150E · S/N 15061432N4044JCessna 150G · S/N 15065344N4133RPiper PA-32-300 · S/N 32-40450N422WTravel Air 16-K · S/N 16K-2004First renewal noticeN42303Piper J3C-65 · S/N 14553N423KAJetstream JETSTREAM 4100 · S/N 41023N42734Piper J3C-65 · S/N 15034N4303FPiper PA-28-236 · S/N 28-8311017N469RBCessna 525A · S/N 525A0031N50630Bellanca 7GCBC · S/N 1179-80N6004GCessna 150K · S/N 15071504N61WMPiper PA-32RT-300 · S/N 32R-7985091N66708Cessna 150M · S/N 15076225N6928TCessna 310D · S/N 39228N701LUCessna 172S · S/N 172S11163N702LUCessna 172S · S/N 172S11386N703LUCessna 172S · S/N 172S11387N704DACessna 550 · S/N 550-0202N704LUCessna 172S · S/N 172S11425N705LUCessna 172S · S/N 172S11426N706LUCessna 172S · S/N 172S11472N7078JBeech 65-A90-1 · S/N LM-67N707LUCessna 172S · S/N 172S11473N708LUCessna 172S · S/N 172S11474N709LUCessna 172S · S/N 172S11419N710LUCessna 172S · S/N 172S11420
Back to Lynchburg, VA