Skip to content

Registered aircraft · 829

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

N9307MCassling Edward F · Newark Valley, NYBuilt 1966 · S/N 1240 N9308MDegraaf Derrick B · Manteca, CABuilt 1966 · S/N 1241 N9311MShamshir LLC · Lake Havasu City, AZBuilt 1966 · S/N 1244 N9312MSteinman Marc J · Frankfort, ILBuilt 1966 · S/N 1245 N9313M9313 Mike Inc · New Smyrna Beach, FLBuilt 1966 · S/N 1246 N9315MTwo Dog Aviation LLC · Bismarck, NDBuilt 1966 · S/N 1248 N9316VBorghi Robert J · Leonia, NJBuilt 1969 · S/N 690071 N9319MCulberson Donald L · Bedford, TXBuilt 1966 · S/N 1251 N9320MMoreau Donald G · Dayton, TXBuilt 1966 · S/N 1252 N9322MQuebedeaux Rentals LLC · Deridder, LAS/N 1254 N9323MMichael Siewert · Columbus, OHS/N 1255 N9324MMcdonald Glenn · Uvalde, TXS/N 1256 N9324VPontoni Development Corp · Athens, MIS/N 690073 N9326MWoods Brian S · Longview, TXBuilt 1966 · S/N 1258 N9327MChristensen Seth T · Hurricane, UTBuilt 1966 · S/N 1259 N9328MBeauchamp Michael · Las Vegas, NVBuilt 1966 · S/N 1260 N9329MSreffler Christine · Ballwin, MOBuilt 1966 · S/N 1261 N9332MKasakoff Lloyd · Diamond Bar, CAS/N 1264 N9333MMalaka Air LLC · Bradenton, FLBuilt 1966 · S/N 1265 N9334MLee Gary L · Aberdeen, IDBuilt 1966 · S/N 1266 N9334VSwope William T · Georgetown, OHS/N 700003 N9335MPerry Christopher T · Eugene, ORBuilt 1966 · S/N 1267 N9336MRioux Roger J · Corpus Christi, TXBuilt 1966 · S/N 1268 N9338VDheedene Nicholas · San Mateo, CABuilt 1969 · S/N 700004 N9340MWeidner Mark · Cincinnati, OHBuilt 1966 · S/N 1272 N9341MGabel Mark E · Oxnard, CABuilt 1966 · S/N 1273 N9342VClute Charles J · New Smyrna Beach, FLBuilt 1969 · S/N 700005 N9343MStateline Trucking Inc · Fruita, COBuilt 1966 · S/N 1275 N9345MMichael Matthew C · Ames, IABuilt 1966 · S/N 1277 N9348MSauter Ross S · Cleveland, OKBuilt 1966 · S/N 1280 N9350MPella Technology Services Inc · Pella, IABuilt 1966 · S/N 1282 N9351MKempa Jesse R · Santa Cruz, CABuilt 1966 · S/N 1253 N9351VCaldararu Andrei H · Madison, WIBuilt 1969 · S/N 700008 N9353MBarnett Zachary P · Paducah, KYBuilt 1966 · S/N 1285 N9354MFresh Air Properties LLC · Hayesville, NCBuilt 1966 · S/N 1286 N9354VPinckney Robert L · Elgin, SCBuilt 1969 · S/N 700009 N9356MRegistered aircraftBuilt 1966 · S/N 1288 N9357MSpencer Jared · Mandeville, LABuilt 1966 · S/N 1289 N9359MStrohacker Louis W · Kerrville, TXS/N 1291 N9361MR&D Mooney Inc · Osprey, FLBuilt 1966 · S/N 1293 N9362VYoon Philip K O · El Cajon, CABuilt 1969 · S/N 700011 N9363MBaas John M · Rapid City, SDS/N 1295 N9364MShelton Douglas S · Kingsville, MDBuilt 1966 · S/N 1296 N9366MHouse Oscar · Wakefield, RIS/N 1298 N9367MGriffith Jason R · Guyton, GABuilt 1966 · S/N 1299 N9372VFendley Bobby G · Fair Play, SCS/N 700013 N9373MKelly Andrew J · Shirley, ARBuilt 1966 · S/N 1305 N9374MRoberts Terry L · Bolt, WVBuilt 1966 · S/N 1306 N9375MSweeney David J · Portland, ORBuilt 1966 · S/N 1307 N9392VBeard Bros Aviation LLC · Wilmington, DES/N 700018

Back to Mooney M20E