Skip to content

Registered aircraft · 101

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

N9639XFerguson John · Montrose, COS/N 21057939 N9645XCall The Ball Aviation LLC · Phoenix, AZS/N 21057945 N9646XKomko Randy M · Mckenna, WABuilt 1962 · S/N 21057946 N9648XWilt Michael J · Windham, NHBuilt 1962 · S/N 21057948 N9650XJorsey Elizabeth A · Reidsville, NCBuilt 1962 · S/N 21057950 N9653XSchuman Karl A · Fort Worth, TXBuilt 1962 · S/N 21057953 N9661XMangan Communications Inc · Bastrop, TXS/N 21057961 N9662XMacdonald Kaitlyn A · Dillon, MTS/N 21057962 N9665XBarclay Richard W · Elbert, COBuilt 1962 · S/N 21057965 N9667XBoschee Gary L · North Fort Myers, FLBuilt 1962 · S/N 21057967 N9672XPallister John S · Battle Ground, WABuilt 1962 · S/N 21057972 N9675XKenai Gravel Products LLC · Galena, AKFirst renewal noticeBuilt 1962 · S/N 21057975 N9676XMoore Samuel B · Tucson, AZBuilt 1962 · S/N 21057976 N9679XMurphree David A · Lake Saint Louis, MOBuilt 1963 · S/N 21057979 N967AEKreil Curtis L · White City, ORBuilt 1962 · S/N 21057978 N9681XCentral Aviation LLC · White City, ORS/N 21057981 N9683XBates Roger · Palm Beach Gardens, FLBuilt 1962 · S/N 21057983 N9686XMclenaghan Alvin N · Phoenix, AZBuilt 1962 · S/N 21057966 N9688XDrm Aviation LLC · Glencoe, ALBuilt 1962 · S/N 21057988 N9694XDawson Timothy E · Dahlonega, GAS/N 21057994 N9695XHam Robert · El Cajon, CABuilt 1962 · S/N 21057995 N9702XPilot Mountain Aviation LLC · Pilot Mountain, NCBuilt 1962 · S/N 21058002 N9703XSalsa De Tomate Inc · Craig, COS/N 21058003 N9706XEl Paso Aero Inc · El Paso, TXBuilt 1962 · S/N 21058006 N9714XEtheredge William T IV · Texas City, TXBuilt 1962 · S/N 21058014 N9716XLowe Joshua T · Mount Baldy, CAS/N 21058016 N9717XEichner David K · Portland, ORBuilt 1962 · S/N 21058017 N9718XLooney Jeffrey J · New Boston, TXBuilt 1962 · S/N 21058018 N9720XHogue Richard L · Dos Palos, CABuilt 1962 · S/N 21058020 N9722XEddy David A · Gilroy, CABuilt 1962 · S/N 21058022 N9723XThornton James P · Amesbury, MABuilt 1962 · S/N 21058023 N9725XNewling Galen J · Bremerton, WABuilt 1962 · S/N 21058025 N9730XHaase Herman · Stockton, CABuilt 1962 · S/N 21058030 N9731XPoe David A · Big Sandy, TXBuilt 1962 · S/N 21058031 N9735XPascal LLC · Des Moines, WAS/N 21058035 N9738XAdelman Timothy B · Stevensville, MDBuilt 1961 · S/N 21058038 N9741XHalbert Larry E · Jacksonville, FLBuilt 1961 · S/N 21058041 N9746XAgent West Insurance Inc · Hurricane, UTBuilt 1962 · S/N 21058046 N9749XNeal Daniel A · Winchester, TNBuilt 1962 · S/N 21058049 N9752XBirdman Aviation LLC · Indianapolis, INBuilt 1962 · S/N 21058052 N9758XHernandez Luis Ignacio · Naples, FLBuilt 1962 · S/N 21058058 N9759XFlorida Alarm & Security Technologies LLC · Merritt Island, FLBuilt 1962 · S/N 21058059 N9760XGubler Joseph A · Fairhaven, MABuilt 1962 · S/N 21058060 N9765XBaer Monte Wayne · Ronan, MTS/N 21058065 N9767XRohde Ronald L · Mariposa, CABuilt 1962 · S/N 21058067 N9769XEnos Miller · Rexford, MTS/N 21058069 N9770XGonzalez Brendan M · Mount Pleasant, IAS/N 21058070 N9777XKelner B Kelly · Bradley, ARBuilt 1962 · S/N 21058077 N9780XReid Bill · White Hills, AZS/N 21058080 N9781XCrouch Lee · Kansas City, MOBuilt 1962 · S/N 21058081

Back to Cessna 210B