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.

N4801GFrederick Aero Development Inc · Murrieta, CAS/N 17273349 N4802GSky Warrior Flight Training LLC · Pensacola, FLS/N 17273350 N4803GAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1979 · S/N 17273351 N4804EPrestar Inc · Davis, CABuilt 1978 · S/N 17271665 N4805GTidewater Flying Club Inc · Newport News, VABuilt 1979 · S/N 17273353 N4806GStone Howard L · Pine Mountain, GABuilt 1979 · S/N 17273354 N4807DRussell Matthew D · Chattaroy, WAS/N 17272363 N4807GAdnd LLC · New Ipswich, NHBuilt 1979 · S/N 17273355 N4807JNew England Aviation LLC · Plainville, CTBuilt 1979 · S/N 17273680 N4808DLmnb LLC · Centreville, VABuilt 1979 · S/N 17272364 N4808FYankee Flying Club Inc · Maple Grove, MNBuilt 1979 · S/N 17273084 N4808GClub Aero Inc · Grand Rapids, OHS/N 17273356 N4810GAndrecheck Cynthia R · Bethel, AKBuilt 1979 · S/N 17273358 N4811GPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1979 · S/N 17273359 N4811JSeals Kenneth P · Munford, ALBuilt 1979 · S/N 17273681 N4813GBasso Michele · Millbrook, ALBuilt 1979 · S/N 17273361 N4814DAir Puerto Rico Corp · Aguadilla, PRBuilt 1979 · S/N 17272366 N4818DBald Eagle Flying Club · South Portland, MEBuilt 1979 · S/N 17272367 N4819GVeer Aviation Tx LLC · Houston, TXBuilt 1979 · S/N 17273367 N4820DBledsoe Duane C · Glendale, AZBuilt 1979 · S/N 17272369 N4820GAckerman Garry · Plano, TXBuilt 1979 · S/N 17273368 N4822GHighpoint Strategies LLC · Cypress, TXBuilt 1979 · S/N 17273370 N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372 N4829GSoaring Raven LLC · Seattle, WABuilt 1979 · S/N 17273377 N482EHb Coco & Company · Gonzales, TXBuilt 1979 · S/N 17272338 N4830GHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1979 · S/N 17273378 N4834ESweeney Michael J · Seattle, WABuilt 1978 · S/N 17271670 N4835GFiedler Aviation LLC · Suffolk, VABuilt 1979 · S/N 17273383 N4836GEvolo Aviation LLC · Worthington, OHBuilt 1979 · S/N 17273384 N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386 N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688 N4841DDoorglobe Inc · San Francisco, CABuilt 1979 · S/N 17272371 N4844FKnightair Enterprises LLC · Caro, MIFirst renewal noticeBuilt 1979 · S/N 17273088 N4844JSkoglun Eric W · Cashmere, WABuilt 1979 · S/N 17273684 N4845GNation Linda S · Sanford, FLBuilt 1979 · S/N 17273392 N4845JL&J Aviation Inc · Atwater, CABuilt 1979 · S/N 17273685 N4846GNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1979 · S/N 17273393 N4847GFlying Daze · Batavia, OHBuilt 1979 · S/N 17273394 N4849DN4849d LLC · North Logan, UTBuilt 1979 · S/N 17272372 N4850GPeters Walter C · Rockford, ILBuilt 1979 · S/N 17273397 N4851GEye Candy Aviation LLC · Jacksonville, FLBuilt 1979 · S/N 17273398 N4852GR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17273399 N4854GMilwaukee Aero LLC · Milwaukee, WIBuilt 1979 · S/N 17273401 N4855GWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 17273402 N4856DOlsen Ernest D · Lino Lakes, MNBuilt 1979 · S/N 17272374 N4856GNatchez Flight Training LLC · Natchez, MSBuilt 1979 · S/N 17273403 N4857GVero Technical Support Inc · Pensacola, FLS/N 17273404 N4859FRidgway Stephen · Avon, COBuilt 1979 · S/N 17273089 N4859GAirgo Inc · Centralia, ILBuilt 1979 · S/N 17273406 N485SBLyddon Aero Center Inc · Liberal, KSBuilt 1978 · S/N 17271485

Back to Cessna 172N