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.

N3983FParr Ronald C · Ogden, UTBuilt 1958 · S/N 36883 N3984FBalbaugh Donald E · Cheboygan, MIBuilt 1958 · S/N 36884 N3986FQuirk Charles L · Lake Charles, LABuilt 1958 · S/N 36886 N3987FDe Young Darryl R · Okeechobee, FLBuilt 1958 · S/N 36887 N3993FMckee Robert D · Odessa, WABuilt 1958 · S/N 36893 N3HLLamarr Ryan A · Greenview, CABuilt 1957 · S/N 29935 N4000FDe Lisio Frederick C · Andover, MABuilt 1958 · S/N 36900 N4003FMartin Rogers K · Rome, GABuilt 1958 · S/N 36903 N4004FCreelman Richard A · San Marcos, TXBuilt 1958 · S/N 36904 N4005FRound Engine Aero · Nashville, MIS/N 36905 N4006FBig Sky Fkyers LLC · Billings, MTS/N 36906 N4010FLarsen Harry A · The Dalles, ORBuilt 1958 · S/N 36910 N4011FMiller Kerry N · Owensville, MOBuilt 1958 · S/N 36911 N4014FMaxification LLC · Lavonia, GABuilt 1958 · S/N 36914 N4020FBarnard David P · Delmar, NYBuilt 1958 · S/N 36920 N4025FBrazos River Aviation Group LLC · Mineral Wells, TXBuilt 1958 · S/N 36925 N4029FMcelhaney Jung R · Phelan, CABuilt 1958 · S/N 36929 N4032FDmnm LLC · Albuquerque, NMBuilt 1958 · S/N 36932 N4035FGinn Ray Jr · Beeville, TXBuilt 1958 · S/N 36935 N4037FSicaras Paul G · Longmont, COBuilt 1958 · S/N 36937 N4038FKcantarano LLC · Mukilteo, WABuilt 1958 · S/N 36938 N4039FBlue Ice Aviation Inc · Wasilla, AKS/N 36939 N4042FTweedle Dee LLC · John Day, ORBuilt 1958 · S/N 36942 N4043FFinley Trevor S · Caddo Mills, TXS/N 36943 N4045FRobinson Jeffrey A · Gaines, MIBuilt 1956 · S/N 36945 N4046FVyatkin Denis · Sacramento, CAS/N 36946 N4047FRegistration Pending · Sherwood, WIRegistration pendingBuilt 1958 · S/N 36947 N4049FSouthwell Arthur M · Arcadia, FLBuilt 1958 · S/N 36949 N4050FTitensor Shanelle Bn · Tetonia, IDS/N 36950 N4051FTamargo Victor · Fort Worth, TXBuilt 1958 · S/N 36951 N4054FSterbonic Peter D · Wickenburg, AZS/N 36954 N4055FFerguson Richard Trustee · Canyon Lake, TXBuilt 1958 · S/N 36955 N4056FMullen Mark M · Livermore, CABuilt 1958 · S/N 36956 N4059FDoss Lonny Richard · Lake Charles, LABuilt 1958 · S/N 36959 N4061FHuston Aviation LLC · Fort Worth, TXBuilt 1958 · S/N 36961 N4062FCharlotte Air Services · Charlotte, MIBuilt 1958 · S/N 36962 N4063FHand Tod E · Copper Center, AKBuilt 1958 · S/N 36963 N4066FGray Chet K · Midland, TXBuilt 1958 · S/N 36966 N4069FDmac Aircraft LLC · Savannah, GABuilt 1958 · S/N 36969 N4071FQuebedeaux Steven R · Sunset, LABuilt 1958 · S/N 36971 N4073FStebbins Craig S · Glendive, MTBuilt 1958 · S/N 36973 N4075FPrice Timothy C · Rancho Cucamonga, CABuilt 1958 · S/N 36975 N4076FStebbins Robert A · Cookson, OKS/N 36976 N4077FSolomon Joseph E Jr · Modesto, CABuilt 1958 · S/N 36977 N4078FJanes Christopher D · Columbia, KYBuilt 1958 · S/N 36978 N4079FCovington Gary N · Midland, TXFirst renewal noticeBuilt 1958 · S/N 36979 N4080FGoggans John L · Mansfield, MOBuilt 1958 · S/N 36980 N4086FShelton Joseph G · Kingman, AZBuilt 1958 · S/N 36986 N4090FFox Aero Club · Catawba, NCBuilt 1958 · S/N 36990 N4094FSchupbach Robert D · Clearwater, FLS/N 36994

Back to Cessna 172