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.

N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658 N21015Renfro Michael W · Bethel, AKBuilt 1974 · S/N 17263888 N21035Hayes Bradley M · Grove, OKBuilt 1974 · S/N 17263890 N210ANCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17264678 N21124Mitchell Andrew D Trustee · Winnie, TXBuilt 1974 · S/N 17263894 N21126Aviation Academy LLC · Wichita, KSBuilt 1974 · S/N 17263895 N2113JAlternate Air Inc · Seattle, WABuilt 1975 · S/N 17264982 N21157Beta Fleet LLC · South Burlington, VTBuilt 1974 · S/N 17263901 N21159Kope Gregory A · Leesburg, VABuilt 1974 · S/N 17263902 N21199Shaw Deane F · Centerville, MABuilt 1974 · S/N 17263905 N211DXHalter Dudley M · Locust Grove, GAS/N 17265119 N211PTCappe Investment Group LLC · Homestead, FLBuilt 1972 · S/N 17261023 N21237Parker Jeff · Chelsea, ALBuilt 1974 · S/N 17263911 N21246Eastern Stearman Inc Trustee · Leesburg, VAS/N 17263914 N21249Western Kentucky Petroleum Inc · Osage Beach, MOS/N 17263916 N21272Eagle Aviation Inc · Tucson, AZBuilt 1974 · S/N 17263920 N21289High Flight Academy LLC · Allison Park, PABuilt 1974 · S/N 17263923 N21295Tauscher Robert C · Friday Harbor, WABuilt 1974 · S/N 17263925 N21320Diehl Rodney L Trustee · San Jose, CABuilt 1974 · S/N 17263929 N21321Bell Robert A · Las Vegas, NVBuilt 1974 · S/N 17263930 N21329Propeller Enterprises LLC · Gilbert, AZBuilt 1974 · S/N 17263931 N21347Kessler Frank J Jr · Gallatin, TNBuilt 1974 · S/N 17263933 N21351Midwest Flying Service LLC · Wilmington, DEBuilt 1974 · S/N 17263934 N21360Weede Roger H · Dubois, WYS/N 17263935 N21374Stratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263938 N21389Registration Pending · Waldo, WIRegistration pendingBuilt 1974 · S/N 17263942 N21403Bering Capital LLC · Anchorage, AKBuilt 1974 · S/N 17263944 N2140JHardin County Aviation LLC · Kountze, TXBuilt 1975 · S/N 17265018 N21446Ham Todd O · Opdyke, ILBuilt 1974 · S/N 17263946 N21455Drewett Edward A · Many, LABuilt 1974 · S/N 17263950 N21485Dipzinski Victor L · Clio, MIFirst renewal noticeBuilt 1974 · S/N 17263956 N214ANCalifornia In Nice Inc · San Jose, CAS/N 17267499 N214ERLima-001 LLC · Muscatine, IAS/N 17263480 N21515Airline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1974 · S/N 17263960 N21517Leighton Bryce L · Griswold, IABuilt 1974 · S/N 17263961 N21535Wilson Chad M · Mount Ida, ARBuilt 1974 · S/N 17263965 N21543Lima Bravo Group Corp · Miami, FLBuilt 1974 · S/N 17263967 N21553Peacock Sidney T · Davison, MIBuilt 1974 · S/N 17263970 N21564Miller John H · Newnan, GAFirst renewal noticeBuilt 1974 · S/N 17263972 N21571Schwartz Robert J · Coshocton, OHBuilt 1974 · S/N 17263974 N21576Barnes Robert R · Wilton Manors, FLBuilt 1974 · S/N 17263975 N21580Bas Part Sales LLC · Greeley, COBuilt 1974 · S/N 17263977 N21585Ck Leasing Services LLC · Wilmington, DES/N 17263978 N21588Jackson Hole Airport Board · Jackson, WYBuilt 1974 · S/N 17263979 N21643A&E Flying Club Of Los Angeles · Hawthorne, CABuilt 1974 · S/N 17263982 N21648Fox Victor Aviation LLC · Newnan, GAS/N 17263983 N21690Flight Center International LLC · Hollywood, FLBuilt 1974 · S/N 17263987 N21699Ramirez Sam Ernest · Yelm, WABuilt 1974 · S/N 17263988 N21711Williams Roger P III Trustee · Mount Shasta, CAS/N 17263992 N21725Optic Air LLC · Sioux Center, IABuilt 1974 · S/N 17263995

Back to Cessna 172M