Skip to content

Registered aircraft · 1,565

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

N735ZQDc Marketing LLC · Collierville, TNS/N 18265818 N735ZT3d Aircraft A California Corp · Simi Valley, CABuilt 1977 · S/N 18265821 N735ZVWilhelm James S · Tehachapi, CABuilt 1977 · S/N 18265823 N735ZWBarge And Associates Inc · Houston, TXBuilt 1977 · S/N 18265824 N735ZZSkidmark Landings LLC · Bozeman, MTBuilt 1977 · S/N 18265827 N7385SZia Air LLC · Hagerman, NMS/N 18265176 N738FRamp 106 LLC · Lynn Haven, FLBuilt 1979 · S/N 18266881 N7394SFourcher Fredric · Corona Del Mar, CABuilt 1976 · S/N 18265184 N7395SJamison Russell D · Quinter, KSBuilt 1976 · S/N 18265185 N7396SThomas James H Jr · Boulder, COBuilt 1976 · S/N 18265186 N7397SRaynor Rhett A · Dunn, NCBuilt 1976 · S/N 18265187 N7398SWilson Todd C · Camp Verde, AZS/N 18265188 N7412SClear Blue Aviation LLC · Hayden, IDBuilt 1976 · S/N 18265192 N7432SAnderson Jeffery G · Calhoun, LABuilt 1976 · S/N 18265194 N7457SDee Matt · Saint Petersburg, FLBuilt 1976 · S/N 18265195 N7462SG2 Aviation LLC · Dublin, GABuilt 1976 · S/N 18265196 N747UCTate Brian J · Perkasie, PABuilt 1977 · S/N 18265367 N74SMYellow Airplane LLC · Columbus, NEBuilt 1979 · S/N 18267216 N74TPN92341 LLC · Bonner, MTBuilt 1979 · S/N 18267156 N7551SMiller Luke · Enumclaw, WABuilt 1976 · S/N 18265200 N7553SFarrell David A · Milton, WIBuilt 1976 · S/N 18265202 N7554SHeard Charles R · Dothan, ALBuilt 1976 · S/N 18265203 N7556SReedm LLC · Little Rock, ARBuilt 1976 · S/N 18265205 N7557SBooher Travis J · Missoula, MTS/N 18265206 N7558SUbarri Luis M · Caguas, PRBuilt 1976 · S/N 18265207 N7559SSand John · Albany, MNBuilt 1976 · S/N 18265208 N755CCStik LLC · Batesville, ARBuilt 1976 · S/N 18265201 N755TGInverted Aviation LLC · Atascadero, CABuilt 1977 · S/N 18265666 N7561SQuality Fliers LLC · Kennewick, WABuilt 1976 · S/N 18265210 N7562SSnowridge LLC · Marysville, OHBuilt 1976 · S/N 18265211 N7563SRusso Robert A · Chicago, ILBuilt 1976 · S/N 18265212 N7565SExplore Air LLC · Kalispell, MTBuilt 1976 · S/N 18265214 N7566SK7 Air LLC · Blanding, UTBuilt 1976 · S/N 18265215 N7568SAero Plus LLC · Thermopolis, WYBuilt 1976 · S/N 18265217 N7569SEnginaires Aero Club Inc · Savoy, ILBuilt 1976 · S/N 18265218 N756PKBuoy Michael · Magnolia, TXBuilt 1977 · S/N 18266029 N7570SBurns Stephen M · Newport, ORBuilt 1976 · S/N 18265219 N7571SBeyond The Clouds LLC · Elkhorn, NEBuilt 1976 · S/N 18265220 N7573SHelley Mark R · Yuma, AZBuilt 1976 · S/N 18265222 N7574SBatavia Parag · Cranberry Township, PABuilt 1976 · S/N 18265223 N7577SBourbon Jeffrey A · Burns, KSBuilt 1976 · S/N 18265226 N7578SFly Cessna 182q N7578s LLC · Kalispell, MTBuilt 1976 · S/N 18265227 N7581SFoxaire LLC · Austin, MNBuilt 1976 · S/N 18265230 N7583SAir Anderson LLC · Dubuque, IABuilt 1976 · S/N 18265232 N7584SSanderson Jerome A · Fort Worth, TXBuilt 1976 · S/N 18265233 N7585SHayes John Martin · Mcalester, OKBuilt 1976 · S/N 18265234 N7587SWerner Matthew J · Shiner, TXS/N 18265236 N7590SMoody Gene M · Kingsport, TNBuilt 1976 · S/N 18265239 N7591SWildenberg Earl W · Menomonie, WIBuilt 1976 · S/N 18265240 N7592SJld Aero Inc · Dalton, GABuilt 1976 · S/N 18265241

Back to Cessna 182Q