Charlottesville, VA
Registered aircraft · 60
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 = 'CHARLOTTESVILLE' 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 = 'CHARLOTTESVILLE' 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.
N100ACBombardier CL-600-2B16 · S/N 5546N152DPPeltier Dennis VORTEX · S/N 014N15494Piper PA-32-300 · S/N 32-7340045N1612HPiper J3C-65 · S/N 20678N1612LPiper PA-18-150 · S/N 188620N17171Piper J3C-65 · S/N 19970N172MECessna 172M · S/N 17263996N174WAPiaggio P180 · S/N 1074N189LWPiaggio Aero Industries P180 · S/N 1181N1QWConsolidated Aeronautics LAKE LA-4-200 · S/N 1017N212MPCompagnie Daher TBM 700 · S/N 1467N218CFCessna 340A · S/N 340A0989N22KHCirrus Design SR22 · S/N 0198N2399NScheibe SF-25C · S/N 44656N2439UCessna 172D · S/N 17250039N252YUMooney M20K · S/N 25-1089N267WFPilatus PC-12/45 · S/N 267N31608Piper PA-32RT-300 · S/N 32R-7885110N3275FMooney M20F · S/N 670368N345PMBeech N35 · S/N D-6635N377DSDiamond Aircraft Ind DA 40 · S/N 40.277N3840HMooney M20J · S/N 24-0959N4067WPiper PA-32-300 · S/N 32-40103N412JSPilatus PC-12/47E · S/N 1466N42433Piper J3F-65 · S/N 14697N4256ACorben Baby Ace C · S/N C-1N434JAPilatus PC-12/47 · S/N 819N4371KRyan NAVION · S/N NAV-4-1371N44197Taylorcraft BC12-D1 · S/N 9997N4548TCostruzioni Aeronautiche Tecna P2008 · S/N 182N475JBVans RV-12 · S/N 120046N478MPCirrus Design SR22 · S/N 3470N50KQQuest KODIAK 100 · S/N 100-0250N54LKLancair LC41-550FG · S/N 41533N550DEEidal Peter M RV 4 · S/N 2656N55UVAirbus Helicopters MBB-BK 117 C-2 · S/N 9875N560VACessna 560XL · S/N 560-6191N570WECirrus Design SR22 · S/N 10757N581STDassault FALCON 900EX · S/N 300N617FMMoore Franklin D RV-6 · S/N 22557N6240GSettle Stephen Allen KIS TR-1 · S/N 086N643MTPiper PA-28-180 · S/N 28-5646N65256Cameron Balloons US A-120 · S/N 6685N70647Piper J3C-65 · S/N 17665N741VXCirrus Design SR22T · S/N 1404N7477XCessna 172B · S/N 17247977N781CKPiper PA-31T · S/N 31T-7820056N788MKCessna 182R · S/N 18268233N8382PPiper PA-24-250 · S/N 24-3641N850PWSocata TBM 700 · S/N 390
Back to Charlottesville, VA