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 = 'OK' AND g.registrant_city = 'CALERA' 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 = 'OK' AND g.registrant_city = 'CALERA'
  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 = 'OK' AND g.registrant_city = 'CALERA'
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.

N1067ZFarmer R B RBF5AJ · S/N 5Built 2002 · Raile Stanley L N126DRPiper PA-31-350 · S/N 31-7405173Built 1974 · Forbis Michael N13982Piper PA-23-250 · S/N 27-4600Built 1970 · Bray Aviation LLC N1570NBeech 58 · S/N TH-1715Built 1994 · Up N Down Adventures LLC N1954VCessna 172M · S/N 17263803Built 1974 · Bray Aviation LLC N399ESCessna 172R · S/N 17280155Built 1997 · Bray Aviation LLC N39WDDodd William J R AND D SPECIAL · S/N 106DBuilt 1984 · Williams Ryan P N4761CCessna 210N · S/N 21063617Built 1979 · Forbis Aviation LLC N4872UCessna 210-5A · S/N 205-0572Built 1964 · Bushwackers Leasing LLC N674VBeech 35-33 · S/N CD-106Bray Aviation LLC N6PYBeech 35-A33 · S/N CD-345Built 1962 · Golden Plane LLC N712VCessna 182P · S/N 18263162Built 1974 · Awf Aviation LLC N738WECessna 172N · S/N 17270288Built 1978 · Bray Aviation LLC N73966Bell 47G-2A-1 · S/N 2871Forbis Michael J N7551FPiper PA-32R-300 · S/N 32R-7780062Bushwackers Leasing LLC N8430RPiper PA-28-140 · S/N 28-22309Registration pendingBuilt 1966

Back to Calera, OK