Blacksburg, VA
Registered aircraft · 45
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 = 'BLACKSBURG' 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 = 'BLACKSBURG' 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.
N105CBBellanca 17-31ATC · S/N 31041N1210XMooney M20E · S/N 185N1250SCessna 182P · S/N 18264819N161SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0543N21477Cessna 182P · S/N 18261657N215RLDJI AGRAS T100 · S/N 1581F8ZLC25AA0020TH3N230DABeech 95-A55 · S/N TC-387N253QPDJI AGRAS T40 · S/N 64TBL8E00200B6N2731Glasflugel MOSQUITO · S/N 148N2826TPiper PA-28R-200 · S/N 28R-7235016N3051NPiper PA-28-181 · S/N 28-7990286N30JTO'Dell Roger Keith RV-8 · S/N 80903N33MMCirrus Design SF50 · S/N 0387N34248Cessna 177B · S/N 17701732N413KWChris Wallen JA35 SUPERSTOL STRET · S/N JA579-03-20N41691Bellanca 7GCBC · S/N 591-73N446FSCostruzioni Aeronautiche Tecna P2008 · S/N 012N4504PDJI AGRAS T50 · S/N 1581F6BUB2488001G39KN45VTYamaha RMAX · S/N L172000006N4951ACessna A152 · S/N A1520911N5163PPiper PA-24 · S/N 24-179N51VTCessna 560XL · S/N 560-5072N5689DBeech M35 · S/N D-6482N572TBeech S35 · S/N D-7400N580BKBeech B200 · S/N BB-1000N5834WPiper PA-28-150 · S/N 28-2186N6157DPiper PA-22-150 · S/N 22-4804N61FLPiper PA 46-350P · S/N 4622037N6808JPiper PA-28R-200 · S/N 28R-7635335N684BBTextron 680A · S/N 680A0016N707BEDassault FALCON 2000 · S/N 07N7117VMooney M20C · S/N 20-0030N711DVColumbia Aircraft Mfg LC41-550FG · S/N 41758N7191XCessna 150A · S/N 15059291N720CUCessna 140 · S/N 9307N7763MMooney M20C · S/N 20-0016N808BEBeech B200 · S/N BB-1312N8210BCessna 172 · S/N 36010N864MDegair LANCAIR 360 · S/N 822N8663MBeech 35-B33 · S/N CD-682N86VTSensefly EBEE · S/N EB-03-06117N9428SBeech 35-C33 · S/N CD-998N961VJDavid L Lawrence VANS ACFT INC RV-7 · S/N 74845N962FPiper PA-32R-301T · S/N 3257067N97VTCirrus Design SR22 · S/N 4884First renewal notice
Back to Blacksburg, VA