Skip to content

Registered aircraft · 780

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

N105RDSunny Slope Aviation LLC · Adams, TNBuilt 1967 · S/N 17256221 N122KSPt Arts LLC · Grand Rapids, MIBuilt 1966 · S/N 17255255 N122PWKal Aero Flight Instruction LLC · Mattawan, MIBuilt 1966 · S/N 17255433 N13SPNew York State Police · Latham, NYBuilt 1967 · S/N 17256431 N1400FBingham Edward K · Buchanan, GABuilt 1966 · S/N 17254895 N1402FRegistration Pending · Pomona, CARegistration pendingBuilt 1966 · S/N 17254897 N1403FGoedeker Jr Werner F · Waterville, NYBuilt 1966 · S/N 17254898 N1411FKrause Alex D II · Clintonville, WIBuilt 1966 · S/N 17254906 N1413FWitmer Brendle D · Woodbury, PABuilt 1966 · S/N 17254908 N1414FPalmer Matthew B · Riverside, CABuilt 1966 · S/N 17254909 N1420FGaither John A · Rumsey, KYBuilt 1966 · S/N 17254915 N1423FSayers Carl D · Vidalia, LABuilt 1966 · S/N 17254918 N1424FDutton Timothy F · Vassalboro, MEBuilt 1966 · S/N 17254919 N1425FHuarte Shawn D · Sammamish, WAS/N 17254920 N1426FMiller John T III · Greeneville, TNBuilt 1966 · S/N 17254921 N1427FHampton Stephen L · Culbertson, MTBuilt 1966 · S/N 17254922 N1428FPuttre John W · Sullivan, WIBuilt 1966 · S/N 17254923 N1429FLathrop Mark · Franklin, NCBuilt 1966 · S/N 17254924 N1431FAir Pirates Flying Club LLC · Virginia Beach, VABuilt 1966 · S/N 17254926 N1432FMcabee Patrick A · Tampa, FLS/N 17254927 N1433FAnderson Jesse Thomas · Phoenix, AZBuilt 1966 · S/N 17254928 N1434FWinkelman Donald L · Anchorage, AKBuilt 1966 · S/N 17254929 N1437FKelly William W · Springfield, ORBuilt 1966 · S/N 17254932 N1438FBermudez Santana Tacito O · Conyers, GAS/N 17254933 N1439FHallock Lloyd E · Columbia, MOBuilt 1966 · S/N 17254934 N1441FMartin Michal R · Alva, OKBuilt 1966 · S/N 17254936 N1443FNelson Harold G · Pendleton, ORBuilt 1966 · S/N 17254938 N1444FStrope Byron P · Upland, CABuilt 1966 · S/N 17254939 N1445FMorris Loyd Albert · Alvarado, TXBuilt 1966 · S/N 17254940 N1447FCook David F · Carthage, MOBuilt 1966 · S/N 17254942 N1449FJanes Brenda · Shepherdsville, KYBuilt 1966 · S/N 17254944 N1451FCloud Busters Inc · Summertown, TNBuilt 1966 · S/N 17254946 N1452FHorizon Aviation LLC · Bristow, OKBuilt 1966 · S/N 17254947 N1456FBeames Delbert A · Visalia, CABuilt 1966 · S/N 17254951 N1457FAdvanced Aviation LLC · Pontiac, MIBuilt 1966 · S/N 17254952 N1458FMaltby Patrick W · Bath, MIS/N 17254953 N1459FGostecnik Gary · Brookshire, TXBuilt 1966 · S/N 17254954 N1460FConrad William A · Freedom, WIBuilt 1966 · S/N 17254955 N1462FLambdin Charles Randall · Wolf Lake, ILBuilt 1966 · S/N 17254957 N1477FMavity Reagan Chase · Clayton, GABuilt 1966 · S/N 17254972 N1478FElliott Gabrial Adam · Hollywood, ALBuilt 1966 · S/N 17254973 N1489FHoover Andrew V · Jenison, MIBuilt 1966 · S/N 17254984 N1493FAdventist World · Wilson, NCBuilt 1966 · S/N 17254988 N1494FThompson Kevin L · Jefferson, TXBuilt 1966 · S/N 17254989 N1496FSmith James F · Red Springs, NCBuilt 1966 · S/N 17254991 N1497FBlunk Rodney · Bettendorf, IABuilt 1966 · S/N 17254992 N1602FWilliams Richard E · Seaford, DEBuilt 1966 · S/N 17254997 N1603FAbouelleil Hisham · Suffield, CTS/N 17254998 N1604FMorse Mark H · Lake Stevens, WABuilt 1966 · S/N 17254999 N1607FNurieva Asmar · New Smyrna Beach, FLBuilt 1966 · S/N 17255002

Back to Cessna 172H