Skip to content

Registered aircraft · 2,099

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

N20793Bas Part Sales LLC · Greeley, COBuilt 1972 · S/N 18261209 N20797N20797 LLC · Odessa, FLBuilt 1972 · S/N 18261213 N20801Loveland Christopher K · Meridian, IDBuilt 1973 · S/N 18261216 N20803Goad Jimmy L · Bradford, ARBuilt 1972 · S/N 18261217 N20805Welzenbach Craig L · Fair Oaks Ranch, TXBuilt 1972 · S/N 18261219 N20806Young Todd Frederick · Pensacola, FLBuilt 1972 · S/N 18261220 N20820Maugeri Thomas V · Frankfort, NYBuilt 1972 · S/N 18261232 N20824Seven Hills Skydivers Inc · Madison, WIFirst renewal noticeBuilt 1972 · S/N 18261236 N20828Merrow R Loring · Beverly, MABuilt 1972 · S/N 18261238 N20831Olg Air LLC · Miami Gardens, FLS/N 18261239 N20832Wallace Fred · Ada, OKBuilt 1972 · S/N 18261240 N20836Morar Radu · Sutton, MABuilt 1972 · S/N 18261243 N20838Madden John D · Bellenue, WABuilt 1972 · S/N 18261245 N20841Fox Creek Aviation LLC · Jackson, WYBuilt 1972 · S/N 18261248 N20842Warner Kenneth G · Granbury, TXBuilt 1972 · S/N 18261249 N20845Clark Bradley D · Kirkwood, ILFirst renewal noticeS/N 18261252 N20852Spaulding Kenneth L · Sahuarita, AZBuilt 1972 · S/N 18261258 N20854Branson Bonanza Club · Branson, MOBuilt 1972 · S/N 18261260 N20855Mission Aviation LLC · Billings, MTBuilt 1972 · S/N 18261261 N20856Pointon Martin J · Snohomish, WABuilt 1972 · S/N 18261262 N20859Anderas Per R · Green Bay, WIS/N 18261264 N20862Barrington Aviation LLC · Kalamazoo, MIBuilt 1972 · S/N 18261267 N20870Willis David A · Thief River Falls, MNBuilt 1972 · S/N 18261274 N20877Teton Leasing LLC · Pocatello, IDBuilt 1972 · S/N 18261279 N2087FH & M Ltd · Warren, IDS/N 18264886 N20882Stuart Roger G Jr · Mount Pleasant, TXBuilt 1972 · S/N 18261283 N20888Baker Michael A · Watsonville, CABuilt 1972 · S/N 18261287 N20890Thomas Brett · Gettysburg, PABuilt 1972 · S/N 18261289 N20907Ward Roger L · Ghent, WVBuilt 1972 · S/N 18261345 N20914Jackson George F Jr · Saint Leonard, MDBuilt 1972 · S/N 18261294 N20920Berry Danny · Rusk, TXBuilt 1972 · S/N 18261295 N20923Langford Thomas R Jr · Mount Clare, WVBuilt 1972 · S/N 18261298 N20929Heinl Christopher · Hickory, NCBuilt 1972 · S/N 18261301 N20935White Mark · Cadiz, KYBuilt 1972 · S/N 18261306 N20936Nedbalek Brent · Brenham, TXS/N 18261307 N20944Moody Robert L · Ava, MOFirst renewal noticeBuilt 1972 · S/N 18261313 N20946Local News LLC · Janesville, WIBuilt 1972 · S/N 18261315 N20948Wallin Rolf B · Fayetteville, NCBuilt 1972 · S/N 18261316 N20955Dimich Milan C · La Jolla, CABuilt 1972 · S/N 18261320 N20962Fairmont Field LLC · Enid, OKBuilt 1972 · S/N 18261324 N20966Gibson Todd W · Madisonville, LABuilt 1972 · S/N 18261327 N20970Hitt James Randy · Blue Springs, MSBuilt 1972 · S/N 18261330 N20972Esmiol Matthew · Marlborough, CTBuilt 1972 · S/N 18261331 N20975American Union Printing Inc · Chino Valley, AZBuilt 1972 · S/N 18261333 N20976Kwolik Jordan M · Mckinney, TXBuilt 1972 · S/N 18261334 N20978Crosswinds Flying Club Inc · Oakland, MIBuilt 1972 · S/N 18261336 N20980White Duane A · Wappingers Falls, NYBuilt 1972 · S/N 18261337 N20986Skylane Flying Club Inc · Omaha, NEBuilt 1972 · S/N 18261342 N20CHRegistered aircraftBuilt 1974 · S/N 18263453 N20HBMontana Sky Aircraft LLC · Kalispell, MTS/N 18262945

Back to Cessna 182P