Skip to content

Registered aircraft · 121

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 ('2073450')
  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 ('2073450')
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.

N81ZHCarlsbad Raceway Corp · Hemet, CABuilt 1978 · S/N 21062541 N888PLDavis Brent · Forney, TXBuilt 1977 · S/N 21062395 N9032MWillke Theodore Lawrence II · Tacoma, WAS/N 21062052 N9036MChalk 2 Inc · Apple Valley, CABuilt 1977 · S/N 21062053 N9056MGlasscock David M · Matthews, NCBuilt 1977 · S/N 21062055 N9078MD R I Enterprises Ltd · Decatur, TXBuilt 1977 · S/N 21062060 N90WSShettle William M · Pocomoke City, MDBuilt 1976 · S/N 21061695 N9106MWeekley Marlin · Metamora, ILBuilt 1977 · S/N 21062062 N9144MRobertson James D · Liberty, MOBuilt 1977 · S/N 21062065 N917DDAir Serve LLC · Woodbine, NJBuilt 1977 · S/N 21061752 N930GGelazin Paul J · Palm Harbor, FLBuilt 1977 · S/N 21061866 N9444MTriple Four Mike LLC · Sand Springs, OKBuilt 1977 · S/N 21062076 N9464M2morrow Aviation LLC · Abilene, TXBuilt 1977 · S/N 21062079 N96CCInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 21062787 N9878HHatfield Derik · Mesa, AZBuilt 1978 · S/N 21062885 N9878MA&J Airsales Inc · San Antonio, TXBuilt 1977 · S/N 21062084 N9890MR & R Brown Inc · Sun Valley, IDBuilt 1977 · S/N 21062085 N9910MSatran Paul C · Detroit Lakes, MNBuilt 1977 · S/N 21062089 N9913MVillapudua Ruben Ruiz · Phoenix, AZBuilt 1977 · S/N 21062090 N99TMMagdabenja Holdings LLC · Corona, CABuilt 1977 · S/N 21061712 N99WGWilson Norman · Mount Pleasant, TXBuilt 1978 · S/N 210-62618

Back to Cessna 210M