Registered aircraft · 25

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

N1339CPiper PA-22S-135 · S/N 22-1135Built 1953 · Walt'S Kustom Kreations Inc N1898JPiper PA-28-140 · S/N 28-24344Built 1968 · Norris Joseph M N32RVHiatt Bradley J VANS ACFT INC RV-6A · S/N 22253Built 1997 · Timbie Peter W N357BKMusgrave Scott GLASAIR SUPER IIS-FT · S/N 2353Built 2003 · Stone Michael N36JPPasseno Jeffrey Paul ACROSPORT II · S/N 994Built 1990 · Passeno Jeff P N3780HHylio HYL-150 · S/N 17906110303St Johns River Water Management District N3KWBeech 35 · S/N D-828Built 1947 · Beute Walter A N413LADiamond Aircraft Ind DA 40 NG · S/N 40.NC138Built 2021 · N925lr LLC N4315KRyan NAVION A · S/N NAV41315Built 1948 · Fridley John K N438ABBryan Robert W KITFOX III · S/N 766Built 2015 · Bryan Robert W N537PBell OH-58A · S/N 69-16337Putnam County Sheriffs Office N6050TBeech A36 · S/N E-1488Built 1979 · Gullett Aviation LLC N6240RSheridan Stephen J FREE TIME · S/N 9421Built 1996 · Sheridan Stephen J N630JPPasseno Jeff CORVUS · S/N 0100Built 2005 · Passeno Jeff P N70417Piper J3C-65 · S/N 17411Built 1946 · Sevearance Joshua T N727RDRogers Randy BUDDY BABY LAKES · S/N 8926-A-1025-BBBuilt 1995 · Rogers Randall E N773SBCessna 150J · S/N 15070665Built 1969 · Quinn Vita Lyn N81410Schleicher K 8 B · S/N SH-8480Passeno Jeff P N8178AAeronca 7AC · S/N 7AC-407Built 1945 · Skowbo Rock G N8213JAerotek PITTS S-2A · S/N 2258Built 1981 · Wcd LLC N8464MCessna A150K · S/N A1500164Built 1970 · Barrineau Charles A N88TDTaylorcraft BC12-65 · S/N 3150Dudley Shiloh W N900JPPasseno Jeffrey P GLASAIR III · S/N 3374Built 2022 · Passeno Jeffrey P N9063EAeronca 11AC · S/N 11AC694Dudley Shiloh W N91ECBell OH-58A · S/N 70-15615Putnam County Sheriffs Office

Back to Palatka, FL