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.

N100AWDe La Torre Alfonso Jr · Brownsville, TXBuilt 1956 · S/N 28479 N100KHLefevers Adam · Pineville, KYS/N 28529 N1023BLeguia Augusto A · Kathleen, GAS/N 28524 N1042GPorter David G · Stuart, FLS/N 36704 N1073YGoedicke Walter H Jr · Bay Head, NJBuilt 1956 · S/N 28277 N10BFCruz Keoni K · The Woodlands, TXBuilt 1958 · S/N 36672 N1100Souchet Brian · Fleming Island, FLBuilt 1956 · S/N 29178 N112NBillingsley Carl · Henderson, TXBuilt 1956 · S/N 28584 N119DHJohnson Peter L · Chico, CAS/N 36257 N11KTHilborn Rebecca M · Addison, NYBuilt 1956 · S/N 28593 N139BTTaylor Edward S · Billings, MTBuilt 1957 · S/N 29707 N144ARPaone Rebecca L · South Rockwood, MIS/N 28267 N169AMMargitan Allan R · Nine Mile Falls, WAS/N 28943 N16AJA&J Air Sales Inc · San Antonio, TXS/N 28531 N16FHodge Justin Eugene · White Sands, NMBuilt 1956 · S/N 28327 N16SBZabel Victor R · Albuquerque, NMBuilt 1956 · S/N 29272 N171QEndeavor West LLC · Chugiak, AKBuilt 1956 · S/N 28197 N1722SShoemake Gregory Allen · Palmer, AKS/N 28656 N172BBGlabe David Kristopher · La Grande, ORBuilt 1957 · S/N 29438 N172CFMontagne Denise A Trustee · Reno, NVS/N 46247 N172FDoig Richard M · Walton, NYBuilt 1955 · S/N 28109 N172GGInternational Air Services Inc Trustee · Carson City, NVBuilt 1959 · S/N 46428 N172JNRedd Charles · Dutton, MTS/N 36919 N172MBStone Wall Acres · Antigo, WIS/N 36824 N172TPContrail Aviation Inc · Cheboygan, MIBuilt 1956 · S/N 28401 N172TWGriffiths Larry F · Upland, CABuilt 1956 · S/N 29537 N172WVMessner Mark R · Chesapeake, OHBuilt 1957 · S/N 36274 N190FCook James H · Brookings, ORBuilt 1958 · S/N 46366 N1957WDye Roger C · Pomeroy, WAS/N 36045 N197TCRegistered aircraftBuilt 1958 · S/N 46038 N19WSHolcomb Nicholas A · Yakutat, AKS/N 29689 N202ENemer-Kaiser Daniel A · Eagle Point, ORS/N 29324 N2086YLewis Mark N · West Plains, MOBuilt 1956 · S/N 28318 N209LJCat Agri Aviation Inc · Walnut Ridge, ARS/N 36334 N2108URoy Roland P · Lewiston, MEBuilt 1956 · S/N 29480 N2208Gibson Kevin T · Orange, VABuilt 1956 · S/N 29503 N221AGryczewski John · Olive Branch, MSBuilt 1956 · S/N 28413 N222TXJ M Williams LLC · Stockton, CABuilt 1957 · S/N 29976 N228NYFerguson Colt W · Wolf Point, MTBuilt 1959 · S/N 46482 N22XXHeath Michael A · Barnet, VTBuilt 1958 · S/N 36982 N2308UMarsh Hank K · Joseph, UTBuilt 1956 · S/N 29528 N24SGVogel Scott A · Dewey, AZS/N 29764 N253NANeidert Melvin E · Ulysses, KSS/N 29216 N254NYAckerman Rachael K · Sauk Rapids, MNBuilt 1959 · S/N 46449 N256NYAlexander David H · Warrensburg, NYBuilt 1956 · S/N 29049 N26BFBasco James Millard M · Richlands, NCS/N 28295 N271RMMartinson Ryan D · Nome, AKBuilt 1957 · S/N 36130 N2769ZPacheco Ricardo · Albuquerque, NMBuilt 1956 · S/N 29077 N277NWindh Randall · Reedley, CAS/N 28440 N280SLRamer Scott A · Dornsife, PAS/N 172-73121

Back to Cessna 172