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.

N79477Shipley David L · Yates City, ILBuilt 1969 · S/N 17258120 N79478Fusano Lisa A · La Crescenta, CAS/N 17258121 N79479Larue Mark C · Leander, TXBuilt 1969 · S/N 17258122 N79482Matacotta Ernest A · Marietta, GABuilt 1969 · S/N 17258123 N79488Nevels Steven D · Merritt Island, FLBuilt 1969 · S/N 17258126 N79489Maisonet Gonzalez Hector W · Ocala, FLBuilt 1969 · S/N 17258127 N79493Bounds Trucking LLC · Faison, NCS/N 17258130 N79498Gord James F · Sandwich, ILBuilt 1969 · S/N 17258132 N79499Johnson Benjamin M · Monroe, WIBuilt 1969 · S/N 17258133 N79501Skyhawk Flying Club Inc · Omaha, NEBuilt 1969 · S/N 17258134 N79506Allen Michelle E · Sebastopol, CABuilt 1969 · S/N 17258138 N79513Kalman Engineering Inc · Pekin, ILBuilt 1969 · S/N 17258142 N79526Evink Bradley D · North Branch, MNBuilt 1969 · S/N 17258151 N79529Elliott Tina L · Tucson, AZBuilt 1969 · S/N 17258154 N79531Newberry Tyler D · Clovis, CABuilt 1969 · S/N 17258155 N79533Eby William J · Sugar Grove, ILBuilt 1969 · S/N 17258156 N79540Funk Kathryn A · Rockledge, FLBuilt 1969 · S/N 17258160 N79543Registration Pending · Manns Harbor, NCRegistration pendingBuilt 1969 · S/N 17258163 N79546Diakonis Emmanuel W · Maumee, OHBuilt 1969 · S/N 17258165 N79549Triad Aviation Academy LLC · Greensboro, NCBuilt 1969 · S/N 17258168 N79554Williams Kenneth J · Wasilla, AKBuilt 1969 · S/N 17258171 N79558Silver Creek Aviation Services LLC · Snowflake, AZBuilt 1969 · S/N 17258173 N79562Brown Glynna J · Middlesboro, KYBuilt 1969 · S/N 17258176 N79565Vm Aero LLC · Camden, DEBuilt 1969 · S/N 17258179 N79566Eisele Elton · Schaumburg, ILBuilt 1969 · S/N 17258180 N79567Miller Aviation Group LLC · Coon Rapids, MNBuilt 1969 · S/N 17258181 N79571Myers James W · Westmoreland, NHS/N 17258185 N79575Fox Valley Flyers Inc · Appleton, WIBuilt 1969 · S/N 17258188 N79576Dillon Monte Lane Trustee · Mooresville, INBuilt 1969 · S/N 17258189 N79578Dannebrock Paul W · Lockport, NYBuilt 1969 · S/N 17258190 N79579Brown Larry · Mesa, AZS/N 17258191 N79580Bowers James H Jr · Broadus, MTBuilt 1969 · S/N 17258192 N79584Ocean Breeze Aviation Inc · Wilton Manors, FLBuilt 1969 · S/N 17258195 N79587Twj Aviation 2 LLC · Jacksonville, FLBuilt 1969 · S/N 17258198 N79599Hull Aviation Inc · Decatur, ALBuilt 1969 · S/N 17258206 N797DTEngelskirger Karl D · Valley City, OHBuilt 1969 · S/N 17258505 N79805Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258207 N79873Knuteson Anthony M · Ketchikan, AKS/N 17258208 N79874Morris Steven J · Wasilla, AKBuilt 1969 · S/N 17258209 N79877Feliz Thaisio D · Port Saint Lucie, FLS/N 17258212 N79878Buncher Bruce M · North Royalton, OHBuilt 1969 · S/N 17258213 N79879Scafe Travis W · Tuttle, OKBuilt 1969 · S/N 17258214 N79881Kevin Kingsley LLC · Lamar, MOBuilt 1969 · S/N 17258216 N79884Barnhill Laith A · Arlington, WABuilt 1969 · S/N 17258219 N79888Smith Happy E · Rogersville, TNBuilt 1969 · S/N 17258223 N79890Smith J Francis · Seattle, WAS/N 17258225 N79893Panjab Aviation · Las Vegas, NVBuilt 1969 · S/N 17258228 N79894Watson Mitchell M · Tribune, KSBuilt 1969 · S/N 17258229 N79896Jstream Lc · Sheridan, WYBuilt 1969 · S/N 17258231 N79898Aero Quest LLC · Olive Branch, MSBuilt 1969 · S/N 17258233

Back to Cessna 172K