Skip to content

Registered aircraft · 123

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

N3967YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058467 N3968YDetray Michael S · Roy, WAFirst renewal noticeBuilt 1964 · S/N 21058468 N3969YCayce Dick Lon Jr · Longview, TXS/N 21058469 N3971YLimestone County Sheriff Dept · Athens, ALBuilt 1964 · S/N 21058471 N3976YKnutson Wayne R · Thompson, NDS/N 210-58476 N3979YMontana Adventures Holdings LLC · Rainbow City, ALS/N 21058479 N3983YMalpass William H DBA · Shreveport, LAS/N 21058483 N3989YSchmitt Rudy · Brookshire, TXBuilt 1964 · S/N 21058489 N3994YCrosco LLC · Canton, OHBuilt 1964 · S/N 21058494 N400HXTevis David James · Colorado Springs, COBuilt 1964 · S/N 21058352 N418DKKnies Aviation Inc · Huntsville, ALBuilt 1964 · S/N 21058435 N45AMThornburg Rocky R · White Hall, ARBuilt 1964 · S/N 21058475 N45VCHoyos Luis F · Fort Pierce, FLBuilt 1964 · S/N 21058282 N524BLDouble Lazy H LLC · Delta, COBuilt 1964 · S/N 21058477 N55CGWick James · Canon City, COBuilt 1964 · S/N 21058434 N63WSCooks Saw Manufacturing LLC · Newton, ALBuilt 1964 · S/N 21058333 N66BTTrazer LLC · Parkland, FLBuilt 1964 · S/N 21058437 N6990YV Speed Aviation LLC · Reno, NVBuilt 1964 · S/N 21058490 N7014ESkinner Norman D · Osceola, IABuilt 1964 · S/N 21058334 N777GTShillings Phillip J · Goldthwaite, TXS/N 21058339 N77ESRegistered aircraftBuilt 1964 · S/N 21058256 N78FWoods Joseph Lee · Gilbert, AZBuilt 1963 · S/N 21058258 N79THHudson Thomas · Bessemer, ALBuilt 1964 · S/N 21058329

Back to Cessna 210D