Skip to content

Registered aircraft · 722

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

N4311LRockin Robin Aviation LLC · Natchez, MSS/N 17254380 N4315LBeedle Jeremiah J H · Juneau, AKS/N 17254384 N4318LPhillips Matthew L · Las Cruces, NMBuilt 1966 · S/N 17254387 N4322LShastri Milind J · Seminole, FLBuilt 1966 · S/N 17254391 N4323LReed Darran K · Whitney, TXBuilt 1966 · S/N 17254392 N4324LMesa Aviation LLC · Alpine, TXBuilt 1966 · S/N 17254393 N4325LJ & F Aviation Adventure LLC · North Fort Myers, FLBuilt 1966 · S/N 17254394 N4329LHanson Randy J · North Branch, MNBuilt 1966 · S/N 17254398 N4331LOppegaard Craig E · Saint Louis Park, MNBuilt 1966 · S/N 17254400 N4333LDover Amanda · Littleton, NCBuilt 1966 · S/N 17254402 N4335LClifford Gary G · Titusville, FLBuilt 1966 · S/N 17254404 N4336LWiff Robert A · Tahuya, WABuilt 1966 · S/N 17254406 N4337LWirt James · Goldsby, OKBuilt 1966 · S/N 17254408 N4338LInsco Kay · Martin, TNBuilt 1966 · S/N 17254409 N4341LCut And Snip Flyers LLC · South Weber, UTBuilt 1966 · S/N 17254412 N4342LChenaille Lawrence A · Martinsville, INBuilt 1966 · S/N 17254413 N4343LDiamond C Aviation LLC · Gentry, ARBuilt 1966 · S/N 17254414 N4344LTorbett William H Jr · Stockbridge, GABuilt 1966 · S/N 17254415 N4347LChristiansen Steven P · Spokane, WAS/N 17254418 N43490Phillips Aviation LLC · Winnemucca, NVBuilt 1966 · S/N 17253653 N4351LWaggener James Franklin Jr · West Memphis, ARBuilt 1966 · S/N 17254424 N4358LMays John Anthony Sr · Cedar Hill, TXS/N 17254431 N4359LKoschara Nathaniel L · Geneseo, NYBuilt 1966 · S/N 17254433 N4361LFairbault Sky Club Inc · Waseca, MNBuilt 1966 · S/N 17254436 N4365LPriem Ben · Linwood, MIBuilt 1966 · S/N 17254440 N4370LAir North Flying Club · Malone, NYBuilt 1966 · S/N 17254447 N4371LPrisk Jack J · Pride, LABuilt 1966 · S/N 17254448 N4373LWilliams Matthew W · Fort Walton Beach, FLBuilt 1966 · S/N 17254450 N4378LRegistration Pending · Wentzville, MORegistration pendingBuilt 1966 · S/N 17254457 N4382LFielding Gregory J · Holland, MABuilt 1966 · S/N 17254461 N4383LHasman Robert B · Flushing, MIS/N 17254462 N4389LOdell John J · Salinas, CABuilt 1966 · S/N 17254470 N4390LAero Science International LLC · Martinez, GABuilt 1966 · S/N 17254471 N4391LVeness Matthew B Trustee · Fairborn, OHBuilt 1966 · S/N 17254472 N4394LR A Marsh Flying Club LLC · Williamson, GABuilt 1966 · S/N 17254475 N4396LDyer John F · Spring, TXBuilt 1966 · S/N 17254479 N4398LSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 17254481 N4399LEge Sidney J · Carlisle, PABuilt 1966 · S/N 17254482 N4401LWarbelows Air Ventures · Fairbanks, AKBuilt 1966 · S/N 17254484 N4402LClements Alex F Jr · Alamogordo, NMBuilt 1966 · S/N 17254485 N4405LKopcho Thomas L · York, NEBuilt 1966 · S/N 17254490 N4410LLenhart James A · Manchester, MIBuilt 1966 · S/N 17254495 N4416LBustamante Marcos H · Nogales, AZBuilt 1966 · S/N 17254503 N4418LIroquois Soaring Assn · Rome, NYBuilt 1966 · S/N 17254505 N4419LMil2atp Inc · Pikeville, NCBuilt 1966 · S/N 17254506 N441TSRawareo LLC · Warsaw, MOBuilt 1966 · S/N 17254288 N4420LMic Jack LLC · Stuart, FLFirst renewal noticeBuilt 1966 · S/N 17254507 N4421LSouthern Seaplane Inc · Belle Chasse, LAS/N 17254508 N4423LQuigley James J · Labelle, FLBuilt 1966 · S/N 17254512 N4424LTikiun Thaddeus J Jr · Bethel, AKBuilt 1966 · S/N 17254513

Back to Cessna 172G