Registered aircraft · 96

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL

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 = 'WEIRSDALE' ORDER BY g.n_number

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 = 'WEIRSDALE'
  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 = 'WEIRSDALE'
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.

N109DGGidzinski David A DEE GEE 77 · S/N 77-03Gidzinski David A N113WMAlon A2 · S/N A-114Built 1966 · Starke Charles H III N116TBEnstrom F-28C · S/N 362Mcmullan Francis G N11HVCostruzioni Aeronautiche Tecna P2008 · S/N 210Built 2023 · Vu Duc Hanh T N123DRRitson Craig E RV-7A · S/N 70822Built 2023 · Ritson Craig E N14224Piper PA-23-250 · S/N 27-4783Built 1972 · Townley William V N143BWWilliamson William H RANS S-7S · S/N 0208498Built 2010 · Miller Woodrow S N14DDDahl H Douglas RV-6 · S/N 23350Built 1996 · Cubano Miguel A N152SCCzech Sport Aircraft A S SPORTCRUISER · S/N P1001084Built 2011 · Grand Douglas V N169JRRiemer John R RV-6 · S/N 24081Built 2010 · Hull Terri L N1706GBeech 95-A55 · S/N TC-274Built 1962 · Barcenas Shawn N17509Beech A36 · S/N E-972Built 1976 · Starke Charles H III N1892EChampion 7AC · S/N 7AC-5460Built 1946 · Wimberly Gary E N1893EAeronca 7AC · S/N 7AC-5461First renewal noticeBuilt 1946 · Mclean Diane A N1956PPiper PA-18-150 · S/N 18-4183Built 1955 · Normark Nancy B N199DGDavid A Gidzinski VANS RV 6 · S/N 21270Built 2020 · Gidzinski David A N20CWWalker PITTS SPECIAL S-1C · S/N 002Built 1971 · Wingover Aerobatics LLC N21LYDe Villegas Anita DRIFTER · S/N SD9122302Built 2023 · De Villegas Anita N2233MCessna 182S · S/N 18280069Putnam John P N242DGMoravan Z242L · S/N 0687Built 1995 · Wing Over Aerobatics LLC N2617BBuchan James F SEA REY · S/N 1MK-113Built 1996 · Durbin Christopher J N27183Piper J3C-65 · S/N 4420Built 1940 · Gidzinski David A N2814KCessna 180K · S/N 18053085Built 1979 · Macario Mark A N29009Fairchild 24W-41A · S/N W41110Built 1941 · Mclean Diane A N29370Waco YKS-7 · S/N 5228First renewal noticeBuilt 1940 · Mclean Diane A N3061FCessna 182J · S/N 18257161Built 1966 · Taber Deane W N3470SPridgen Blaine D KITFOX III · S/N 842Built 2009 · Ricketts Michael D N363TMAngell Michael S RV-14A · S/N 140986Angell Michael S N367JHSteven F Wolf WJB-47D · S/N WJB-001Wingover Aerobatics LLC N385TCorben Baby Ace D · S/N WE-703Built 1980 · Cynamon Bruce E N4121DHelio H-391B · S/N 041Registration pendingBuilt 1957 N415EHEngineering & Research ERCOUPE 415-C · S/N 3883Dane-Muterspaugh Julie W N424DRRitson Craig E RITSON SONEX · S/N 540Ritson Craig E N4261CBucker Jungmann C.A.S.A. 1.131 · S/N E3B-329Built 1954 · Gidzinski David A N42XRWalker Arnold B RANS S-12 · S/N 1093453Jennings Alan E N44SNBoeing A75N1(PT17) · S/N 75-2763Built 1941 · Macario Mark A N453KWProgressive Aerodyne SEAREY LSA · S/N 1099Built 2019 · Wingover Aerobatics LLC N4558EGulfstream American AA-5B · S/N AA5B1239Smith Gregory W N4566KRyan NAVION A · S/N NAV-4-1566First renewal noticeBuilt 1948 · Mclean Diane A N476HHumphrey-Wa PITTS S-1 · S/N 70385Built 1978 · Durbin Christopher J N4823JBeech V35 · S/N D-8337Built 1966 · Haunstein Manfred N5022DCessna 182A · S/N 51122Built 1958 · Searey 806 LLC N515EAEla Aviation USA ECLIPSE 10 · S/N 10165121014Built 2017 · Wagman John F N5165DCessna 182A · S/N 51265Built 1958 · Hull Terri L N5300UPiper PA-28-140 · S/N 28-20235Built 1964 · Eden Mark A N5497FMooney A-2A · S/N B-297Built 1969 · Jacques Denis A N552HMcmullan III Francis G HUMMINGBIRD · S/N 2005Built 2022 · Mcmullan Francis G III N5535ZPiper PA-22-108 · S/N 22-9325Payne Dustin J N566RCMark A Maltais ZENITH CH750 · S/N 75-8433Built 2015 · Jacques Adam P N569RVClaycomb Rd/Claycomb Da VANS RV-9 · S/N 91519Built 2010 · Ricketts Michael D

Back to Weirsdale, FL