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.

N9569TThomas Richard E · Lafayette, TNBuilt 1960 · S/N 57369 N9573TLearn To Fly LLC · Portal, GABuilt 1959 · S/N 57373 N9574TMcclellan Fred L · Flint, MIBuilt 1960 · S/N 57374 N9576TDe Vincenzo Chiara · Chicago, ILBuilt 1960 · S/N 57376 N9584TBruce Nicholson · Gallup, NMBuilt 1960 · S/N 57384 N9586TRegistration Pending · Talent, ORRegistration pendingS/N 57386 N9593TDenny Charles A · Wilmington, OHBuilt 1960 · S/N 57393 N9594TCooper Ventures LLC · Wesley, ARBuilt 1960 · S/N 57394 N9596TBrockie Robert Huntley · Bozeman, MTS/N 57396 N9597TMgm Home Service Inc · Atascadero, CAS/N 57397 N9599TAviation Partners LLC · Highlands Ranch, COBuilt 1960 · S/N 57399 N9604TKay Bennie L · Brigham City, UTBuilt 1961 · S/N 57404 N9610TMulkey Randall L · Wellston, OKBuilt 1960 · S/N 57410 N9613TMilleman Barry M · Monticello, INBuilt 1960 · S/N 57413 N9614TLucas Lester L · Napa, CABuilt 1960 · S/N 57414 N9621TJ D Kraemer Enterprises LLC · Fargo, NDS/N 57421 N9629TBramlett Russell · Winder, GABuilt 1960 · S/N 57429 N9630TBridgford Bruce H · Anaheim, CABuilt 1960 · S/N 57430 N9640TJohnson Joshua S · Lake Jackson, TXBuilt 1960 · S/N 57440 N9642TDavidow Clifford A · Portland, ORBuilt 1960 · S/N 57442 N9643TDunn Meghan Elizabeth · Mckinney, TXBuilt 1960 · S/N 57443 N9644TFloyd Andrew W · Mesa, AZBuilt 1960 · S/N 57444 N9661TSiebe James E · Moscow, IDBuilt 1960 · S/N 57461 N9664TKalebaugh Todd C · Lostine, ORBuilt 1960 · S/N 57464 N9665TFlight Tech Inc · Arlington, WAS/N 57465 N9668TSevier Brady · Ronan, MTBuilt 1960 · S/N 57468 N9683TFroes Carlos D · Avondale, AZFirst renewal noticeBuilt 1960 · S/N 57483 N9684TKobe Thomas J · Lake Placid, FLBuilt 1960 · S/N 57484 N9685TBas Part Sales LLC · Greeley, COBuilt 1960 · S/N 57485 N9687TPractical Software Solutions Inc · Windsor, COBuilt 1960 · S/N 57487 N9689TSutphen Clinton M · Saint Hedwig, TXBuilt 1960 · S/N 57489 N9692THarbaugh Eric M · Russell, KSS/N 57492 N9694TGarza Gilberto · Yuma, AZS/N 57494 N9696TJ & F Aviation Adventure LLC · North Fort Myers, FLBuilt 1960 · S/N 57496 N9699TBas Part Sales LLC · Greeley, COS/N 57499 N9720NNash Clay S · Irving, TXS/N 57036 N9762XMcdonald Daniel P · Canon City, COBuilt 1962 · S/N 21058062 N977RHHernandez Raul · San Antonio, TXS/N 57432

Back to Cessna 210