OpenAirDocs.org
Federal Aviation Administration

Registered aircraft · 31

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
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_name = 'FEDERAL AVIATION ADMINISTRATION' OR list_contains(g.other_registrant_names, 'FEDERAL AVIATION ADMINISTRATION')
  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.

N11Hawker Beechcraft C90GTI · S/N LJ-1964Built 2009 · Oklahoma City, OKN12Hawker Beechcraft C90GTI · S/N LJ-1966Built 2009 · Oklahoma City, OKN13Hawker Beechcraft C90GTI · S/N LJ-1968Built 2009 · Oklahoma City, OKN14Hawker Beechcraft C90GTI · S/N LJ-1972Built 2009 · Oklahoma City, OKN16Hawker Beechcraft C90GTI · S/N LJ-1994Built 2010 · Oklahoma City, OKN17Hawker Beechcraft C90GTI · S/N LJ-2052Built 2012 · Oklahoma City, OKN34Douglas DC3C 1830-94 · S/N 33359Built 1945 · Oklahoma City, OKN48Textron B300 · S/N FL-1347Built 2024 · Oklahoa City, OKN66Beech 300 · S/N FF-1Built 1987 · Oklahoma City, OKN67Beech 300 · S/N FF-2Built 1987 · Oklahoma City, OKN68Beech 300 · S/N FF-3Built 1988 · Oklahoma City, OKN69Beech 300 · S/N FF-4Built 1988 · Oklahoma City, OKN70Beech 300 · S/N FF-5Built 1988 · Oklahoma City, OKN71Beech 300 · S/N FF-6Built 1988 · Oklahoma City, OKN72Beech 300 · S/N FF-7Built 1988 · Oklahoma City, OKN73Beech 300 · S/N FF-8Built 1988 · Oklahoma City, OKN75Beech 300 · S/N FF-10Built 1988 · Oklahoma City, OKN76Beech 300 · S/N FF-11Built 1988 · Oklahoma City, OKN77Beech 300 · S/N FF-12Built 1988 · Oklahoma City, OKN78Beech 300 · S/N FF-13Built 1988 · Oklahoma City, OKN79Beech 300 · S/N FF-14Built 1988 · Oklahoma City, OKN80Beech 300 · S/N FF-15Built 1988 · Oklahoma City, OKN81Beech 300 · S/N FF-16Built 1988 · Oklahoma City, OKN83Beech 300 · S/N FF-18Built 1988 · Oklahoma City, OKN84Beech 300 · S/N FF-19Built 1988 · Oklahoma City, OKN89Bombardier CL-600-2B16 · S/N 5815Built 2009 · Oklahoma City, OKN90Bombardier CL-600-2B16 · S/N 5817Built 2009 · Oklahoma City, OKN91Bombardier CL-600-2B16 · S/N 5793Built 2009 · Oklahoma City, OKN92Bombardier CL-600-2B16 · S/N 5780Built 2008 · Oklahoma City, OKN94Bombardier CL-600-2B16 · S/N 5855Built 2010 · Oklahoma City, OKN95Bombardier CL-600-2B16 · S/N 5827Built 2010 · Oklahoma City, OK
Back to Federal Aviation Administration