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.

N1479USperoni Pablo · Vieques, PRBuilt 1976 · S/N 17267146 N147JFour Seven Jays Flying Club Inc · Rapids City, ILBuilt 1973 · S/N 17262545 N1480USchaad Michael · Yorba Linda, CABuilt 1976 · S/N 17267147 N1481VTalbert Barbara E · Wesley Chapel, FLBuilt 1974 · S/N 17263615 N1482VGriffin Samuel · Doniphan, MOBuilt 1974 · S/N 17263616 N1483UJohnson William Scott · New Market, TNBuilt 1976 · S/N 17267150 N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N1491UGardner Christopher · Farmers Branch, TXBuilt 1976 · S/N 17267158 N1493VMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263623 N1494VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263624 N1495UFairflight LLC · San Diego, CABuilt 1976 · S/N 17267162 N1498VMoore James E · East Falmouth, MABuilt 1974 · S/N 17263628 N14AZD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1975 · S/N 17263495 N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N150FSCustom Air International LLC · Homestead, FLBuilt 1975 · S/N 17265554 N1516VAircraft Management Services Inc · Milton, FLBuilt 1974 · S/N 17263638 N1519VBent Prop LLC · Inver Grove, MNBuilt 1974 · S/N 17263641 N1522VDawn Patrol Flying Club Inc · Northville, MIBuilt 1974 · S/N 17263643 N1523VSchmitz Barbara B · Oshkosh, WIBuilt 1974 · S/N 17263644 N1526VRl Aviation LLC · Miami, FLBuilt 1974 · S/N 17263645 N1531VOneonone Flight Training LLC · Hagerstown, MDBuilt 1974 · S/N 17263648 N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651 N1541UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267169 N1546VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263654 N1550VJar Investments LLC · Kalispell, MTBuilt 1974 · S/N 17263655 N1551VBumpe Logistics LLC · South Jordan, UTBuilt 1974 · S/N 17263656 N1555VGinther Michael P · Lemmon, SDBuilt 1974 · S/N 17263658 N155CWPotcake Aviation LLC · Mcminnville, ORBuilt 1975 · S/N 17265697 N1560VAvp Aviation LLC · La Jolla, CABuilt 1974 · S/N 17263663 N1561VHenkel Douglas K · Olathe, KSBuilt 1974 · S/N 17263664 N1567VRasmussen Bryan K · Wilsonville, ORS/N 17263668 N1570VMcdermott John P Trustee · Redding, CABuilt 1974 · S/N 17263671 N1571VPeabody Jeffery L · Vinemont, ALBuilt 1974 · S/N 17263672 N1572VWaldroup Anthony Wayne · Konawa, OKBuilt 1974 · S/N 17263673 N1575VMissouri Reliability Services LLC · Maryville, MOBuilt 1974 · S/N 17263675 N1580VPrecision Curbs And Concrete LLC · Shady Cove, ORS/N 17263696 N1588VC-140 Company LLC · Milton, FLBuilt 1974 · S/N 17263683 N1590VWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17263684 N1591VAviation Academy LLC · Wichita, KSBuilt 1974 · S/N 17263685 N1592VGates Kenneth A · Lake Isabella, CABuilt 1974 · S/N 17263686 N1593VBarrie Woodrow L · Oxford, MIBuilt 1974 · S/N 17263687 N1594UFarmer Michael E · Greer, SCBuilt 1976 · S/N 17267176

Back to Cessna 172M