South Burlington, VT
Registered aircraft · 63
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 = 'VT' AND g.registrant_city = 'SOUTH BURLINGTON' 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 = 'VT' AND g.registrant_city = 'SOUTH BURLINGTON' 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.
N114KCEmbraer S A EMB-505 · S/N 50500067N1375JRockwell International 112A · S/N 375Registration pending, pending cancellationN162CFCirrus Design SR22T · S/N 10769N16ARHelicopteres Guimbal CABRI G2 · S/N 1412N17NBoeing A75N1(PT17) · S/N 75-3667N17SEPilatus PC-12/47E · S/N 1322N1931JRockwell International 114 · S/N 14031N209JPCessna 208 · S/N 20800409N21157Cessna 172M · S/N 17263901N214BTBeta Technologies CX300 · S/N BT31C-0002N250HVBeta Technologies HV250 · S/N BT21A-0002N250UTBeta Air ALIA-250 · S/N 001N250XTBeta Technologies A250 · S/N BTV21V-0001N251UTBeta Air ALIA-250 · S/N 002N256LGEmbraer Executive EMB-505 · S/N 50500642N298MECessna 172S · S/N 172S8557N314LCBeta Technologies CX300 · S/N BT31C-0008N336MRBeta Technologies CX300 · S/N BT31C-0003N362FGRepublic / Blue Sky P47D-40-RA · S/N 39955706N363KSSchleicher ASK-21 · S/N 21228N364SPCessna 172S · S/N 172S8782N371PAHelicopteres Guimbal CABRI G2 · S/N 1078N399CLSaab SAAB 340B · S/N 340B-399N401NZBeta Technologies CX300 · S/N BT31C-0004N401SHHelicopteres Guimbal CABRI G2 · S/N 1195N415TSDiamond Aircraft Ind DA 42 · S/N 42.AC015N52332Cessna 182P · S/N 18262534N526VTAviat A-1A · S/N 1411N529MBBeta Technologies CX300 · S/N BT31C-0007N533LPPipistrel D O O ALPHA TRAINER · S/N 1220 AT 912 LSAN534LPPipistrel D O O ALPHA TRAINER · S/N 1222 AT 912 LSAN53735Bellanca 7KCAB · S/N 534-75N540LPPipistrel D O O VIRUS SW 121A · S/N VSWX121A0181N555LPRockwell International 114 · S/N 14405N558ECommander 114-B · S/N 14603N5653DJ J Ultralights SEAWING · S/N SWJ 503100025N58957Boeing D75N1 · S/N 75-3850N60AFStemme S10-VT · S/N 11005N64835Cessna 305A · S/N 22470N64AFCessna 172R · S/N 17280069N70933Cessna 182M · S/N 18259423N709JLBeta Technologies CX300 · S/N BT31C-0005N734JACessna 172N · S/N 17268879N785BGCessna 172R · S/N 17281325N801RPPipistrel D O O ALPHA TRAINER · S/N 1224 AT 912 LSAN802RPPipistrel D O O ALPHA TRAINER · S/N 1251 AT 912 LSAN803EPPipistrel D O O VIRUS SW 128 · S/N VSW128F0107N804EPPipistrel D O O VIRUS SW 128 · S/N VSW128F0111N805BTEurocopter AS 350 B3 · S/N 3563N805EPPipistrel D O O VIRUS SW 128 · S/N VSW128F0112
Back to South Burlington, VT