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.

N93THAir Chief LLC · Granbury, TXBuilt 1977 · S/N 18265936 N941WMEggert Jonathan Albert · Keizer, ORS/N 18266420 N94303Nelson Ryan L · League City, TXBuilt 1978 · S/N 18266404 N94304Hamilton Francis D III · Olney, TXBuilt 1978 · S/N 18266405 N94328Gottschalk John R · Atwater, CABuilt 1978 · S/N 18266410 N94334Play For Today LLC · Michigan City, INBuilt 1978 · S/N 18266412 N94338Auto Action LLC · Peralta, NMBuilt 1978 · S/N 18266415 N9434594345 LLC · Ashaway, RIBuilt 1978 · S/N 18266417 N94359Jbm Enterprises LLC · Bristol, RIS/N 18266419 N94371Coppage Farm Services Inc · Braggadocio, MOBuilt 1978 · S/N 18266421 N94391Gall Michael R · Breckenridge, COBuilt 1978 · S/N 18266423 N944WBSchultz Jason G · Crowley, LABuilt 1979 · S/N 18266811 N94527Kamer Joseph P · Topeka, KSBuilt 1978 · S/N 18266428 N94529Clary Daryl · Moorestown, NJBuilt 1978 · S/N 18266430 N94531Cire Aviation LLC · Lutz, FLBuilt 1978 · S/N 18266431 N94536Freese Marc A · Fulda, MNBuilt 1978 · S/N 18266434 N94537Joyner Russell L · Aulander, NCBuilt 1978 · S/N 18266435 N94538Curran James · Santa Ana, CABuilt 1978 · S/N 18266436 N94539Woodward William R · Portland, ORBuilt 1978 · S/N 18266437 N94544Dawson Farms · Tappen, NDBuilt 1978 · S/N 18266439 N94549Scott Nathan A · Lake Winnebago, MOBuilt 1978 · S/N 18266443 N94587Kenny Douglas B · Auburn, NHBuilt 1978 · S/N 18266448 N94588Burt Lisa C · Justin, TXS/N 18266449 N94592Oklahoma State University · Stillwater, OKBuilt 1978 · S/N 18266452 N94596Koulbou Moussa A · Chandler, AZBuilt 1978 · S/N 18266455 N94598Klein Thomas Alan · North Pole, AKBuilt 1978 · S/N 18266457 N94599Ams Aviation LLC · South Bend, INBuilt 1978 · S/N 18266458 N94608Hansen David A · Milton Freewater, ORBuilt 1978 · S/N 18266459 N94619Fanning Fred W · Fairlawn, OHBuilt 1978 · S/N 18266463 N94623Watts Mark A · Medicine Lodge, KSBuilt 1978 · S/N 18266464 N94643Ashmore Mark D · Naples, IDBuilt 1978 · S/N 18266471 N94645Bozic Zeljko · San Pedro, CABuilt 1978 · S/N 18266472 N94651Patrick A Testerman · Maple Grove, MNBuilt 1978 · S/N 18266475 N94660Tweed Bradley Steven · Greeneville, TNBuilt 1978 · S/N 18266480 N94669Harvanek Brian R · Sarver, PABuilt 1978 · S/N 18266484 N94671Sky Jaunts LLC · Kalispell, MTBuilt 1978 · S/N 18266485 N94672Cls Contracting LLC · Eureka, MTFirst renewal noticeBuilt 1978 · S/N 18266486 N94673Glaze Roy J · Smyrna, TNBuilt 1978 · S/N 18266487 N94691Brentco Aerial Patrol Inc · Canton, OHBuilt 1978 · S/N 18266491 N94698Corsa Exotics Inc · South El Monte, CABuilt 1978 · S/N 18266492 N94709South Georgia Technical College · Americus, GABuilt 1978 · S/N 18266496 N94713Thompson Robert M · Nevada, MOBuilt 1978 · S/N 18266497 N94751Ishawooa Air LLC · Cody, WYBuilt 1978 · S/N 18266500 N94753Thornton Shawn Wayne · Cheyenne, WYBuilt 1978 · S/N 18266502 N94757Deters John Lloyd · Spring Grove, MNBuilt 1978 · S/N 18266504 N94772Kamal Rafi · Mountain View, CABuilt 1978 · S/N 18266507 N94800Trick Aviation LLC · Kalispell, MTBuilt 1978 · S/N 18266512 N94810Kaski Brian · Battle Ground, WABuilt 1978 · S/N 18266515 N94812James Hamilton Construction Co · Silver City, NMS/N 18266517 N94837Leyser Joshua F C · Tega Cay, SCS/N 18266521

Back to Cessna 182Q