Skip to content

Registered aircraft · 3,138

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

N49MQSgl Aviation LLC · Fairfield, NJBuilt 1976 · S/N 17267703 N49RZHappy Airplanes LLC · San Antonio, TXBuilt 1977 · S/N 17270001 N50067Prop Wash Aviation LLC · Hayward, WIS/N 17272811 N500TFPine Bluff Police Department · Pine Bluff, ARBuilt 1977 · S/N 17268711 N501MPManzoor Khan · Stockton, CABuilt 1978 · S/N 17270318 N5041EApm Leasing LLC · Casper, WYS/N 17271696 N5044EAviation Needs LLC · Stapleton, NEBuilt 1978 · S/N 17271698 N504JJEdwards William A · Midland, GABuilt 1979 · S/N 17273419 N50771Flying Mermaid LLC · Aiea, HIBuilt 1978 · S/N 17270862 N5082GJala Tech Services LLC · Social Circle, GABuilt 1979 · S/N 17273531 N5083KLoewen Wielhelm N · Presidio, TXBuilt 1980 · S/N 17273956 N5085KMartin Bach Aviation LLC · Cornelius, NCBuilt 1980 · S/N 17273957 N5086EPark David W · Placentia, CABuilt 1978 · S/N 17271703 N5087EDern Aviation · Lake Charles, LAS/N 17271704 N5087JSession Jason E · Higden, ARS/N 17273698 N5087KAir Capital Aviators Club · Wichita, KSBuilt 1980 · S/N 17273958 N5088KG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 17273959 N5089GFlywell Aviation LLC · Bowling Green, KYBuilt 1979 · S/N 17273538 N5089JWentzel Ron · Steamboat Springs, COBuilt 1979 · S/N 17273699 N5090EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271705 N5091EAmerican Asset Leasing LLC · Aurora, ORBuilt 1978 · S/N 17271706 N5092EKaye Russell G · New Fairfield, CTBuilt 1978 · S/N 17271707 N5093EBohmer Carla M · Tulsa, OKS/N 17271708 N5093KL A M Capital Management LLC · Sheridan, WYBuilt 1980 · S/N 17273964 N5096GRiya Aviation LLC · Tracy, CABuilt 1979 · S/N 17273545 N5097EBenedikt Craig A · Clayton, GABuilt 1978 · S/N 17271710 N5099KSaari Michael · Sycamore, ILBuilt 1980 · S/N 17273969 N5100EWatson Lloyd Marshall · Sublette, KSBuilt 1978 · S/N 17271713 N5100GAero Leasing LLC · Snohomish, WABuilt 1979 · S/N 17273548 N5102DB & R Aircraft LLC · Wadsworth, OHBuilt 1979 · S/N 17272422 N5102ECag Aircraft Holdings LLC · Crystal River, FLBuilt 1978 · S/N 17271714 N5108JHembree Ricky · Rockwall, TXBuilt 1980 · S/N 17273705 N510FAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1976 · S/N 17268470 N5113KParrillo Development And Real Estate LLC · Sarasota, FLBuilt 1979 · S/N 17272455 N5114KParrillo Development And Real Estate LLC · Moorestown, NJBuilt 1980 · S/N 17273974 N5115EBarak David T · Mountain Home, IDBuilt 1978 · S/N 17271717 N5116JCarll Elizabeth M · Chicago, ILBuilt 1979 · S/N 17273707 N5117EJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 17271719 N511GKAir Devices Company LLC · Alpena, MIBuilt 1978 · S/N 17270431 N5123EMiller Kenneth Allen · Riverhead, NYBuilt 1978 · S/N 17271722 N5123JCircle W Flying Club Inc · Creighton, PABuilt 1979 · S/N 17273709 N5124EHarris Russell Farrell · Chino Valley, AZBuilt 1978 · S/N 17271723 N5124JAbove And Beyond Aviation LLC · Austin, TXS/N 17273710 N5126EHouk Sean R · Lyons, OHBuilt 1978 · S/N 17271724 N5126GMag-Aero Inc · Harvard, ILBuilt 1979 · S/N 17273551 N5128DKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272430 N512TMSouthern Flight Aviation LLC · Bainbridge, GABuilt 1978 · S/N 17271721 N5130EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271725 N5131EBrunken Barry D · Tower Hill, ILBuilt 1978 · S/N 17271726 N5134KSunrise Aviation LLC · Gilbert, AZBuilt 1980 · S/N 17273979

Back to Cessna 172N