Skip to content

Registered aircraft · 363

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

N1882YDunlap Alexander W · Eads, TNS/N 17249482 N1891YCarolina Sky LLC · Rock Hill, SCBuilt 1962 · S/N 17249491 N1892YBaker David Laurence · Nelson, WIS/N 17249492 N1893YWhelan John J · Mount Vision, NYBuilt 1962 · S/N 17249493 N1896YArmond Richard Joseph · Thousand Oaks, CABuilt 1962 · S/N 17249496 N2001YShaffer Stephen M · East Springfield, PABuilt 1962 · S/N 17249501 N2007YFoster Lemuel E · Vancouver, WABuilt 1962 · S/N 17249507 N2013YRoberts Michael R · Plano, TXBuilt 1962 · S/N 17249513 N2015YHoing Randal H Jr · Mexia, TXBuilt 1962 · S/N 17249515 N20188Creamer Rodger R · Venice, CABuilt 1961 · S/N 17248948 N2019YThuet Robert C · Spartanburg, SCBuilt 1962 · S/N 17249519 N2023YCassero Ronald V · Santa Rosa, CABuilt 1962 · S/N 17249523 N2025YMarine Resources Inc · Gilbert, AZS/N 17249525 N2027YBarnhouse Vicki L · Hurricane, WVBuilt 1962 · S/N 17249527 N2029YFox Matthew H · Stony Brook, NYBuilt 1962 · S/N 17249529 N2030YStetz Jeri Lynn · Pembroke Pines, FLBuilt 1962 · S/N 17249530 N2031YFluhrer Norman P · Mendocino, CABuilt 1962 · S/N 17249531 N2032YBellamy James S · East Canton, OHBuilt 1962 · S/N 17249532 N2034YKirk Petra · Phoenix, AZBuilt 1962 · S/N 17249534 N2037YArgos Retail LLC · Mcallen, TXBuilt 1962 · S/N 17249537 N2043YGrierson Robert A · Queen Creek, AZBuilt 1962 · S/N 17249543 N300KZDependable Aviation LLC · Cartersville, GABuilt 1961 · S/N 17248746 N3426ACarter Aaron T · Kasilof, AKBuilt 1961 · S/N 17248953 N4242CCas LLC Trustee · Ballinrobe Co MayoS/N 172-49187 N522TSFerraraccio Christopher M · Clarksville, TNBuilt 1961 · S/N 17248805 N62PBAlabama Fly Boys LLC · Cropwell, ALBuilt 1962 · S/N 17249273 N62WPCarver Joseph · Bryson City, NCBuilt 1962 · S/N 17249440 N672CCDmac Aircraft LLC · Savannah, GABuilt 1962 · S/N 17248796 N69MGArizona Active Air LLC · Yuma, AZBuilt 1962 · S/N 17249282 N7529U20 Awesome LLC · Albuquerque, NMBuilt 1962 · S/N 17248795 N757WKKuersteiner William C · Panacea, FLBuilt 1962 · S/N 17249290 N7682TPittsburgh Institute Of Aeronautics · West Mifflin, PAS/N 17249073 N8239XHess Dan A · Hastings, NEBuilt 1962 · S/N 17248739 N8241XRotormate LLC · Royse City, TXBuilt 1961 · S/N 17248741 N8242XSadique Said-Hesamadine · Fairfax, VAS/N 17248742 N8243XDemetreu Thomas J · Almond, NYBuilt 1961 · S/N 17248743 N8249XDish Technologies LLC · Elm City, NCBuilt 1961 · S/N 17248749 N8250XVolk Kenneth Lee · Marshall, TXBuilt 1961 · S/N 17248750 N8251XInman Charles E · Havre, MTBuilt 1961 · S/N 17248751 N8253XMasters Mission · Robbinsville, NCS/N 17248753 N8254XHd Security Systems Inc · Watertown, TNBuilt 1961 · S/N 17248754 N8255XFeik Robert · North Powder, ORS/N 17248755 N8257XGypsy Aero LLC · Darien Center, NYBuilt 1961 · S/N 17248757 N8262XBilton Nicholas J · Bozeman, MTBuilt 1961 · S/N 17248762 N8263XEarls Raymond W · Yucaipa, CAS/N 17248763 N8268XMarvin Ray · Tomahawk, WIBuilt 1961 · S/N 17248768 N8270XWarfield Brett Michael · Cypress, TXBuilt 1961 · S/N 17248770 N8271XSadowski Curtis D · Taylorville, ILBuilt 1961 · S/N 17248771 N8275XEvans C David II · Elkhart, INBuilt 1961 · S/N 17248775 N8278XDepew Gerald R · Oak Ridge, TNBuilt 1961 · S/N 17248778

Back to Cessna 172C