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.

N96991Johnson Kirk · Klamath Falls, ORBuilt 1979 · S/N 18266928 N96CNNearburg Charles E · Creede, COBuilt 1979 · S/N 18266868 N96SJCavender Rick · Yorba Linda, CABuilt 1979 · S/N 18266888 N97004Yogi Air LLC · Medina, OHBuilt 1979 · S/N 18266932 N97007Tindle Robert Brian · Waco, TXBuilt 1979 · S/N 18266933 N97012Debourbon Michael · Pikeville, KYBuilt 1979 · S/N 18266935 N97018Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266936 N97021Bcks Aviation LLC · Kiefer, OKBuilt 1979 · S/N 18266938 N97024Alton Parts Supply Inc · Cottage Hills, ILS/N 18266941 N97041Paine Bruce G · Brainerd, MNBuilt 1979 · S/N 18266949 N97042Bid Systems LLC · Huntsville, ALBuilt 1979 · S/N 18266950 N97046Falcon Aviation Inc · Farmington Hills, MIS/N 18266952 N97049Tepper Jeremy A · Vail, AZS/N 18266954 N97051White Stephen M · Tempe, AZBuilt 1979 · S/N 18266955 N97052Atnip James L · Cody, WYBuilt 1979 · S/N 18266956 N97058Whizbang Flyers LLC · Houghton Lake, MIBuilt 1979 · S/N 18266958 N97071Heckathorn Chad W Trustee · Elk Point, SDBuilt 1979 · S/N 18266962 N97073Rodland Karin D · New Concord, OHBuilt 1979 · S/N 18266963 N97077Trail-Guides LLC · Sharpsburg, GAS/N 18266966 N97082N97082 LLC · Scottsdale, AZS/N 18266971 N97084Dockall Jesse A · Litchfield Park, AZBuilt 1979 · S/N 18266972 N97087Alpha Bravo LLC · Egan, LAS/N 18266973 N97096Lacy Clay · Groveland, CABuilt 1979 · S/N 18266976 N97097Youngman David A · Boca Raton, FLBuilt 1979 · S/N 18266977 N97099Northwoods Air LLC · Orono, MEBuilt 1979 · S/N 18266978 N97123Peak Investments LLC · Roanoke, VABuilt 1979 · S/N 18266984 N97127Sandquist Michael A · Molalla, ORBuilt 1979 · S/N 18266985 N97133Niner 7133 LLC · Layton, UTBuilt 1979 · S/N 18266987 N97146Silver City Aviation LLC · Sterling, KSBuilt 1979 · S/N 18266991 N97148Cullen Kevin · Bethesda, MDBuilt 1979 · S/N 18266992 N97156Skaglin Michael S · White Lake, MIBuilt 1979 · S/N 18266996 N97157Oliver Blake H · Talbotton, GABuilt 1979 · S/N 18266997 N97159Quetzal Aviation Corp · Washington, DCBuilt 1979 · S/N 18266999 N97160Foster Mark C Trustee · Carson City, NVBuilt 1979 · S/N 18267000 N97170Connor Catherine E · Morgantown, WVBuilt 1979 · S/N 18267002 N97178Meador Rita R · Eldorado, TXS/N 18267006 N97190Hickman Donald E II Trustee · Medford, ORBuilt 1979 · S/N 18267009 N97192Atlantis Construction Inc · Friday Harbor, WABuilt 1979 · S/N 18267010 N97196N2893e LLC · Reno, NVBuilt 1979 · S/N 18267011 N97199Perry Martin Dale · Denton, TXBuilt 1979 · S/N 18267012 N971RWSutherland James P · Wausau, WIS/N 18267004 N97200Aragon Cecilia · Sequim, WABuilt 1979 · S/N 18267013 N97211G & G 24 LLC · Clancy, MTS/N 18267015 N97218Mcgraw Thomas M II · Prescott, AZS/N 18267018 N97220Summit Crest Capital LLC · Palos Heights, ILS/N 18267020 N97221Smith Brian A · Big Pine Key, FLBuilt 1979 · S/N 18267021 N97231Pacific Rim Aviation LLC · Corvallis, ORBuilt 1979 · S/N 18267025 N97233Frahm Lon R · Colby, KSBuilt 1979 · S/N 18267026 N97237Headley Mark E · Akron, OHBuilt 1979 · S/N 18267028 N97238Sanctuary Wings LLC · Norfolk, VAS/N 18267029

Back to Cessna 182Q