Skip to content

Registered aircraft · 413

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

N6934XLunar Aviation Services LLC · Owasso, OKS/N 17247834 N6935XDetert Robert D · Rockdale, TXBuilt 1960 · S/N 17247835 N6940XWestern Aircraft Leasing LLC · Tempe, AZS/N 17247840 N6943XSkinner Roma L · Ovilla, TXS/N 17247843 N6945XA Team Motors LLC DBA · Henderson, NVBuilt 1962 · S/N 17247845 N6948XWalburg Frank L · Zanesville, OHS/N 17247848 N6950XAnderson Thomas R · Seattle, WABuilt 1960 · S/N 17247850 N6954XSebestik William C · Walker, MNS/N 17247854 N6955XDirigo Aerospace Solutions LLC · Sumner, MEBuilt 1960 · S/N 17247855 N6961XHays Christopher Keith · Cleveland, MSS/N 17247861 N6962XBradsher Harold M · Troy, MOBuilt 1960 · S/N 17247862 N6968XTurner David M · Edgewood, WABuilt 1960 · S/N 17247868 N6970X4 Generation Aviation LLC · Memphis, MOBuilt 1960 · S/N 17247870 N6973XSouthwell Arthur M · Arcadia, FLBuilt 1960 · S/N 17247873 N6979XScott Thomas A Jr · Lawrenceburg, TNBuilt 1960 · S/N 17247879 N6980XMartin Timothy L · Cecilia, KYBuilt 1960 · S/N 17247880 N6981XBoswell Steven P · Clear Spring, MDBuilt 1960 · S/N 17247881 N6983XOptivol Corp · Miami, FLBuilt 1960 · S/N 17247883 N6984XFive Delta Sierra Inc · Pembroke Pines, FLBuilt 1960 · S/N 17247884 N6985XNazario Juan A · Orlando, FLBuilt 1960 · S/N 17247885 N6986XMcallister Paul · Delafield, WIBuilt 1960 · S/N 17247886 N6988XPaul Aviation LLC · Wasco, CAS/N 17247888 N6992XBurleson James R · Snyder, TXBuilt 1960 · S/N 17247892 N6994XVossler Kevin D · Bismarck, NDBuilt 1960 · S/N 17247894 N6995XWarmkessel James R · Felton, CABuilt 1960 · S/N 17247895 N7088DShoup Greg L · Pierre, SDBuilt 1961 · S/N 17248392 N727ZGNelson Poultry Farms Inc · Manhattan, KSBuilt 1961 · S/N 17248125 N7400XLandrush Construction LLC · Fairview, OKBuilt 1960 · S/N 17247900 N7402XClemson Flying Club Inc · Seneca, SCBuilt 1960 · S/N 17247902 N7405XWills Terry W · Cedar Park, TXBuilt 1961 · S/N 17247905 N7411XTakagi Mark A · Richland, WABuilt 1960 · S/N 17247911 N7412XEpperson Gregory R · Grove, OKBuilt 1960 · S/N 17247912 N7415XKeenan James F · Neenah, WIBuilt 1960 · S/N 17247915 N7416XHarris Terrence J · Killeen, TXBuilt 1960 · S/N 17247916 N7417XNix Renford R · Lake Village, ARBuilt 1960 · S/N 17247917 N7419XSkyranch Knoxville Youth Inc · Knoxville, TNBuilt 1960 · S/N 17247919 N7420XGreen Harold J · Spokane Valley, WAS/N 17247920 N7423XSierra Sky Aviation LLC · Kalispell, MTBuilt 1960 · S/N 17247923 N7424XHigh Glide LLC · Tucson, AZBuilt 1960 · S/N 17247924 N7425XLifer Craig · Hackettstown, NJBuilt 1960 · S/N 17247925 N7426XTraverse Air Inc · Traverse City, MIBuilt 1960 · S/N 17247926 N7429XDolezal Thomas J · Mineral, VABuilt 1960 · S/N 17247929 N7431XVannier Aviation LLC · Sheridan, ORBuilt 1960 · S/N 17247931 N7432XFerguson Mark G · Wallkill, NYBuilt 1960 · S/N 17247932 N7435XRoduner Cindy J · Benton, KSS/N 17247935 N7440XWatonwan Flyers Inc · Saint James, MNBuilt 1960 · S/N 17247940 N7441XHolland Newel G · Nacogdoches, TXBuilt 1960 · S/N 17247941 N7442XBeail Herschel D · Quincy, CABuilt 1960 · S/N 17247942 N7445XMelott Matthew · Mesa, AZS/N 17247945 N7447XBrewer Eric V · Alva, OKS/N 17247947

Back to Cessna 172B