Registered aircraft · 23

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

N115JCWallace Hale SKYBOLT · S/N 2Clarke Michael J N147GCZachary Clement RV-14 · S/N 140035Built 2016 · Ingegneri Robert L N163MCCessna 172D · S/N 17250149Built 1963 · Criddle Michael J N2054RCessna 182G · S/N 18255254Built 1964 · Riptide Investments LLC N343BSSchertz William W KIS CRUISER · S/N 001Built 2008 · Meyers Glenn W N4252BBeech F35 · S/N D-4228Built 1955 · Sexton Kenneth Wade N4458CCessna 195 · S/N 16043Built 1953 · Marken Jeffrey R N47HJHarris John W WITTMAN TAILWIND · S/N 476Built 1987 · White Billy C N4853PPiper PA-23-250 · S/N 27-426Swan Aviation Ministries Inc N48PMCessna 210 · S/N 57567Built 1960 · Freeman Robert G DBA N516LBWalter M Burkett JR SLING 4 TSI · S/N 569SKBurkett Walter Jr N5600MVarga 2180 · S/N VAC-183-82Built 1982 · Clarke Michael J N56866Piper PA-32-300 · S/N 32-7440033Built 1973 · Skelton David W N58699Aeros SKYRANGER BCARS · S/N SKR 0412538Dotson Tracy N59184Boeing B75N1 · S/N 75-6852Marken Jeffrey R N6348SCessna 150G · S/N 15067148Built 1967 · Sexton Kenneth Wade N70EMSchleicher ASW-24B · S/N 24232Clarke Michael J N83291Aeronca 7AC · S/N 7AC-1959Built 1946 · Rh Resources LLC N8ZGGeorge Neal VANS RV-7 · S/N 71771George Neal N93585Cessna 152 · S/N 15285521Built 1982 · Sipher William M N96ANNewton Alvan M RV-6 · S/N 24497Built 1996 · Costabile Gregg D N9920BCessna 172RG · S/N 172RG1081Built 1982 · Schultz Robert G N997SJRans Designs S-7LS · S/N 0414607Built 2014 · Nixon Shannon N

Back to Baker, FL