Skip to content

Registered aircraft · 3,572

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

N12750Crosby Flying Services LLC · Fort Worth, TXBuilt 1973 · S/N 17262229 N12751Wyatt Trost LLC · Concordia, KSBuilt 1973 · S/N 17262230 N12753Juliett Papa LLC · Kalispell, MTBuilt 1973 · S/N 17262232 N12760Decker Stephen Lee · Como, COBuilt 1973 · S/N 17262235 N12766Civil Air Patrol Flying Assoc Inc · Branford, CTBuilt 1973 · S/N 17262240 N12768Martin Thomas J · Lynden, WABuilt 1973 · S/N 17262242 N1276UStelham Co · Olive Branch, MSBuilt 1976 · S/N 17266971 N12772Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1973 · S/N 17262245 N12776Oviedo Juan · Oak Point, TXBuilt 1973 · S/N 17262249 N12777Mana Kai Flying LLC · Makawao, HIBuilt 1973 · S/N 17262250 N12779Mile High Flyers Club Inc · Fort Valley, VABuilt 1973 · S/N 17262252 N12783American Patrols Inc · Midland, TXBuilt 1973 · S/N 17262256 N12789Marshall Frederic J · Rochester, NYBuilt 1973 · S/N 17262261 N12790Cdb Group Holdings LLC · Sheridan, WYBuilt 1973 · S/N 17262262 N12791Neo Flites Flying Club Inc · Elmhurst, ILBuilt 1973 · S/N 17262263 N12793Arpey Gerard J · Colleyville, TXBuilt 1973 · S/N 17262264 N12794Mccain Michael G · Barstow, CABuilt 1973 · S/N 17262265 N12795Rl Aviation LLC · Miami, FLBuilt 1973 · S/N 17262266 N12796Skylens LLC · Hammond, LABuilt 1973 · S/N 17262267 N127KDSouthmost Aviation Inc · Brownsville, TXBuilt 1976 · S/N 17267210 N12801Cone Ted · Wayne, NJBuilt 1973 · S/N 17262271 N12805Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262275 N12819Stewart Todd L · Mooresville, NCS/N 17262288 N12820US Aviation Group LLC · Denton, TXBuilt 1973 · S/N 17262289 N12821Hayslett Norman L · Roscoe, MOBuilt 1973 · S/N 17262290 N12822Courtney Aviation LLC · Columbia, CABuilt 1973 · S/N 17262291 N1282URutledge James K Trustee · Colfax, CABuilt 1976 · S/N 17266977 N12830All Sports Aviation LLC · Spokane, WABuilt 1973 · S/N 17262296 N12831Bryant Kevin L · Terry, MSBuilt 1973 · S/N 17262297 N12833Kling Aviation Inc · Friendswood, TXBuilt 1973 · S/N 17262299 N12834High Flight Academy LLC · Allison Park, PABuilt 1973 · S/N 17262300 N12836Schlemmer Diane · Roswell, GABuilt 1973 · S/N 17262301 N1283UAtutis Michael F · Baldwinsville, NYBuilt 1976 · S/N 17266978 N12840Lanier Aviation LLC · Cleveland, GABuilt 1973 · S/N 17262304 N12849Ripa Christopher J · East Harwich, MABuilt 1973 · S/N 17262311 N12860Solis Aviation LLC · Carroll, OHBuilt 1973 · S/N 17262319 N12865Flyright Aviation LLC · Columbus, OHBuilt 1973 · S/N 17262324 N12866Holmes Charles Trustee · Fort Madison, IABuilt 1973 · S/N 17262325 N12867Palm Grove Development Inc · Gray, GABuilt 1973 · S/N 17262326 N12871Bemidji Aviation Services Inc · Bemidji, MNBuilt 1973 · S/N 17262330 N12872Advanced Aviation And Aircraft Rental LLC · Lawrenceville, GABuilt 1973 · S/N 17262331 N12874Mentone Flying Club Inc · Rochester, INBuilt 1973 · S/N 17262333 N12875Career Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1973 · S/N 17262334 N12876Aerolanding LLC · Enterprise, ALBuilt 1973 · S/N 17262335 N12878M&M Bear Necessities LLC · Newellton, LABuilt 1973 · S/N 17262337 N1287UTrekraken Aviation LLC · Scottsdale, AZBuilt 1976 · S/N 17266981 N12880Aerial Holdings LLC · Lewes, DEBuilt 1973 · S/N 17262339 N12883Rpm Aero LLC · Lincolnwood, ILBuilt 1973 · S/N 17262340 N12884Registered aircraftBuilt 1973 · S/N 17262341 N12885Above & Beyond Aviation LLC · Sandy Hook, CTBuilt 1973 · S/N 17262342

Back to Cessna 172M