Skip to content

Registered aircraft · 74

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('2073416')
  ORDER BY 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 n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('2073416')
ORDER BY 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.

N4909UGarner Howard E · Bonifay, FLBuilt 1965 · S/N 21058609 N4910UN4910u LLC · Cushing, OKBuilt 1965 · S/N 21058610 N4913UGarvey F Patrick · Churubusco, INBuilt 1965 · S/N 21058613 N4914UCaldwell Gregg P · Desert Hot Springs, CABuilt 1965 · S/N 21058614 N4924UScheren Raymond D · Johnson, VTBuilt 1965 · S/N 21058624 N4927UBetz Brett A · Reminderville, OHBuilt 1965 · S/N 21058627 N4934USatriana Robert L · Belen, NMBuilt 1965 · S/N 21058634 N4942UCenturion LLC · Bonney Lake, WABuilt 1965 · S/N 21058642 N4948URegistered aircraftBuilt 1965 · S/N 21058648 N4960UHopkins Breck G · North Little Rock, ARBuilt 1965 · S/N 21058660 N4963UAllen Shanda · Aynor, SCBuilt 1965 · S/N 21058663 N4968UGreen Brandon K · Eufaula, ALBuilt 1965 · S/N 21058668 N4969UTallgrass Aviation LLC · Sharon Springs, KSBuilt 1965 · S/N 21058669 N4973UFlightpath Leasing LLC · Tallahassee, FLBuilt 1965 · S/N 21058673 N4976UMoro Jim · Naples, FLS/N 21058676 N4977UBaker Bryan D · Anderson, CABuilt 1965 · S/N 21058677 N4992UReynolds Tracy L · Midlothian, TXS/N 21058692 N4998USixty Five Two Ten LLC · Oak Island, NCBuilt 1965 · S/N 21058698 N526MPS Brown Inc · Durant, OKBuilt 1965 · S/N 21058630 N567DBGardner Law Firm Pllc · Shawnee, OKBuilt 1965 · S/N 21058689 N75YAHayes David M · Edgewood, TXBuilt 1965 · S/N 21058665 N906RSSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1965 · S/N 21058625 N95PYJayviation Inc · Lake City, FLBuilt 1964 · S/N 21058514 N990USimpson Reed · Marco Island, FLBuilt 1965 · S/N 21058690

Back to Cessna 210E