Skip to content

Registered aircraft · 465

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.

N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173 N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874 N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176 N5358UMadson Chris · King City, CABuilt 1984 · S/N 21064877 N5359APalo Duro Aircraft Services Lc · Mckinney, TXBuilt 1979 · S/N 21063388 N5362AFerguson Lynn D · Alpine, WYBuilt 1979 · S/N 21063391 N5368AValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 21063394 N5369YPollard William Edward · Big Spring, TXBuilt 1980 · S/N 21064185 N5383ASummers Timothy P · Rincon, GABuilt 1979 · S/N 21063405 N5386ATriplett And Adams Transport Partnership LLC · New Concord, OHBuilt 1979 · S/N 21063406 N5391ASingh Amandeep · Stockton, CABuilt 1979 · S/N 21063408 N5401AHeadon Richard · Chino Hills, CABuilt 1979 · S/N 21063414 N5409YLee Christopher · Katy, TXBuilt 1980 · S/N 21064198 N5416UU S Department Of Agriculture · College Station, TXBuilt 1984 · S/N 21064890 N5416YKer Holdings LLC · Henderson, NVBuilt 1980 · S/N 21064199 N5417YFeldner Mark A · Schererville, INBuilt 1980 · S/N 21064200 N5424AFudurich David E · Goleta, CABuilt 1979 · S/N 21063428 N5425AValiair Ltd Co Trustee · Casper, WYBuilt 1979 · S/N 21063429 N5426CVirginia Air Inc · Roanoke, VABuilt 1979 · S/N 21063749 N542CGulf States Financial Services · Lafayette, LAS/N 21063919 N542EBSvoboda Erik S · Mentor, OHBuilt 1981 · S/N 21064351 N5430AAdams Hay Farms LLC · Cedar City, UTBuilt 1979 · S/N 21063433 N5434ASteele Group Insurance Agency Inc · Eugene, ORBuilt 1979 · S/N 21063436 N5436UNewsom William Joel III · Roswell, GAS/N 21064892 N5439CLopez Hugo E · Mcallen, TXFirst renewal noticeBuilt 1979 · S/N 21063755 N543EMPacific Air Flight School LLC · Long Beach, CABuilt 1978 · S/N 21063054 N5456YWings As Eagles LLC · Wilmington, DES/N 21064211 N5467APiedmont Air Services LLC · Helena, MTBuilt 1979 · S/N 21063454 N5482CSantiago Robert S · Torrance, CABuilt 1979 · S/N 21063764 N5486ABas Part Sales LLC · Greeley, COS/N 21063464 N5490AN5490a LLC · Rutherfordton, NCBuilt 1979 · S/N 21063467 N5493AValley Dairy Farms Inc · Roy, WAS/N 21063469 N5495ARzs Enterprises Inc · Finley, NDBuilt 1979 · S/N 21063470 N54AKGreat Planes Reproductive Centers Pa · Circle Pines, MNBuilt 1981 · S/N 21064473 N54DZMcdonald Donald F · Greer, SCBuilt 1983 · S/N 21064820 N550MTLiving Sky Grains LLC · Three Forks, MTBuilt 1982 · S/N 21064580 N5511CDss Consulting LLC · Omaha, NEBuilt 1979 · S/N 21063772 N5516CCarson Kirk · Dalhart, TXBuilt 1979 · S/N 21063774 N5517UKoegel John C · Flint, MIBuilt 1984 · S/N 21064897 N5523YSimmons Scott · Anchorage, AKBuilt 1981 · S/N 21064236 N5528AWarden Hutterian Brethren · Warden, WAS/N 21063482 N5531ASouther Field Aviation Inc · Americus, GAS/N 21063484 N5537CM G Aviation · Tyler, TXBuilt 1979 · S/N 21063785 N5538YTeton View Aircraft Leasing LLC · Grass Valley, CABuilt 1981 · S/N 21064241 N5549AGeoterra Inc · Eugene, ORBuilt 1979 · S/N 21063491 N5550YSteiner Paul R · Boerne, TXBuilt 1981 · S/N 21064245 N555SKJld Resources Management LLC · Helena, MTBuilt 1982 · S/N 21064728 N559TTMcdonald Aviation Mgt LLC · San Jose, CABuilt 1979 · S/N 21063335 N55RXJs Enterprises LLC · Clarinda, IABuilt 1981 · S/N 21064586 N58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 21063920

Back to Cessna T210N