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.

N3824YMclaren Richard T · Sturbridge, MABuilt 1964 · S/N 21058324 N3827YPrentice Ronald L · Winchester, CABuilt 1964 · S/N 21058327 N3828YHall Edmond · Bremerton, WABuilt 1964 · S/N 21058328 N3830YRice Kevin L · Pleasant View, COBuilt 1964 · S/N 21058330 N3832YMtfg LLC · Hayden, IDS/N 21058332 N3835YCarlton Jeffery G · Great Falls, MTS/N 21058335 N3837YRounds Chris · Waller, TXBuilt 1964 · S/N 21058337 N3844YManarin Roland R · Lakemont, GABuilt 1964 · S/N 21058344 N3845Y1st Due Emergency Response Solutions LLC · Bartlett, KSS/N 21058345 N3847YLee Justin W · Maud, TXBuilt 1964 · S/N 21058347 N3850YPoole Vernon N · Melstone, MTBuilt 1964 · S/N 21058350 N3851YMckie-Voerste Travis K · Chatsworth, GABuilt 1964 · S/N 21058351 N3853YRafter Bar B LLC · Ashland City, TNBuilt 1964 · S/N 21058353 N3854YJames Wilson Smith Enterprises LLC · Athens, GABuilt 1964 · S/N 21058354 N3857YLutz Matthew B · Jackson, TNBuilt 1964 · S/N 21058357 N3859YMorse Donald W · Priest Lake, IDFirst renewal noticeS/N 21058359 N3861YMiller Todd D · Fort Wayne, INBuilt 1964 · S/N 21058361 N3866YMessina Jacob · Copley, OHBuilt 1964 · S/N 21058366 N3867YGallagher Robert B · Rio Oso, CABuilt 1964 · S/N 21058367 N3877YGonzo LLC · La Junta, COS/N 21058377 N3878YRegistered aircraftBuilt 1964 · S/N 21058378 N3880YLake Country Aviation LLC · Milledgeville, GABuilt 1964 · S/N 21058380 N3881YNorton Tim C · Danville, VABuilt 1964 · S/N 21058381 N3888YDodson Timothy A · Tulare, CABuilt 1964 · S/N 21058388 N3890YEllsworth Joseph D Trustee · Salida, COBuilt 1964 · S/N 21058390 N3891YCartwright Chris · Yuba City, CABuilt 1964 · S/N 21058391 N3897YHmw LLC · Wilmington, DEBuilt 1964 · S/N 21058397 N3901YCentruion Express LLC · North Port, FLS/N 21058401 N3904YOtto William R · Ontario, CABuilt 1964 · S/N 21058404 N3906YWildbur Mark B · Laramie, WYBuilt 1964 · S/N 21058406 N3907YAckley John · Brownsville, TXBuilt 1964 · S/N 21058407 N3916YMelagrano Jeffrey D · Scarsdale, NYBuilt 1964 · S/N 21058416 N3921YThompson Steven J · Royse City, TXBuilt 1964 · S/N 21058421 N3925YAbney Timothy D · Powell, OHS/N 21058425 N3927YMackenzie Stuart D · Pearland, TXBuilt 1964 · S/N 21058427 N3929YAinsworth Ryan · Portales, NMBuilt 1964 · S/N 21058429 N3942YBender Andrew J · Greenwood Lake, NYS/N 21058442 N3943YStuart Leslie Trustee · Roseburg, ORBuilt 1964 · S/N 21058443 N3944YBrown Pelican Aviation LLC · Ralston, NEBuilt 1964 · S/N 21058444 N3946YMorris Steven A · Houston, TXBuilt 1964 · S/N 21058446 N3947YRafter Jm Enterprises LLC · Swink, OKBuilt 1964 · S/N 21058447 N3948YSwine Management Service Inc · Long Island, KSBuilt 1964 · S/N 21058448 N3950YCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1964 · S/N 21058450 N3951YRodriguez Coppola Patricio Andres · New Orleans, LABuilt 1964 · S/N 21058451 N3954YStone Clifford F Jr · Corning, CABuilt 1964 · S/N 21058454 N3956YWilliams John S · Fort Walton Beach, FLBuilt 1964 · S/N 21058456 N3957YRegistration Pending · Midland, TXRegistration pendingBuilt 1964 · S/N 21058457 N3959YRabeneau Dale · Copperopolis, CABuilt 1964 · S/N 21058459 N3960YSeals Clinton F · Warren, ORBuilt 1964 · S/N 21058460 N3961YSmith Edward C · Lecompton, KSBuilt 1964 · S/N 21058461

Back to Cessna 210D