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.

N6359QMccurry Mack P · Weatherford, TXBuilt 1967 · S/N 670442 N6362QHanley Clint · Edgewood, NMBuilt 1967 · S/N 670445 N6363QLawrence John C · Belle Chasse, LABuilt 1967 · S/N 670446 N6366QLibre Air LLC · Norfolk, VABuilt 1967 · S/N 670449 N6370QDesert Breeze Aviation LLC · Phoenix, AZBuilt 1967 · S/N 670453 N6371QJones Stephen D · Pittsburg, TXBuilt 1967 · S/N 670454 N6372QKelley David L · Vincent, OHBuilt 1967 · S/N 670455 N6375QIngram Jeffrey C · Penn Valley, CABuilt 1967 · S/N 670458 N6376QMccallson Bailey · Bethel, AKBuilt 1967 · S/N 670459 N6377QBuntenbach Stefan · Port Orange, FLBuilt 1967 · S/N 670460 N6380QBiederman Clifton E · Jasper, FLBuilt 1967 · S/N 670463 N6381QMelnykov Ivan · Aliso Viejo, CABuilt 1967 · S/N 670464 N6382QAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1967 · S/N 670465 N6384QFurleigh Dwight D · Tonica, ILBuilt 1967 · S/N 670467 N6388QSchatz Brook J · Lewiston, IDS/N 670471 N6389QRegistered aircraftBuilt 1967 · S/N 670472 N6390QEgolf Stephen L · Tyngsboro, MABuilt 1967 · S/N 670473 N6391QDiamond V Corp · Glendive, MTS/N 670474 N6393QMarsh John E · Washington, DCS/N 670476 N6395QPeterson Glenn W · Roseville, CABuilt 1967 · S/N 670478 N6398QRegistered aircraftBuilt 1967 · S/N 670481 N6410QBorreson Anthony · Reno, NVBuilt 1967 · S/N 670489 N6413QMassey Thomas H · Montgomery, TXBuilt 1967 · S/N 670492 N6414QHolmes Eric Bradley · Campbell, CABuilt 1967 · S/N 670493 N6415QWestern Plaines Aviation LLC · Greeley, COBuilt 1967 · S/N 670494 N6419QFranklin Brian K · Lakewood Ranch, FLBuilt 1967 · S/N 670498 N6420QKelley Richard E · Spring Branch, TXBuilt 1967 · S/N 670499 N6421QShine Christopher A · Mammoth Lakes, CABuilt 1967 · S/N 670500 N6423QDowns Jimmy · Borger, TXBuilt 1967 · S/N 670502 N6426QSable Jared · Butler, PABuilt 1967 · S/N 670505 N642DGTubular Products Of Texas Inc · Tomball, TXBuilt 1966 · S/N 670158 N6430QMellor James F · Spanish Fork, UTS/N 670509 N6431QTruitt John M · Fishers, INBuilt 1967 · S/N 670510 N6433QParatus Air Inc · Auburn, INBuilt 1967 · S/N 670512 N6437QPeck Carl R · Huntsville, ALBuilt 1967 · S/N 670516 N6441QMccready Steven Scott Trustee · Los Alamos, NMBuilt 1967 · S/N 670520 N6442QFord Jeremy · Las Vegas, NVS/N 670521 N6447QP&M Enterprises LLC · North Charleston, SCBuilt 1967 · S/N 670526 N6448QMicheliche Robert B · Federalsburg, MDBuilt 1967 · S/N 670527 N6451QRoss Terry J · Cibolo, TXBuilt 1967 · S/N 670530 N6452QBennett Bruce R · Lexington, KYBuilt 1967 · S/N 670531 N6454QKyle Robert L · Clinton, OHBuilt 1967 · S/N 670533 N6456QLeehey Studio LLC · Santa Monica, CABuilt 1967 · S/N 670535 N6457QRegistered aircraftBuilt 1967 · S/N 670536 N6460QDel Gado Raul L · Victorville, CABuilt 1967 · S/N 670539 N6461QGanos Christ · Brookfield, WIBuilt 1967 · S/N 680003 N6462QPlummer Joshua · Fort Mill, SCBuilt 1967 · S/N 680004 N6465QLeckrone Steven R Trustee · Mustang, OKS/N 680007 N6466QSherrod Paul A Jr · Opelika, ALBuilt 1967 · S/N 680008 N6469QBurl Jeffrey B · Hancock, MIBuilt 1967 · S/N 680011

Back to Mooney M20F