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.

N8075BAverett Joseph B · Denham Springs, LABuilt 1957 · S/N 29875 N8076BZurinsky Richard · Port Orchard, WABuilt 1957 · S/N 29876 N8078BShareair LLC · Columbiaville, MIS/N 29878 N8080BNeton Inc · Bradenton, FLBuilt 1957 · S/N 29880 N8085BHowell Rebecca Elizabeth · Elgin, TXBuilt 1957 · S/N 29885 N8092BHering Robert A · Anchorage, AKBuilt 1957 · S/N 29892 N8094BRutherford County Air Rescue Squad · Rutherfordton, NCBuilt 1957 · S/N 29894 N8095BYeagley Daun E III · Moraine, OHBuilt 1957 · S/N 29895 N8099BKlosterman Aviation LLC · Celina, OHBuilt 1957 · S/N 29899 N8103BJafar Farid G · Pine Bluff, ARBuilt 1957 · S/N 29903 N8104BRomar Mark A · Massillon, OHBuilt 1957 · S/N 29904 N8111BTaylor Brad · Alma, GABuilt 1957 · S/N 29911 N8114BAllan Bryan S · Sandy Valley, NVBuilt 1957 · S/N 29914 N8118BBarrera Daniel J · Sugar Land, TXS/N 29918 N811LTegtmeier Michael C · Watertown, WIBuilt 1956 · S/N 29014 N8123BVan Maren John C · Owasso, OKBuilt 1957 · S/N 29923 N8124BVan Skyhawk Charles R · Eagle River, WIS/N 29924 N8125BTrue Heading LLC · Granite City, ILBuilt 1957 · S/N 29925 N8126BRobinson Michael E · Anthony, NMBuilt 1957 · S/N 29926 N8129BSeneca Enhancements Company LLC · Portland, ORBuilt 1957 · S/N 29929 N8130BJohnson Daniel P · Pardeeville, WIBuilt 1957 · S/N 29930 N8133BReaka Dean James Trustee · Troy, MOBuilt 1957 · S/N 29933 N8134BTreefo Bravo LLC · Hawkins, TXS/N 29934 N8136BStanley Mark E · Paso Robles, CABuilt 1957 · S/N 29936 N8137BKelly James E · Accord, NYBuilt 1957 · S/N 29937 N8139BDavies Lincoln J · Oostburg, WIBuilt 1957 · S/N 29939 N8140BOlson Larry G · Walnut Creek, CABuilt 1957 · S/N 29940 N8142BJones Ronald E · Cromwell, CTBuilt 1957 · S/N 29942 N8144BPepper Marcus · San Antonio, TXBuilt 1957 · S/N 29944 N8145BRojas Luis Alberto · Riverside, CABuilt 1957 · S/N 29945 N8148BRoberts Michael · Port Orchard, WABuilt 1957 · S/N 29948 N8149BBergstrom Matthew James · Renton, WABuilt 1957 · S/N 29949 N8150BFond Of Flying Co · Dover, DES/N 29950 N8151BBig Valley Flying Club · Lookout, CABuilt 1957 · S/N 29951 N8154BWestnyack Aviaiton LLC · Sag Harbor, NYBuilt 1957 · S/N 29954 N8155BBrockman Charles · Bend, ORBuilt 1957 · S/N 29955 N8157BLipskoch Anthony P · Buhl, IDS/N 29957 N8161BFehrenbach Chris A · Evansville, INBuilt 1957 · S/N 29961 N8162BMountain Air LLC · Carabaset Vly, MEBuilt 1957 · S/N 29962 N8163BAerosim Inc · Stockton, CABuilt 1957 · S/N 29963 N8165BEvans David M · Superior, WIBuilt 1957 · S/N 29965 N8168BJacobs Dennis A · Rochert, MNBuilt 1957 · S/N 29968 N8170BMelechin David H · Los Angeles, CAS/N 29970 N8171BByker Robert L · Porterville, CABuilt 1957 · S/N 29971 N8173BBetter Air Service LLC · Dailey, WVBuilt 1957 · S/N 29973 N8174BSmith Michael D · King George, VABuilt 1957 · S/N 29974 N8175BSmith Philip M · Houston, TXBuilt 1957 · S/N 29975 N8179BWolford Robert C · Knoxville, TNBuilt 1957 · S/N 29979 N8180BNiehaus James O · Erie, COBuilt 1957 · S/N 29980 N8181BManning Richard F Jr · Midway, GABuilt 1957 · S/N 29981

Back to Cessna 172