Registered aircraft · 15

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

N10066Creighton G Dewayne FLIGHTSTAR IISC · S/N 324Buchholz Robert A N109UALet L-13 BLANIK · S/N 174011Built 1969 · N109ua LLC N220DRUrbanski Daniel R RV6A · S/N 24400Built 2002 · Havana Aero Club LLC N311KAAucoin Kenneth W GS-2 SPORTSMAN · S/N 7119Built 2008 · Rogers Stephen G Trustee N3262HSmith Ray OLDFIELD LAKES BIP85 · S/N 7026-E257BBuilt 1983 · Mosier Charles A N43874Taylorcraft BC12-D · S/N 7533Built 1946 · Mosier Charles A N459VPCessna 525A · S/N 525A0459Built 2009 · Coastal Forest Resources Co N66UNRobert Willis RV-6 · S/N 60342Built 2013 · Willis Robert L N674BDJesse Saint/David Nichols/Galo RV-10 · S/N 40975Built 2011 · Stephen G Rogers N8030NPiper PA-28-140 · S/N 28-25275Built 1968 · Wilson Mark A N8110VCessna 188 · S/N 188-0360Built 1968 · N8110v LLC N817TRPiper PA-32R-301T · S/N 3257132Built 2000 · Robinson Trent N82BKCharles Heatherly BUCKEYE DREAM MACHIN · S/N 3339Sparkman Roger N8826ZCessna 172H · S/N 17255476Built 1966 · Quincy Flyers LLC N933DDCessna 182 · S/N 18260933Built 1972 · Harris John Alfred

Back to Havana, FL