Skip to content

Registered aircraft · 1,025

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

N173KMLd Enterprises Llp · Roswell, GABuilt 1968 · S/N 17257781 N173PKTrc-4k Investments LLC · Southlake, TXBuilt 1968 · S/N 17257364 N191SHHutton Stephen · Madison, MSBuilt 1968 · S/N 17257232 N19370Clanton Ronald W · Aurora, COBuilt 1968 · S/N 17257181 N1967USmith Bernard A · Wasilla, AKBuilt 1968 · S/N 17257827 N1969KRegistered aircraftBuilt 1968 · S/N 17257813 N199ARBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 17274778 N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306 N223TRTurner Lee W · Valdosta, GABuilt 1968 · S/N 17257757 N22DECrawford Edgar A · Locust Grove, GABuilt 1970 · S/N 17259168 N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920 N247APNorth Joseph · Cocoa, FLBuilt 1970 · S/N 17259066 N2617QKerhulas Anthony B · Santa Maria, CABuilt 1969 · S/N 17258707 N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931 N2690QSilva Alberto · Titusville, FLBuilt 1970 · S/N 17259104 N26ZWeber Mark S · Wildwood, MOBuilt 1969 · S/N 17258153 N300PSRight Coast Ventures LLC · Royse City, TXBuilt 1968 · S/N 17257501 N332JCS&S Aircraft Inc · Bennington, VTS/N 17258514 N337GFLewis John P · Alachua, FLBuilt 1969 · S/N 17258349 N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784 N34LVRegistered aircraftBuilt 1968 · S/N 17257507 N362CAChoice Aviation LLC · Hamilton, MTBuilt 1970 · S/N 17258976 N36DSUp And Up Aviation LLC · Spring, TXBuilt 1970 · S/N 17259145 N3BYJamora Daniel L · Victorville, CABuilt 1969 · S/N 17257965 N3CLWehner Kaitlyn M · Malone, WIBuilt 1968 · S/N 17257531 N41306Bruns Darcy · Sandia, TXBuilt 1969 · S/N 17258310 N4413SBirmingham Flight Center LLC · Birmingham, ALS/N 17257905 N444PPCoyne Greg · Hondo, TXBuilt 1969 · S/N 17258278 N456CBCollins Bruce H · Caldwell, TXBuilt 1968 · S/N 17257257 N45DARegistration Pending · Fairbanks, AKRegistration pendingBuilt 1969 · S/N 17258210 N461TJSharmouj Raymound · Christiansted, VIFirst renewal noticeBuilt 1970 · S/N 17259114 N46293Keefer Terry · La Verne, CABuilt 1968 · S/N 17257162 N46303Harbour Aviation LLC · Weatherford, TXBuilt 1968 · S/N 17257171 N46307Harvey Adrian C · Riverside, CABuilt 1968 · S/N 17257174 N46309Bell 47 Helicopters Inc · Middletown, DES/N 17257176 N46312Neary John R · Ridgefield, NJBuilt 1968 · S/N 17257179 N46315Ntss LLC · Henderson, NVBuilt 1968 · S/N 17257180 N46322Asw Aviation LLC · Warsaw, INBuilt 1968 · S/N 17257185 N46323Grieve Shane · Fort Worth, TXBuilt 1968 · S/N 17257186 N46325Matthews Grover C · Fairborn, OHBuilt 1968 · S/N 17257188 N46334Youngblood Michael A · Atlanta, GABuilt 1968 · S/N 17257192 N46338Triad Aviation Academy LLC · Greensboro, NCBuilt 1968 · S/N 17257193 N46342Gernand Charles E · Hopeston, ILBuilt 1968 · S/N 17257196 N46344Nordick Brett A · Glyndon, MNBuilt 1968 · S/N 17257198 N46345Hellgamite Inc · Dover, DEBuilt 1968 · S/N 17257199 N46346Registered aircraftBuilt 1968 · S/N 17257200 N46349Third Step 1 LLC · Gilbert, AZBuilt 1968 · S/N 17257202 N46351Ajayi Samuel · Fredericksburg, VAS/N 17257204 N46352Moss James H · Anchorage, AKBuilt 1968 · S/N 17257205 N46355White Wings Air Inc · Jacksonville, FLS/N 17257207

Back to Cessna 172K