Registered aircraft · 22

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 = 'SAINT JOHNS' 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 = 'SAINT JOHNS'
  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 = 'SAINT JOHNS'
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.

N1086VCessna R172K · S/N R1722111Built 1976 · Kinney Philip S N13MJVarnum Frank VANS RV-4 · S/N 2537Built 2007 · Vanderbilt Carl D N145MSJonker Sailplanes JS3 RES · S/N 03-145Built 2023 · Clark Harold R N14705Bellanca 17-30A · S/N 74-30668Built 1974 · Bernath Robert J N169VTJonathan Sule VELOCITY V-TWIN · S/N VT006Built 2017 · Jsmd Aeronautics LLC N177BACessna 177B · S/N 17701449Anderson David J N1791GBeech 35-B33 · S/N CD-514Built 1962 · Pac Flying LLC N231LMMooney M20K · S/N 25-0232Built 1979 · Asianov Alexander N27CUAlexander Schleicher ASW 27-18 · S/N 29058Clark Harold R N2845APiper PA-34-200T · S/N 34-7970279Schwartzkopf Gregory N2894BPiper PA-28-181 · S/N 28-7990535Barthell Burley O N4YLCagliero Giorgio LANCAIR 360 · S/N 366Built 1997 · Robinson Roger Jr N5505LGrumman American Avn. AA-5 · S/N AA5-0505Registration pendingBuilt 1974 N555LSSmith Lawrence D VARIEZE · S/N 132Johnston Timothy A N6199AThomas Thomas Clay SKY STAR KITFOX XL · S/N GCX-011Built 1998 · Parrish Jamie G N75DWCessna 182P · S/N 18263906Built 1975 · Bliss Gregory A N812GBBeech F90 · S/N LA-72Built 1980 · Trinity Logistics Holdings LLC N86ERCessna 172P · S/N 17276027Built 1983 · Innovative Aerial Solutions LLC N8733PPiper PA-24-260 · S/N 24-4183Built 1965 · Spaulding Rachael K N92687Belknap John TITAN TORANADO S · S/N S01912SOHK0433Built 2002 · Belknap John R N9896Piper PA-32R-300 · S/N 32R-7680184Built 1976 · Paul Chappano Pa N992MCirrus Design SR22 · S/N 5049Built 2021 · Bob Blandford Air LLC

Back to Saint Johns, FL