Skip to content

Registered aircraft · 411

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

N42251Ada Forestry Division · Malvern, ARBuilt 1968 · S/N 18258926 N42261Shenandoah Skies LLC · Harrisonburg, VABuilt 1968 · S/N 18258930 N42262R And E Aviation LLC · Laurel, MSBuilt 1968 · S/N 18258931 N42267Eischens William L · Alexandria, VABuilt 1968 · S/N 18258934 N42275Nelson Frank H · Tuscaloosa, ALBuilt 1968 · S/N 18258937 N42278Clear Sky Holdings Ltd Co LLC · Boiling Springs, SCS/N 18258939 N42279Keller Mark D · Ellensburg, WABuilt 1968 · S/N 18258940 N42280Altitude Addiction LLC · Harker Heights, TXBuilt 1968 · S/N 18258941 N42285Clemenson Christopher James · West Fargo, NDBuilt 1968 · S/N 18258944 N4228742287 LLC · Kettle Falls, WABuilt 1968 · S/N 18258945 N42291Palmer Don W · Penhook, VABuilt 1968 · S/N 18258946 N42293N42293 LLC · Hillsboro, ORBuilt 1968 · S/N 18258948 N42295Kcsi Aerial Patrol Inc · Bakersfield, CABuilt 1968 · S/N 18258950 N42296Robinson Fredrick J · Morris, ILBuilt 1968 · S/N 18258951 N42300James Douglas M Trustee · Scottsdale, AZBuilt 1968 · S/N 18258952 N42304Ratcliff John · Rincon, GABuilt 1968 · S/N 18258954 N42306Wright Nolene L Trustee · Wright, WYBuilt 1968 · S/N 18258956 N42311Murphy Kenneth E · Pahrump, NVBuilt 1968 · S/N 18258959 N42313Altitude Enterprises LLC · Omaha, NEBuilt 1968 · S/N 18258961 N42314Mackenzie Jeffrey S · Woodland, MIBuilt 1968 · S/N 18258962 N42317Meyers Brad C · Reno, TXBuilt 1968 · S/N 18258963 N42323Gardiner Russell J · Phoenix, AZS/N 18258965 N42325Henry Nolan T · Ashland, ORS/N 18258967 N42326Hooper James Carl · Webster, MNBuilt 1968 · S/N 18258968 N42328High Tony W · Walters, OKBuilt 1968 · S/N 18258969 N42335Gubernat John F Jr · Pepperell, MABuilt 1968 · S/N 18258971 N42349Skylane 49 LLC · Glenwood Springs, COBuilt 1968 · S/N 18258976 N42364Smathers Geoffrey R · Mars, PABuilt 1968 · S/N 18258986 N42368Madson Chris J · King City, CABuilt 1968 · S/N 18258988 N42369Hecker Darin · Grants Pass, ORBuilt 1968 · S/N 18258989 N42371Optum Sun LLC · Laguna Hills, CAS/N 18258990 N42379Wh Land Holdings LLC · Kirbyville, TXBuilt 1968 · S/N 18258996 N42380Payne Patricia C · Spokane, WABuilt 1968 · S/N 18258997 N42381Anthony David W · Wasilla, AKFirst renewal noticeS/N 18258998 N42382Nb Services LLC · Sumrall, MSBuilt 1968 · S/N 18258999 N42387Bernau Jeff A · Kalispell, MTS/N 18259000 N42397Brissey Forrest L · Woodinville, WABuilt 1968 · S/N 18259003 N42400Smith Randolph L · Orovada, NVBuilt 1968 · S/N 18259004 N42409Ross Leslie W · Truckee, CAS/N 18259006 N42421Registered aircraftBuilt 1968 · S/N 18259011 N42424Bowyer Charles W Stephen · Tucson, AZBuilt 1968 · S/N 18259013 N42428Hantzsche Jackson R · Wellington, NVBuilt 1968 · S/N 18259014 N42441Grizard Diane M · Simi Valley, CABuilt 1968 · S/N 18259018 N42460Leofsky Richard J · Willis, TXBuilt 1968 · S/N 18259024 N42461Eurice Brian R · Bradenton, FLBuilt 1968 · S/N 18259025 N42465Nadalin David D · North Fort Myers, FLBuilt 1968 · S/N 18259027 N42471Livestock Innovations Inc · Easton, MNBuilt 1968 · S/N 18259030 N42482Dancing Bear Market Inc · Fresno, CABuilt 1968 · S/N 18259033 N42484Hiemstra Ralph W · Sonora, CAS/N 18259035 N42485Kaiser Enterprises Inc · Carrollton, MOBuilt 1968 · S/N 18259036

Back to Cessna 182L