Skip to content

Registered aircraft · 606

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

N258MEGolf Delta Charlie LLC · Baton Rouge, LABuilt 2000 · S/N 18280768 N26264Edb Air Inc · Wilsonville, ORBuilt 1998 · S/N 18280265 N265MESunset Leasing Inc · Sarasota, FLBuilt 2000 · S/N 18280771 N26613Coomes Thomas R · Hollis, OKBuilt 1998 · S/N 18280326 N26616Sea Wing LLC · Camarillo, CABuilt 1998 · S/N 18280329 N2662ARogers Construction Services Inc · Boca Raton, FLBuilt 1998 · S/N 18280331 N2662BGjl Aviation LLC · Fort Worth, TXBuilt 1998 · S/N 18280332 N2662FGarmin International Inc · Olathe, KSBuilt 1998 · S/N 18280337 N2662ZBidcal Inc · Chico, CABuilt 1998 · S/N 18280338 N2664UHill Flying Club Inc · St George, UTBuilt 1998 · S/N 18280298 N266MEGershman Randy · Marshfield, WIBuilt 2000 · S/N 18280772 N2672XBird Nest Aviation LLC · Sheldon, IABuilt 1998 · S/N 18280305 N267MECape Aero LLC · Cape Girardeau, MOBuilt 2000 · S/N 18280774 N2680XN2680x LLC · Mountain Home, ARBuilt 1998 · S/N 18280307 N2687LA R Preston Holdings LLC · Ontario, NYBuilt 1998 · S/N 18280314 N268MERegistered aircraftBuilt 2000 · S/N 18280776 N2698XHall Clinton Arthur Jr · Klamath Falls, ORBuilt 1998 · S/N 18280318 N26BMRegistered aircraftBuilt 1999 · S/N 18280659 N26WEGrand Aviation LLC · Asbury, NJBuilt 1998 · S/N 18280225 N271SPIndiana Department Of Administration · Greenwood, INBuilt 2000 · S/N 18280911 N27216Jjep Aviation LLC · Seattle, WABuilt 1998 · S/N 18280320 N2722FBowen Michael D DBA · Noblesville, INBuilt 1998 · S/N 18280352 N2724REcho Flight LLC · Tucson, AZBuilt 1998 · S/N 18280322 N2747RWilliams Dwight M · Paragould, ARS/N 18280343 N2748FWirth Gerald J Trustee · New Lenox, ILBuilt 1998 · S/N 18280345 N275PTTruss Travis D · Stephenville, TXBuilt 1997 · S/N 18280088 N277USCooper Robert · Sugar Grove, ILBuilt 2000 · S/N 18280894 N280CSYolo Farms LLC · Raleigh, MSBuilt 1999 · S/N 18280511 N282ESC282es LLC · Tampa, FLBuilt 1996 · S/N 18280002 N282MTMissig James M · Great River, NYBuilt 1997 · S/N 18280079 N283LPPecue Michael T · Mount Dora, FLBuilt 1998 · S/N 18280283 N285CVBarr Air Patrol LLC · Mesquite, TXBuilt 1997 · S/N 18280059 N285EASouth Carolina Forestry Commission · Columbia, SCBuilt 1999 · S/N 18280524 N292MAHot Tails LLC · Richmond, MOBuilt 1998 · S/N 18280174 N294MAWalker Leasing LLC · Browerville, MNBuilt 1998 · S/N 18280263 N300EPVan Anda Aviation LLC · Apopka, FLBuilt 2000 · S/N 18280903 N300WFAmoth Kurt J Trustee · White Salmon, WABuilt 1997 · S/N 18280015 N311AMBarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280403 N311HPOhio Department Of Public Safety · Columbus, OHS/N 18280919 N312RMSunny Days Prop Jox LLC · Niceville, FLBuilt 2000 · S/N 18280872 N313MAAbrams David · Holmdel, NJBuilt 1998 · S/N 18280238 N314FRHawkeye Helicopter LLC · Lyndon, KSBuilt 1998 · S/N 18280260 N31PLGorum Michael Wren · Red Lodge, MTBuilt 1998 · S/N 18280095 N321DKTwi Air LLC · Picayune, MSBuilt 1998 · S/N 18280311 N321GW321gw LLC · Chico, CABuilt 1998 · S/N 18280209 N321HWVan Andel Lambert J Jr · Coopersville, MIBuilt 1998 · S/N 18280264 N3261MDyas Chris · Fairhope, ALBuilt 1998 · S/N 18280347 N329MABarr Air Patrol LLC · Mesquite, TXBuilt 1998 · S/N 18280102 N330JDGreen Erik M · Mastic Beach, NYBuilt 1998 · S/N 18280267 N3314SN3314s LLC · Oklahoma City, OKBuilt 1998 · S/N 18280236

Back to Cessna 182S