Skip to content

Registered aircraft · 234

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

N210JVCenturia LLC · Fort Lupton, COBuilt 1973 · S/N 21059850 N210LXColeman Daniel N · Phoenix, AZBuilt 1972 · S/N 21059720 N210NHMoore John R · Acworth, GABuilt 1972 · S/N 21059565 N210PZKmz Centurion LLC · San Mateo, CABuilt 1976 · S/N 21061268 N210RZKk Hangar LLC · Little Rock, ARBuilt 1971 · S/N 21059529 N210SWSierra Whiskey Aircraft LLC · Saint Louis, MOBuilt 1975 · S/N 21061068 N210ZPThaggard Aviation LLC · Leesburg, GABuilt 1975 · S/N 21060554 N2110S2f Trade LLC · Gainesville, TXBuilt 1975 · S/N 21061074 N212GBSooner Farms LLC · Siloam Springs, ARBuilt 1975 · S/N 21061130 N214GGilpin Sean F · Madison, ALBuilt 1976 · S/N 21061237 N2151SSd Aviation LLC · Syracuse, KSBuilt 1975 · S/N 21061112 N2157SSchlenker Wesley E · Dallas, TXBuilt 1975 · S/N 21061118 N2160SGalkin Edwin N Dmd · Edison, NJBuilt 1975 · S/N 21061121 N2170SAboveallphoto.Com Inc · Indianapolis, INS/N 21061131 N2177SFerkin Planes LLC · Caldwell, IDBuilt 1975 · S/N 21061138 N22202Gifford Gregory L · Naples, FLBuilt 1972 · S/N 21059717 N2220SSb Meridian LLC · Heber, CABuilt 1976 · S/N 21061165 N2226SE S P Aviation LLC · Wilmington, DEBuilt 1976 · S/N 21061171 N2228SHannaford Edward M · Roseville, MIBuilt 1976 · S/N 21061173 N2229SKey Lime Consultants LLC · Wilmington, DEBuilt 1976 · S/N 21061174 N222SJTriple Deuce LLC · Harrisonville, MOBuilt 1972 · S/N 21059732 N2233SRichardson Robert O · Spring Grove, ILBuilt 1976 · S/N 21061178 N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741 N2241SEdmondson James K · Lemoore, CABuilt 1976 · S/N 21061186 N2258SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 21061202 N2290SElco Avion LLC · Eagle Lake, TXBuilt 1976 · S/N 21061233 N22CVMcginley Donald J · Port Orange, FLBuilt 1973 · S/N 21059974 N22FBWilson Travis · Beaver Dam, KYS/N 21060634 N22NEEvmed LLC · Littleton, NCBuilt 1975 · S/N 21060908 N2390SPowerhawk Flyers LLC · Farmington Hills, MIBuilt 1976 · S/N 21061266 N23SFTarhanick Timothy P · Livonia, MIBuilt 1971 · S/N 21059547 N249SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 21060990 N24WWPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060884 N2506SByers Roger G · Lake Elmo, MNS/N 21061309 N254SWalker Curtis · Lake Havasu, AZS/N 21061198 N2550SGrewal Amritpal S · Stockton, CAS/N 21061326 N2563SClements Kenneth Brian · Las Vegas, NVBuilt 1976 · S/N 21061330 N2572SGwin Bryan · La Porte, TXBuilt 1976 · S/N 21061332 N2607SHunter Gary A · Fort Wayne, INBuilt 1976 · S/N 21061338 N2613SLow Wing Aviation LLC · Mountain Home, ARBuilt 1976 · S/N 21061340 N2667SMarcum Aviation Maintenance Services LLC · Galena, OHS/N 21061347 N26CRSim International Inc · Fort Mill, SCBuilt 1973 · S/N 21060084 N276ACSmith Air Inc · Ukiah, CABuilt 1976 · S/N 21061442 N29002E A B Services LLC · Cape Coral, FLBuilt 1972 · S/N 21059777 N29022Unifly Inc · Lackawanna, NYBuilt 1972 · S/N 21059783 N29209Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 21059832 N29278Pancho Moreno Y La Flaca LLC · Camuy, PRBuilt 1973 · S/N 21059852 N29359Cervantes Jose DBA · San Diego, CABuilt 1973 · S/N 21059858 N300EW2f Trade LLC · Collinsville, TXS/N 21061219 N30488Valiair Lc Trustee · Casper, WYS/N 21059924

Back to Cessna 210L