Skip to content

Registered aircraft · 432

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

N555VPClear Skies Flying Services LLC · Sun Prairie, WIBuilt 1969 · S/N 18259728 N572GSickles James D · Caledonia, NYBuilt 1969 · S/N 18259932 N57MJFrederick Bradley W · Corvallis, ORFirst renewal noticeBuilt 1969 · S/N 18259651 N5LSE&K Aero LLC · Friendswood, TXBuilt 1969 · S/N 18259862 N613WDCruse Josiah L · Rainier, ORBuilt 1969 · S/N 18259805 N63VTFlyways LLC · Bemidji, MNBuilt 1969 · S/N 18259760 N678WLanghoff John A · Yoakum, TXBuilt 1969 · S/N 18259757 N67WTHenderson Ronald W · Marietta, OHBuilt 1968 · S/N 18259488 N688JFCrothers Travis · Madison, MSBuilt 1968 · S/N 18259510 N690DMGabriel Louis R · Crestview, FLBuilt 1969 · S/N 18259626 N691KMMurray Karl A · Morriston, FLFirst renewal noticeBuilt 1968 · S/N 18259427 N6929Monsen Ronald · Naperville, ILBuilt 1969 · S/N 18259853 N693DADirect Action Aviation LLC · Reno, NVS/N 18259845 N694MMBrown Ryan W · Nampa, IDBuilt 1969 · S/N 18259874 N69UTAux N69ut LLC · Portland, TXBuilt 1968 · S/N 18259464 N69WKirby Mitchell E · Gualala, CABuilt 1968 · S/N 18259436 N7003KSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1969 · S/N 18259923 N70565Langworthy Peter B · Warrensburg, MOBuilt 1968 · S/N 18259306 N70566Twin Otter International Ltd · Las Vegas, NVBuilt 1968 · S/N 18259307 N70574Blue Sky Pilots Inc DBA · Salem, ORBuilt 1968 · S/N 18259310 N70582Goos Aviation LLC · Meridian, IDBuilt 1968 · S/N 18259312 N70591Fugleberg Richard H · Mayville, NDBuilt 1968 · S/N 18259315 N70607Walsh Dennis A · Dakota City, NEBuilt 1968 · S/N 18259323 N70609Gospel Ministries International · Mc Donald, TNBuilt 1968 · S/N 18259325 N70616Washburn Darlene J · Newberg, ORBuilt 1968 · S/N 18259326 N70617Mcnutt John W · Seattle, WABuilt 1968 · S/N 18259327 N70618Allen Steven P · Flagstaff, AZBuilt 1968 · S/N 18259328 N70625Resong Joseph J · Garden Grove, CABuilt 1968 · S/N 18259331 N70632Galion Air Inc · Galion, OHBuilt 1968 · S/N 18259332 N70633North County Flying Club · Tehachapi, CAFirst renewal noticeBuilt 1968 · S/N 18259333 N70634Sowry Myron E · Phillipsburg, OHBuilt 1968 · S/N 18259334 N70635Sitatunga Springs LLC · River Hills, WIBuilt 1968 · S/N 18259335 N70649Carroll Aviation Inc · Carroll, IABuilt 1968 · S/N 18259341 N70651Sale Reported · Lakewood, COSale reportedBuilt 1968 · S/N 18259342 N70655Kusterer James E Jr · Nampa, IDBuilt 1968 · S/N 18259343 N70657Cobra Kai Inc · Wichita Falls, TXBuilt 1968 · S/N 18259344 N70658Vroom David H · Oro Valley, AZBuilt 1968 · S/N 18259345 N70686Haase Douglas R · Manassas, VABuilt 1968 · S/N 18259356 N70688Roesner David A · Salina, KSBuilt 1968 · S/N 18259358 N70695Tucker Whitney L · Gove, KSBuilt 1968 · S/N 18259360 N70697Whalen Charles R · Gladewater, TXS/N 18259362 N70698Martin Kenneth R · Mill Creek, WABuilt 1968 · S/N 18259363 N70710Embyr November LLC · Gunnison, COBuilt 1968 · S/N 18259364 N70740Sierra Bravo Air LLC · Winston Salem, NCBuilt 1968 · S/N 18259365 N70778Engleman Aviation LLC · Comfort, TXBuilt 1968 · S/N 18259366 N70800Gangloff William A Jr · Frederick, MDS/N 18259367 N70802Brandvik Pipe & Equipment Inc · Borger, TXBuilt 1968 · S/N 18259369 N70804Fanning Fred W · Fairlawn, OHBuilt 1968 · S/N 18259370 N70809Inman Steve J · Billings, MTBuilt 1968 · S/N 18259373 N70816Proctor Keith · Paint Lick, KYS/N 18259378

Back to Cessna 182M