Skip to content

Registered aircraft · 188

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

N100BMarshall Xavier T · Carson, CAS/N 57114 N1024Calgonaire LLC · Seminole, TXS/N 57425 N12WDHamburg Jeffrey · Corsica, SDS/N 57480 N141DMTurbo Inc · Flint, MIBuilt 1977 · S/N 21061806 N198PBolski Dariusz · Rancho Cordova, CABuilt 1960 · S/N 57319 N198RPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 210-61063 N200NMOrr Leroy A · Tonasket, WABuilt 1960 · S/N 57271 N205NBAirmotive Service LLC · Brigham City, UTBuilt 1962 · S/N 205-0151 N210AKMaxinkuckee Aviation LLC · Columbus, INS/N 21061627 N210JRSouthard Robert W · Elk City, OKBuilt 1959 · S/N 57017 N210KCFluid Media Inc · Moscow, IDS/N 21061595 N210PRShaw Ronald V · Edmond, OKS/N 64883 N210RRBeasley Emmett C · Bixby, OKBuilt 1960 · S/N 57503 N210WKCorrado Christopher · Newton, NJBuilt 1960 · S/N 57088 N210YYApr Aviation · Fresno, CABuilt 1960 · S/N 57408 N227DKirkland Daniel · Kingman, AZBuilt 1976 · S/N 21061540 N2300PNess Dana E · Chester, MTS/N 21057746 N240MMFlood Specialists Group Inc · Des Plaines, ILBuilt 1960 · S/N 57168 N241DAMonard Larry R · Anadarko, OKBuilt 1960 · S/N 57563 N24KWright Douglas J · Greenwood, INBuilt 1960 · S/N 57265 N25JCAvg LLC · Chico, CABuilt 1959 · S/N 57008 N321CHSmith James Christian · Rockport, TXBuilt 1962 · S/N 21058061 N344KVLutz Gregory J · East Bridgewater, MABuilt 1960 · S/N 57470 N3603YCarter Duane Lee · Madison, GABuilt 1962 · S/N 21058103 N3740YOmg Air LLC · Okeechobee, FLBuilt 1964 · S/N 21058240 N3825YAtlas Mining & Mechancial Inc · Beryl, UTBuilt 1964 · S/N 21058325 N408GHMcdowell Kevin A · Tumwater, WABuilt 1959 · S/N 57075 N455EDTurner James Glenn · Naples, FLBuilt 1962 · S/N 21058118 N4567FPatterson Roland O · Semmes, ALBuilt 1960 · S/N 57314 N467DHLopez Floyd W · Arroyo Seco, NMBuilt 1960 · S/N 57142 N4702WFour Flying Fools LLC · Geneva, FLS/N 57532 N48PMFreeman Robert G DBA · Baker, FLBuilt 1960 · S/N 57567 N4BEMehrer Kelly · Apex, NCBuilt 1960 · S/N 57332 N522LNomura Christopher · Riverside, CABuilt 1960 · S/N 57516 N6394BPepitone David D · Santa Fe, NMS/N 57459 N6501XFisher John P · Surprise, AZBuilt 1960 · S/N 57501 N6506XBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57506 N6507XBailey Scott D · Ione, CABuilt 1960 · S/N 57507 N6510XSteinbroner Daniel J · Lawton, OKBuilt 1960 · S/N 57510 N6515XDauenhauer Steven M · Springtown, TXBuilt 1960 · S/N 57515 N6519XN5746u LLC · Dover, DEBuilt 1960 · S/N 57519 N6520XKenton Onstad · Parshall, NDBuilt 1960 · S/N 57520 N6521XNelson Scott W · Summerset, SDBuilt 1960 · S/N 57521 N6529XOvando Jorge · Sherman Oaks, CABuilt 1960 · S/N 57529 N6531XSchwartz Alan M · Hurleyville, NYBuilt 1960 · S/N 57531 N6538XRegistration Pending · Fallon, NVRegistration pendingBuilt 1960 · S/N 57538 N6544XAnderson Joseph · Tillamook, ORBuilt 1960 · S/N 57544 N6545XTail Chaser LLC · Wilmington, DEBuilt 1960 · S/N 57545 N6548XGardner Maureice E · Garden City, KSS/N 57548 N6550XButterfield Rory A · Milan, NMBuilt 1960 · S/N 57550

Back to Cessna 210