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.

N6856VHudson Daryl J · Ukiah, CABuilt 1975 · S/N 22-1249 N6857VBerry Mark · Ellenboro, NCBuilt 1975 · S/N 22-1250 N6861VJ & B Aero Inc · Albuquerque, NMBuilt 1975 · S/N 22-1254 N6863VCarr James Bradley · Hazlehurst, MSS/N 22-1256 N6868VSign Maxx LLC · Larksville, PAS/N 22-1261 N6870VRegistration Pending · Santa Cruz, CARegistration pendingBuilt 1975 · S/N 22-1263 N6872V36 Delta Delta LLC · Albany, GABuilt 1975 · S/N 22-1265 N6875VSmolko Tod A · Greensboro, NCBuilt 1975 · S/N 22-1268 N6879VBurke Jonathan · Berkeley, CABuilt 1975 · S/N 22-1272 N6887VHackett Troy D · Riverton, WYBuilt 1975 · S/N 22-1274 N6888VShepherd Jeffrey W · Woodlawn, TNBuilt 1975 · S/N 22-1275 N688RMBurton Jason S · Howell, MIBuilt 1967 · S/N 670272 N6892VFindlay Christopher R · Newark, DEBuilt 1975 · S/N 22-1279 N6893VJabes Aviation LLC · Spring Branch, TXBuilt 1975 · S/N 22-1280 N6894VFlync LLC · Charlotte, NCBuilt 1975 · S/N 22-1281 N6897VZottarelli Sean · Fountain Hill, PABuilt 1975 · S/N 22-1284 N6899VRomo 2.0 LLC · Lander, WYBuilt 1975 · S/N 22-1286 N68LCDriver Matthew · Rio Rancho, NMBuilt 1966 · S/N 670243 N6902VRegistered aircraftBuilt 1975 · S/N 22-1288 N6910VLehman Aubrey M · Temple, TXS/N 22-1290 N6914VDuke Terri D · Oakwood, GABuilt 1975 · S/N 22-1294 N6915VReindollar William Paul Jr · Derwood, MDBuilt 1975 · S/N 22-1295 N6917VCamper Daniel P II · Port Angeles, WABuilt 1975 · S/N 22-1297 N6919VKimzey Robert R · Cypress, TXBuilt 1975 · S/N 22-1299 N6920VPjs Enterprises · Havre, MTBuilt 1975 · S/N 22-1300 N6921VLebow Kirk · Clovis, NMBuilt 1975 · S/N 22-1301 N6923VNicastro Michael L · Gloucester, MABuilt 1975 · S/N 22-1303 N6924VBramer Aviation LLC · Middleburg, PABuilt 1975 · S/N 22-1304 N6925VMay Michael S · Axtell, NES/N 22-1305 N6936VRamayana Aviation LLC · Mount Pleasant, SCBuilt 1975 · S/N 22-1309 N6937VBarcklay Donald · Shingle Springs, CABuilt 1975 · S/N 22-1310 N6939VSchamber George · Lander, WYFirst renewal noticeBuilt 1975 · S/N 22-1312 N6943VTucker Pamela S · Hutto, TXBuilt 1975 · S/N 22-1316 N6944VJohnson Shawn Tyler · Forney, TXBuilt 1975 · S/N 22-1317 N6945VVogelsang David R · Lake Oswego, ORS/N 22-1318 N6947VGutierrez Juan · Sarasota, FLBuilt 1976 · S/N 22-1320 N6948VJendrisak Joseph P · Belmont, NCBuilt 1975 · S/N 22-1321 N6949VPaul Kevin A · Belgrade, MTS/N 22-1322 N6952VN6952v LLC · Clearwater, FLBuilt 1975 · S/N 22-1325 N6961VHunt David · Burlington, IABuilt 1975 · S/N 22-1328 N6962VRez Peter Trustee · Scottsdale, AZBuilt 1976 · S/N 22-1329 N6963VBlough Lynn M · Pittsburgh, PABuilt 1976 · S/N 22-1330 N6964VDavis Thomas Leigh · Carrollton, TXBuilt 1976 · S/N 22-1331 N6966VBullard Joseph · Saint Louis, MOBuilt 1976 · S/N 22-1333 N6967VMile High Air LLC · Holland, MIS/N 22-1334 N6968VArnold Norman K · Fayetteville, ARBuilt 1976 · S/N 22-1335 N6971VGreen Nathan E · Flower Mound, TXBuilt 1976 · S/N 22-1338 N6974VRegistered aircraftBuilt 1976 · S/N 22-1341 N6975VRodmark Aviation LLC · Jupiter, FLBuilt 1976 · S/N 22-1342 N6982VTwardowski Przemyslaw · Pasadena, CABuilt 1976 · S/N 22-1344

Back to Mooney M20F