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.

N6984VEitzmann Bryce J · Clinton, ARBuilt 1976 · S/N 22-1346 N6987VHyde Reginald · Helena, ALBuilt 1976 · S/N 22-1349 N6988VGreenlee Matthew Steven · Arnold, CABuilt 1976 · S/N 22-1350 N6989VFussell James Vaulx V · Jackson, MSS/N 22-1351 N6990VRegistration Pending · Shelby Township, MIRegistration pendingS/N 22-1361 N6994VKroutil David W · Hilmar, CABuilt 1976 · S/N 22-1356 N6995VHausmann Internaational Inc · Sugar Land, TXBuilt 1976 · S/N 22-1357 N6997VThatcher William J · Fort Dodge, IABuilt 1976 · S/N 22-1359 N7010VCompass Aviation Maintenance LLC · Shelby, NCBuilt 1976 · S/N 22-1362 N7013VForsman Robert J · Yelm, WABuilt 1976 · S/N 22-1365 N7014VAshland Cycle Center Inc · Catlettsburg, KYBuilt 1976 · S/N 22-1366 N7016VHotel Charlie Aero LLC · Marshville, NCBuilt 1976 · S/N 22-1368 N7017VHenry R Rey Ltd · Fresh Meadows, NYS/N 22-1369 N7018VHausser Joel S · Greeneville, TNBuilt 1976 · S/N 22-1370 N7019VA & L Aviation LLC · Little Falls, MNBuilt 1976 · S/N 22-1371 N7020VHarris Robert W · Friendswood, TXBuilt 1976 · S/N 22-1372 N7026VClear Ayr LLC · Texarkana, TXBuilt 1976 · S/N 22-1373 N7027VJohnson Marvin D · Gilbert, AZBuilt 1976 · S/N 22-1374 N7028Registered aircraftBuilt 1976 · S/N 22-1375 N7029VGochee Peter A · Kansas City, MOBuilt 1976 · S/N 22-1376 N7034VBixler Adam D · New Prague, MNBuilt 1976 · S/N 22-1381 N7036VArnold Michael Trustee · Callahan, FLBuilt 1976 · S/N 22-1383 N7037VMonyvuth Sin · Signal Hill, CABuilt 1976 · S/N 22-1384 N7041VHigh Drag Low Speed LLC · Granbury, TXS/N 22-1388 N7042VJ Bird Jeff Leopard LLC · Longmont, COBuilt 1976 · S/N 22-1389 N7043VSwatloski Richard P · Acworth, GABuilt 1976 · S/N 22-1390 N7049VBiederman Scott J · Boca Raton, FLS/N 22-1391 N7051VAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N 22-1393 N7054VSutton Jeffrie · Slidell, LAS/N 22-1396 N7056VRaw Logistics LLC · Bethel, NCBuilt 1976 · S/N 22-1398 N7059VJsb LLC · Chippewa Falls, WIBuilt 1976 · S/N 22-1401 N7060VRichardson Kaily S · Stanton, TXBuilt 1976 · S/N 22-1402 N7077VHerrenkohl Robert D · Bay Point, CABuilt 1976 · S/N 22-1413 N7079VStrandberg Kevin L · Pennock, MNBuilt 1976 · S/N 22-1415 N7093VGary Robert M · Folsom, CABuilt 1976 · S/N 22-1421 N7094VMason Gary W · Rockledge, FLBuilt 1976 · S/N 22-1422 N7114VCross Wings Aviation LLC · San Antonio, TXBuilt 1974 · S/N 22-0049 N7122VProvance Brent L · Granbury, TXBuilt 1974 · S/N 22-0051 N7124VHunter Cameron Brooks · Keller, TXBuilt 1974 · S/N 22-0053 N7125VSutphen James A · Henderson, TXBuilt 1974 · S/N 22-0054 N7127VChenal Robert B · Pawcatuck, CTBuilt 1974 · S/N 22-0056 N7128VLinville Aero LLC · Chapel Hill, NCBuilt 1974 · S/N 22-0057 N7130VKerkstra Hilary · Portage, MIBuilt 1974 · S/N 22-0059 N7142VTarantino Joseph A · Daytona Beach, FLBuilt 1974 · S/N 22-0061 N7144VJs&J Enterprises LLC · Sapulpa, OKBuilt 1974 · S/N 22-0063 N7148VSs Viking LLC · Saint Augustine, FLS/N 22-0067 N7149VLeghorn Aero Services LLC · Waynesboro, VABuilt 1974 · S/N 22-0068 N714VWMoore Harry L · Richardson, TXBuilt 1967 · S/N 670441 N7161VKenney Anthony G · Oviedo, FLFirst renewal noticeBuilt 1974 · S/N 22-0070 N7163VRegistered aircraftBuilt 1974 · S/N 22-0072

Back to Mooney M20F