Skip to content

Registered aircraft · 721

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

N7164VB&J Aviation LLC · Saint Louis, MOBuilt 1974 · S/N 22-0073 N7169VPrh Farms Inc · Gettysburg, SDBuilt 1974 · S/N 22-0078 N717SThornapple Flying Academy LLC · Middleville, MIBuilt 1968 · S/N 680202 N7182VAllen Paul · Altona, NYS/N 22-1180 N7183VRegistered aircraftBuilt 1975 · S/N 22-1181 N7185VKlopp Gary W · Houston, TXBuilt 1975 · S/N 22-1183 N7186VKlein James V · Saint Cloud, FLBuilt 1975 · S/N 22-1184 N7188VCregan Daniel M · Webster, NYBuilt 1975 · S/N 22-1186 N7189VGreat Miami Aviation LLC · Miamisburg, OHBuilt 1975 · S/N 22-1187 N7193VArmbruster Jeffrey T · Norfolk, NEBuilt 1975 · S/N 22-1191 N72MGAerosox LLC · Diamondhead, MSBuilt 1967 · S/N 680033 N733XMiddleton Mary David · Austin, TXBuilt 1967 · S/N 680045 N736PAConnection Leasing Co · Dallas, TXS/N 670113 N737HBTokach David L · Sierra Vista, AZBuilt 1967 · S/N 670469 N7402VKendrick Brian S · Kerrville, TXS/N 22-1195 N7405VBarrett Ronald A Jr · Shreveport, LABuilt 1975 · S/N 22-1198 N7406VEvans Steven M · Somis, CAS/N 22-1199 N7408VM Twenty Inc · Bismarck, NDBuilt 1975 · S/N 22-1201 N7411VDk Aero LLC · Wilmington, DEBuilt 1975 · S/N 22-1204 N7431VErnst Albert S III · Buda, TXS/N 22-1208 N7432VSpires William B · Minden, NVBuilt 1975 · S/N 22-1209 N7435VFreebird Ventures Inc · Oak Lawn, ILBuilt 1975 · S/N 22-1212 N7437VCoastal Airworx LLC · Middletown, NJBuilt 1975 · S/N 22-1214 N7438VGuillermo Geary B · San Diego, CABuilt 1975 · S/N 22-1215 N7445VNisly Josh · Jackson Heights, NYBuilt 1975 · S/N 22-1222 N7447VBaca Robert A Trustee · Auburn, CAS/N 22-1224 N7449VStarns Rod J · Belleville, ILBuilt 1975 · S/N 22-1226 N7450VNance Robert J · Bountiful, UTBuilt 1975 · S/N 22-1227 N7451VFox Business Advisors LLC · Mesa, AZS/N 22-1228 N7452VBlose Kevin T · New Braunfels, TXS/N 22-1229 N7456VCollon Joseph · Bonita, CAS/N 22-1233 N7457VGietzen Hilary H · Minot, NDBuilt 1975 · S/N 22-1234 N7458VMooney Ventures LLC · Canton, GABuilt 1975 · S/N 22-1235 N7459VPocket Aces LLC · Baton Rouge, LABuilt 1975 · S/N 22-1236 N7461VDrake Robert L · Ruston, LABuilt 1975 · S/N 22-1238 N7462VBroken Pole Fishing Hole 4 Wounded Vets · Vancouver, WABuilt 1975 · S/N 22-1239 N768CCDymek Dana · Glencoe, ILBuilt 1976 · S/N 221352 N76DRAppleget Edward L · Glendale, AZS/N 22-1348 N76HPDavid Ingram Security Solutions · Lander, WYBuilt 1970 · S/N 700010 N7744MMike Clark Trucking Inc · Colton, CABuilt 1974 · S/N 22-0013 N7750MDoran Jeffrey · Westerville, OHBuilt 1974 · S/N 22-0016 N7753MHangarone Air Services LLC · Los Altos, CAFirst renewal noticeBuilt 1974 · S/N 22-0017 N775EESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1967 · S/N 670348 N7760MBirdy Aviation LLC · Santa Barbara, CABuilt 1974 · S/N 22-0020 N7762MMunn Kevin · Jeffersonville, INBuilt 1974 · S/N 22-0022 N7768MHoyle Charles D Jr · Eureka, CABuilt 1974 · S/N 22-0024 N7769MCorso Nicholas J · Stuart, FLBuilt 1974 · S/N 22-0025 N7772MDyrstad William M · Hampshire, ILBuilt 1974 · S/N 22-0028 N7781MJamison Terry J · Fort Mcdowell, AZS/N 22-0029 N7782MEvans Richard C · Shepherd, MIBuilt 1974 · S/N 22-0030

Back to Mooney M20F