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.

N190DMMcintyre Donald F · Fort Gratiot, MIBuilt 1978 · S/N 18266049 N1927TZ And N 1927t LLC · Wapella, ILBuilt 1977 · S/N 182-65857 N1950VJenson Kenneth E · Modesto, CABuilt 1980 · S/N 182-67632 N197BZGlide Away LLC · Wilburton, OKBuilt 1979 · S/N 18267326 N197FTuin Brian A · Fort Worth, TXBuilt 1980 · S/N 18267671 N199RFBravo Charlie Global LLC · Kalispell, MTBuilt 1979 · S/N 18266816 N199RNWestern Flying Club Inc · Burlington, NCBuilt 1977 · S/N 18266079 N19AJBayshore Aircraft LLC · Miami, FLBuilt 1979 · S/N 18267286 N1YTOne Yankee Tango LLC · Jenks, OKBuilt 1978 · S/N 18266473 N200VVN200vv LLC · Pontiac, MIS/N 18267363 N202EPSonnenberg Jerry · Sterling, COBuilt 1980 · S/N 18267673 N203EPAlvarez Bernardo · Clayton PanamaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 18267546 N211AJLevisee Steve · Irvine, CABuilt 1977 · S/N 18265580 N211KCPau Hana LLC · Wilmington, DEBuilt 1977 · S/N 18265645 N212SWRarden Matthew W · Albuquerque, NMBuilt 1979 · S/N 18266842 N214DTBudicin Dominic A · Cedarpines Park, CABuilt 1979 · S/N 18266910 N214PJCabral Diogo Da Silva · New York, NYBuilt 1978 · S/N 18266080 N215RGGonzalez Rogiero A · San Antonio, TXBuilt 1979 · S/N 18266883 N217AMSeven Alpha Mike LLC · Fredericksburg, TXS/N 18267300 N21DFDose Gary W · Pinehurst, IDBuilt 1977 · S/N 18265789 N2217CSale Reported · Kerrville, TXSale reportedBuilt 1979 · S/N 18267230 N223RJCline Larry J · Beeville, TXBuilt 1979 · S/N 18266850 N224PTLee Mark W · Blaine, MNS/N 18265572 N225TXCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266946 N226ACTitle 46 LLC · Hamilton, MTBuilt 1979 · S/N 18267019 N2274KSantee Cooper Aviation Inc · Saint Matthews, SCBuilt 1978 · S/N 18266454 N228CPColumbia Pacific Aviation Inc · Moses Lake, WABuilt 1978 · S/N 18266514 N22WREz Enterprises LLC · Montrose, COS/N 18267626 N234PWRight Rudder LLC · Sapulpa, OKBuilt 1978 · S/N 18266103 N234THHalbur Lucas R · Omaha, NEBuilt 1978 · S/N 18266386 N235HLBeach Norman G Jr · Newman, CABuilt 1978 · S/N 18266526 N2379RLanzetta Kenneth · Oakland Park, FLBuilt 1979 · S/N 18266988 N2425CGiovanini Terry L · Bozeman, MTBuilt 1979 · S/N 18267471 N2433DDh Communications Inc · Blairsville, GABuilt 1979 · S/N 18266967 N246KWGenellie Gerald F Jr Trustee · Batavia, OHBuilt 1980 · S/N 18267659 N24FWatkins Brian · Los Alamos, NMS/N 18266495 N24VVWheels Up LLC · Land O Lakes, WIBuilt 1979 · S/N 18267131 N250GCCarroll James E Trustee · Newington, NHBuilt 1977 · S/N 18266130 N2511DDfs2024 LLC · Edwards, COBuilt 1979 · S/N 18266873 N252GSWyoming Seaplanes LLC · Alpine, WYBuilt 1976 · S/N 18265179 N257JSDelaurentis Robert · San Diego, CABuilt 1978 · S/N 18266090 N25ZZ25zz LLC · Abilene, TXS/N 18267202 N260PTPeterson Todd · El Dorado, KSBuilt 1977 · S/N 18265612 N260TGPickerel Enterprises LLC · Bennet, NES/N 18267521 N262GSMinor Michael D · Grove City, PAS/N 18265183 N263LPMarkman William J · The Dalles, ORS/N 18265959 N26GRLakeside Capital Holdings LLC · Green Cove Springs, FLBuilt 1980 · S/N 18267661 N272NSKroeber Thomas · Pawlet, VTBuilt 1980 · S/N 18267402 N279JSAnnapolis Aviation LLC · Annapolis, MDBuilt 1978 · S/N 18266499 N27AKLingle Bryan K Sr · Bradenton, FLBuilt 1979 · S/N 18266826

Back to Cessna 182Q