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.

N121KAAir Ally Asset Management LLC · Chisago City, MNS/N 17263836 N12200Dunahoo Steven W · Cleveland, GABuilt 1973 · S/N 17261880 N12209Melendez Jesus · North Miami, FLS/N 17261881 N12210Exclusive Motors Inc · Grand Prairie, TXBuilt 1973 · S/N 17261882 N12211Miller Todd B · Wayne, ILBuilt 1973 · S/N 17261883 N12212Wilson Donovan F · Friday Harbor, WABuilt 1973 · S/N 17261884 N12213Top Flight Aviation Inc · Corona, CABuilt 1973 · S/N 17261885 N12215Cm3 LLC · North Las Vegas, NVBuilt 1973 · S/N 17261887 N1221UJ Linn Aviation Inc · Quinlan, TXBuilt 1976 · S/N 17266918 N12229Zapsky Richard M Jr · Houtzdale, PABuilt 1973 · S/N 17261892 N12232S C Skyhawks Inc · Columbia, SCBuilt 1973 · S/N 17261895 N12234Amelia Reid Aviation LLC · San Jose, CABuilt 1973 · S/N 17261896 N12236Wolak Filip O · New York, NYBuilt 1973 · S/N 17261898 N12239Gables Christopher A · Riverside, CABuilt 1973 · S/N 17261900 N1223UKoren Richard D · Brea, CABuilt 1976 · S/N 17266919 N12240Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261901 N12243Phoenix Sky Aviation LLC · Gilbert, AZBuilt 1973 · S/N 17261903 N12245Donnelly Terrence A · Eleele, HIBuilt 1973 · S/N 17261905 N12246Bowles Thomas M · Olivehurst, CABuilt 1973 · S/N 17261906 N12247Rebecca'S Wings 247 LLC · Greenville, KYBuilt 1973 · S/N 17261907 N1224UGoss Selby · Baytown, TXBuilt 1976 · S/N 17266920 N12261Davis Danny R · S Coffeyville, OKBuilt 1973 · S/N 17261909 N1226UAirborne LLC · Wilmington, DEBuilt 1976 · S/N 17266922 N1227UKelly William W · Springfield, ORBuilt 1976 · S/N 17266923 N1228UBig Sky Aviation LLC · Glenmora, LABuilt 1976 · S/N 17266924 N12290Read Andrea · Austin, TXFirst renewal noticeBuilt 1973 · S/N 17261912 N12291Cisek Jason M · Westfield, MABuilt 1973 · S/N 17261913 N1229UMcdonald Air Services LLC · Saint Johns, MIBuilt 1976 · S/N 17266925 N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842 N1232UOrganization Of Black Aerospace Professionals Inc · Westchester, ILS/N 17266928 N12330Liller Kenneth F · New Port Richey, FLBuilt 1973 · S/N 17261932 N12331N Conti Inc · Boyertown, PABuilt 1973 · S/N 17261933 N12335Truscott Jon M · Sunfield, MIBuilt 1973 · S/N 17261935 N12336Qualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 17261936 N12339Howard Ronald W · Okeechobee, FLBuilt 1973 · S/N 17261937 N1233UMagnum Air LLC · Camp Hill, PABuilt 1976 · S/N 17266929 N12341Merl Robert B · Los Alamos, NMBuilt 1973 · S/N 17261938 N12342Simpson Elden G · Prineville, ORBuilt 1973 · S/N 17261939 N12343Albany Aviation Ny LLC · Nassau, NYBuilt 1973 · S/N 17261940 N12346Baidenmann Maralin Frances · Bend, ORBuilt 1973 · S/N 17261941 N12360Wings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261947 N12365Singh Jaganpreet · Bakersfield, CABuilt 1973 · S/N 17261950 N12366Zimmerman Michael P · Verona, WIBuilt 1973 · S/N 17261951 N1236UKosmoski Matthew J · Katy, TXBuilt 1976 · S/N 17266931 N12375Bauer Kathleen S · Harrison City, PABuilt 1973 · S/N 17261954 N12376Lockwood Connor A · Anchorage, AKS/N 17261955 N12379Kolar Ken DBA · Brazoria, TXBuilt 1973 · S/N 17261957 N1237UStaehling Jonathan J · Woodstock, ILBuilt 1976 · S/N 17266932 N12382Blue Sky Pilots Inc DBA · Salem, ORBuilt 1973 · S/N 17261958 N12387Bayramoglu Ulug S · Carrollton, TXS/N 17261961

Back to Cessna 172M