Skip to content

Registered aircraft · 31

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

N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247 N206TXBowler Ryan · Saint George, UTS/N P206-0228 N2669XSkydive Ricks LLC · Petersburg, OHBuilt 1965 · S/N P206-0169 N2674XKaiser Eric J · Milford, INBuilt 1966 · S/N P206-0174 N2677XHawk Jeff · Flowermound, TXBuilt 1965 · S/N P206-0177 N2678XStewart Jeffrey D · Snyder, TXBuilt 1965 · S/N P206-0178 N2681XZimmer Roy E Jr · Winter Park, FLBuilt 1965 · S/N P206-0181 N2690XWestern Nebraska Community College · Scottsbluff, NES/N P2060190 N2699XAir Controls Billings Inc · Billings, MTBuilt 1966 · S/N P206-0199 N4444TKinzie Industries LLC · Alva, OKBuilt 1966 · S/N P206-0290 N4605FSterling Aviation2 Lllc · Boca Raton, FLBuilt 1966 · S/N P206-0205 N4608FAdvanced Aerospace Consultants Inc · Boynton Beach, FLBuilt 1966 · S/N P206-0208 N4611FRandall Jason · Woodstock, ILBuilt 1966 · S/N P206-0211 N4626FKrumpe Brothers LLC · Hagerstown, MDBuilt 1966 · S/N P206-0226 N4629FCandler Richard A · Sharpsburg, GABuilt 1966 · S/N P206-0229 N4634FCardinal Air LLC · Wynantskill, NYBuilt 1966 · S/N P206-0234 N4638FSkydive Lake Tahoe LLC · Tahoe City, CABuilt 1966 · S/N P206-0238 N4640FDouglas Mark S DBA · Bellingham, WABuilt 1966 · S/N P206-0240 N4644FBrennan Timothy R Trustee · Mount Pleasant, SCBuilt 1966 · S/N P206-0244 N4648FSimmons Daniel A · Huntsville, ALBuilt 1966 · S/N P206-0248 N4656FCrowley Thomas Bannon III · Tigard, ORBuilt 1966 · S/N P206-0256 N4657FDoxsee Arthur B · Bennington, VTS/N P206-0257 N4658FSedrel Steven M · Sparks, NVBuilt 1966 · S/N P206-0258 N4672FWilmeth Roy · Frankston, TXBuilt 1966 · S/N P206-0272 N4673FCody Richard A · Mclean, VABuilt 1966 · S/N P206-0273 N4678FMullett Sean · Cleveland, TNBuilt 1966 · S/N P206-0278 N4681FFisher Adam · Corona, CABuilt 1966 · S/N P206-0281 N4685FRulewicz Dennis G · Jackson, MIBuilt 1966 · S/N P206-0285 N4699FStinson Ryan · Eagle, IDBuilt 1966 · S/N P206-0299 N4700FAssociated Equip Representatives Inc · Yakima, WABuilt 1966 · S/N P206-0300 N648DWDewhipet LLC · Sibley, LABuilt 1966 · S/N P206-0252

Back to Cessna P206A