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 = 'CO' AND g.registrant_city = 'BAYFIELD' 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 = 'CO' AND g.registrant_city = 'BAYFIELD'
  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 = 'CO' AND g.registrant_city = 'BAYFIELD'
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.

N1027XCessna 180 · S/N 31205Built 1954 · Harper Shawn N1871TPiper PA-28-140 · S/N 28-7225021Bynum Jeffery A N2575PBalloon Works FIREFLY 8B-15 · S/N F8B-436Campbell Philip L N2ZFAviat S-2C · S/N 6040Built 2000 · Split S LLC N3493ABeech E33 · S/N CD-1234Built 1969 · Papago Equipment LLC N356AHoltzman Arthur J SONEX - 03 · S/N 356Brooks Bill D N3886DCessna 182A · S/N 34586Built 1957 · Harper Shawn W N4649BCessna 180 · S/N 31547Built 1955 · Nicholson Stephen G N512PLCubcrafters CC11-160 · S/N CC11-00182Built 2011 · Longfellow Ellis A N56180Cessna 180 · S/N 32165Built 1955 · Gosney Don L N64199Cessna 172M · S/N 17265081Built 1975 · Mutschler George Robert Jr N711GSmith BIPLANE · S/N 5822-40Built 1968 · Johnson Harold V N733ZSCessna 172N · S/N 17268684Built 1977 · Mccown Jamey N81EStinson SR-8B · S/N 9815Built 1937 · Lunsford David R N8822TCessna 182C · S/N 52722Built 1960 · Morris Joshua N89673Cessna 140 · S/N 8721Built 1946 · Jensen Jake J

Back to Bayfield, CO