Skip to content

Registered aircraft · 466

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

N100DBState Of Wisconsin · Madison, WIBuilt 1980 · S/N 21063970 N1011Martin Rex L Trustee · Bakersfield, CABuilt 1980 · S/N 21064004 N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174 N10HXIjh Farm Inc · Seminole, TXS/N 21063588 N110KMCars Planes And Land LLC · Fuquay Varina, NCBuilt 1983 · S/N 21064800 N111VFCottle John A DBA · Watsonville, CABuilt 1980 · S/N 21064005 N1123UTroy Investment Co 1 L P · Brownsville, TXBuilt 1982 · S/N 21064667 N1132UMjolhus Knut G · Amarillo, TXBuilt 1982 · S/N 21064669 N1178UWaco Diamond Star LLC · Niceville, FLS/N 21064671 N1199ULansford Inc · Clovis, NMBuilt 1982 · S/N 21064673 N123MCNelson Isaac · Saint Croix Falls, WIS/N 21063578 N1289UKavak Air Inc · Middletown, DEBuilt 1982 · S/N 21064682 N139BBTrejo Nahomy · Socorro, TXBuilt 1979 · S/N 21063712 N1410URuffcorn Aviation Co · Bettondorf, IABuilt 1982 · S/N 21064693 N1494CFour C'S Equipment Leasing LLC · Fresno, CABuilt 1978 · S/N 21063065 N155DGJuliet Tango Flying Services LLC · Walnut Creek, CABuilt 1983 · S/N 21064815 N155RCClark 155 LLC · Missoula, MTS/N 21064312 N15MWZeezee LLC · Phoenix, AZBuilt 1978 · S/N 21063023 N1625UFly2k LLC · San Jose, CABuilt 1982 · S/N 21064710 N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724 N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725 N16AXKing Austin · Abilene, TXBuilt 1980 · S/N 21064101 N16ZAVisser Johannes Christoffel · Reno, NVBuilt 1980 · S/N 21063807 N171BCR Wesley Aviation LLC · Chandler, AZBuilt 1981 · S/N 64251 N171TMG&L Aviation Services LLC · Las Vegas, NVBuilt 1980 · S/N 21063894 N1734UWing Nutz LLC · Pasadena, CABuilt 1982 · S/N 21064735 N1756URude Daniel R · Leesbug, VABuilt 1982 · S/N 21064739 N1782URbr Aircraft Inc · Albuquerque, NMS/N 21064744 N178RDHelicopter Consultants Inc · Union, WABuilt 1979 · S/N 21063445 N1968RCloud Transport Operations LLC · Albuquerque, NMS/N 21064375 N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705 N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921 N210AAMeckley Sean H · Seattle, WABuilt 1982 · S/N 21064690 N210AXKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1979 · S/N 21063033 N210BPBbsc LLC · Wilmington, DEBuilt 1981 · S/N 21064300 N210CCMuller Rodolfo · Kerrville, TXBuilt 1978 · S/N 21063008 N210CFQuest Aviation Inc · Lake City, FLBuilt 1978 · S/N 21063124 N210DRRaid Air LLC · Grand Rapids, MNBuilt 1978 · S/N 21063011 N210DSSevel Garry S · Fresno, CABuilt 1981 · S/N 21064275 N210HLFern Hill Aviation LLC · Lenoir City, TNBuilt 1979 · S/N 21063225 N210JMMustang Sally Aviation LLC · Camden, SCBuilt 1981 · S/N 21064159 N210KAKgs Aviation LLC · Staunton, VABuilt 1980 · S/N 21063902 N210KDContemporary Image Labeling Inc · Lebanon, OHBuilt 1981 · S/N 21064549 N210KUHirsch Teddy James Jr · Olney, TXS/N 21064142 N210LJValiair Limited Co Trustee · Casper, WYS/N 21063631 N210LTAlta Pump Co Inc · Reedley, CABuilt 1980 · S/N 21064535 N210MDAvmax Aviation LLC · Wilmington, DEBuilt 1984 · S/N 21064827 N210MPFranklin Robert · Castro Valley, CABuilt 1979 · S/N 21063193 N210MSDahl Gustave C · Washington, ILBuilt 1979 · S/N 21063411 N210MTWaistcat Aviation Inc · Mcallen, TXBuilt 1981 · S/N 21064165

Back to Cessna T210N