Skip to content

Registered aircraft · 1,805

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

N6489EDupuis Normand G · Berlin, NHBuilt 1959 · S/N 46589 N6490BPontoni Peter D · Athens, MIBuilt 1957 · S/N 29690 N6491EToepfer Kendra · BielefeldBuilt 1959 · S/N 46591 N6493BBoyd Ryan D · Stockton, CABuilt 1956 · S/N 29693 N6495BSanford George W Jr · Montross, VABuilt 1957 · S/N 29695 N6496BStartup Aviation Management LLC · Lakeway, TXBuilt 1957 · S/N 29696 N6497BVeve Rafael A · Indn Hbr Bch, FLBuilt 1957 · S/N 29697 N6498BDunlap Paul C Jr · Rock Island, TNBuilt 1956 · S/N 29698 N6498ECallender Roy A Jr · Ennis, TXBuilt 1959 · S/N 46598 N6499BMoore Thomas W · Zimmerman, MNFirst renewal noticeBuilt 1957 · S/N 29699 N6499EAzevedo Manuel J · Modesto, CABuilt 1959 · S/N 46599 N6603AWise Phillip L · Harris, MOBuilt 1956 · S/N 28703 N6604AFlight Club LLC · Dover, DEBuilt 1956 · S/N 28704 N6605AKehoe Troy D · Bridgeport, TXBuilt 1956 · S/N 28705 N6606AMckenna Terence M · Scotts Valley, CABuilt 1956 · S/N 28706 N6607AOlson Duane C · Columbus, KSBuilt 1956 · S/N 28707 N6608AMarquardt Ashley F · Anchorage, AKBuilt 1956 · S/N 28708 N6609APelon Robert C · Chugiak, AKBuilt 1956 · S/N 28709 N6610AAccurso Jacob · Siletz, ORBuilt 1956 · S/N 28710 N6612AMazac Kennith M · River Falls, WIBuilt 1956 · S/N 28712 N6614AHanks Mitchell L · Carthage, ILS/N 28714 N6619ATest Jeffrey T · Port Charlotte, FLBuilt 1956 · S/N 28719 N6620AAviation Services Of Tn Inc · Sparta, TNS/N 28720 N6623APardo Lawrence A · Tucson, AZBuilt 1956 · S/N 28723 N6626AKrystofiak Steven · Scottsdale, AZS/N 28726 N6627AMcgowan Dan J · Springville, CABuilt 1956 · S/N 28727 N6628AJohnson Steve D · Oklahoma City, OKFirst renewal noticeS/N 28728 N662HRRaymond Thomas D · Somerset, TXS/N 28725 N6631AUnternaehrer Robert U Trustee · Brunswick, MOBuilt 1956 · S/N 28731 N6632A3 Fly-N LLC · Carlisle, KYBuilt 1956 · S/N 28732 N6633AKolp Mark H · Andrews, TXFirst renewal noticeBuilt 1956 · S/N 28733 N6634AKallabis Harry · Camino, CABuilt 1956 · S/N 28734 N6635ALewis John · Abbyville, KSBuilt 1956 · S/N 28735 N6637ASmedley Hank W · Lake Havasu City, AZBuilt 1956 · S/N 28737 N6638AKeystone Cessna LLC · Melrose, FLBuilt 1956 · S/N 28738 N6639APeach Christopher G · Waterville, MNBuilt 1956 · S/N 28739 N6640ABunger Glenn H · Kirkland, ILBuilt 1956 · S/N 28740 N6642ATundra Aviation Inc · Casselton, NDS/N 28742 N6643AMoore Michael J · Monroe, UTBuilt 1956 · S/N 28743 N6649AShaw Frank Edward · Chestertown, NYBuilt 1956 · S/N 28749 N6651ANimmo Jeffrey J · Wilmington, OHBuilt 1956 · S/N 28751 N6653AAntanovich Matthew J · Bentleyville, PABuilt 1956 · S/N 28753 N6655ADarrah Jonathan M · Murrieta, CABuilt 1956 · S/N 28755 N6657AWatts Sherman C · Paden, OKBuilt 1956 · S/N 28757 N6659ALemerande Alan R · Jefferson City, MOBuilt 1956 · S/N 28759 N6664ASeifert Kerry A · Chugiak, AKBuilt 1956 · S/N 28764 N6665AHolmes James A · Apache Junction, AZS/N 28765 N6668ADay Patrick K · Ellensburg, WABuilt 1956 · S/N 28768 N6671ABurke John E · Spring, TXBuilt 1956 · S/N 28771 N6672AVandenbark Cody M · Troy, IDBuilt 1956 · S/N 28772

Back to Cessna 172