The Villages, FL
Registered aircraft · 90
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 = 'FL' AND g.registrant_city = 'THE VILLAGES' 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 = 'FL' AND g.registrant_city = 'THE VILLAGES' 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.
N100YWCirrus Design SR22T · S/N 2215N105WZMichael L Robbins QUADCITYCHALLENGERII · S/N CH20499-1873N1185CCessna 177B · S/N 17702682N1212UCessna 172M · S/N 17266909N1289QCessna 150L · S/N 15072589N128FFThomas Blake NIEUPORT 28 · S/N 6128N12HUAviat A-1 · S/N 1345N153SWFlight Design CTSW · S/N 07-06-10N158RGGuilliams Robert J TITAN T-51 D · S/N M10HV6SOHK0158N16073Cessna 150L · S/N 15073456N182RCCessna 182Q · S/N 18267016N194HWJames K Buechler VANS ACFT MDL RV-9A · S/N 90952N1971DDrouin Rejean J PANTHER 2 PLUS · S/N 010984N201LTMooney M20J · S/N 24-0511First renewal noticeN20DLLandry Daniel G VANS RV-7A · S/N 71234N211LWLarry Wright LANCAIR 360 · S/N 332N217JHCirrus Design SR20 · S/N 1320N2225CRobinson Helicopter R22 · S/N 4917N222BTCirrus Design SR22 · S/N 4726N2430UCessna 172D · S/N 17250030N28838Grumman American Avn. AA-5B · S/N AA5B0726N28DTPiper PA-28-181 · S/N 2843534N293CTFlight Design CTSW · S/N 06-08-08N313RTCharles Turner TURNER RV-10 · S/N 41043N3729KGlobe GC-1B · S/N 1422N3AGPiper PA-60-602P · S/N 60-8365018N41SXMay George F ONEX · S/N 0121N42BAeronca L-3B · S/N 058B2692N43TBoeing E75N1 · S/N 75-5082N4432JPiper PA-28-140 · S/N 28-22835N448JRVans RV-12 · S/N 120621N4589PBeech N35 · S/N D-6798N46415Cessna 172K · S/N 17257252N4728KCessna 182P · S/N 18263727N473TDPiper PA-60-602P · S/N 60-8365013N477WHHutts Walter G SPIRIT · S/N 001First renewal noticeN4KJCondrey Robert L RV-10 · S/N 41108N50WABeech G18S · S/N BA-616N511STTilford Stephen J RV-7A · S/N 72341N5220YPiper PA-23-250 · S/N 27-2269N5271UCessna 172RG · S/N 172RG0316N527WMMueller William P MURPHY RENEGADE · S/N 489N52MAMitsubishi MU-2B-40 · S/N 419 S.A.N54033Boeing A75N1(PT17) · S/N 75-3857N5484LGrumman American Avn. AA-5 · S/N AA5-0384N55319Piper PA-28R-200 · S/N 28R-7335215N5559ZSocata TB-20 TRINIDAD · S/N 1279N558CAAlexander Schleicher ASW 27-18 · S/N 29096N595CFHawker Beechcraft G58 · S/N TH-2346N59YPDassault MYSTERE-FALCON 50 · S/N 275
Back to The Villages, FL