Registered aircraft · 20

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

N12NFracher Special FRACHER SPECIAL · S/N 1Built 1951 · Denman Thomas G N1459YCessna 172C · S/N 17249159Built 1962 · Briere Mark E N164WMCox Carson H RV-6A · S/N 22423Built 2000 · Mcclellan Nicklas C N241MJJimenez Mario A MUSTANG II · S/N 1055Built 1987 · Mj Aero LLC N3896VParascender Technologies PARASCENDER 582 · S/N 220088Built 1997 · Mehaffey Billy H N4098XAero Commander 100-180 · S/N 5198Ostgard William R N5970CClyde R Rychel CH650 · S/N 65-8315Built 2012 · Rychel Clyde R N62912Piper PA-31-350 · S/N 31-7652164Built 1976 · Gross Charles C III N64186Cessna 172M · S/N 17265072Built 1975 · Paraloft LLC N65911Schweizer SGS 1-26E · S/N 611Built 1974 · Brown Leonard W N76JNPiper PA-31-350 · S/N 31-7652176Built 1976 · Gross Charles C III N777TEOttmar Thiele M24 ORION PLUS · S/N 24224116Built 2023 · Thiele Ottmar D N77869Luscombe 8A · S/N 3596Built 1946 · Briere Mark E N8131Piper PA-31-350 · S/N 31-8152032Built 1981 · Regional Air & Transport LLC N824RGGardner R/Gardner N GARDNER AVENTURA II · S/N AA2A0129Briere Mark E N8383WPiper PA-28-180 · S/N 28-2586Built 1965 · Mj Aero LLC N873AVVoss Albert L VOSS RV-8 · S/N 81491Built 2007 · Voss Albert L N911GMCessna 500 · S/N 500-0048Built 1972 · Rroberts Enterprises LLC N9164EAeronca 11AC · S/N 11AC798Built 1946 · Denman Thomas G N97848Cessna 182Q · S/N 18267220Built 1979 · Manion Christopher M

Back to Mims, FL