Registered aircraft · 16

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 = 'CA' AND g.registrant_city = 'ARCATA' 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 = 'CA' AND g.registrant_city = 'ARCATA'
  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 = 'CA' AND g.registrant_city = 'ARCATA'
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.

N1355RGrumman American Avn. AA-5 · S/N AA5-0755Built 1975 · Fly Guys LLC N1678XCessna T210L · S/N 21060713Built 1975 · Fly Guys LLC N1822DGiffin Oakley M RV-6 · S/N 10GBuilt 1996 · Merryfield James G N1928QCessna 177RG · S/N 177RG0328Built 1973 · White David D N202ETEdward A Tooey JA30 SUPERSTOL · S/N JA332-11-13Built 2014 · Harris Mark P N2398SCessna T337B · S/N 337-0698Built 1967 · Bowser Earle Stephen N340ANCessna 340A · S/N 340A0401Built 1977 · O & M Industries Inc N4005DCessna 182A · S/N 34705Built 1957 · Harris Mark P N4089DCessna 182A · S/N 34789Built 1958 · Gaffney Justin L N455DKPilatus PC-12/45 · S/N 194Danco Builders N4837NCessna 182Q · S/N 18267407Tres Bros LLC N5082PPiper PA-24-180 · S/N 24-88Built 1958 · Shaw Jeryl V N55LZBowser/Hinckley LONGEZE · S/N 1037Bowser Earle S N681JZCessna 560 · S/N 560-0681Built 2004 · Danco Builders N7920JCirrus Design SR22T · S/N 1023Built 2015 · Clear Creek Medical Corp N8414UCessna 172F · S/N 17252314Built 1964 · Hanan Rose R

Back to Arcata, CA