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.

N5624QSwanson Shawn · South Beloit, ILBuilt 1965 · S/N 668 N5626QJustus League LLC · Los Angeles, CABuilt 1965 · S/N 669 N5636QKelly Thomas J · Henderson, TXBuilt 1965 · S/N 674 N5638QThomas E O'Gorman · Yreka, CABuilt 1965 · S/N 675 N5640QProps To You LLC · Mount Pleasant, SCBuilt 1965 · S/N 676 N5644QRichey Johnny · Shady Shores, TXBuilt 1965 · S/N 678 N5648QMartin Phil S · Colorado Springs, COBuilt 1965 · S/N 680 N5650QOrtland Richard James · Franklin, MIS/N 681 N5660QIcarus Air LLC · Austin, TXBuilt 1965 · S/N 686 N5662QMarshall Adam S · Spokane, WABuilt 1965 · S/N 687 N5668QKrzyszton Philip · Waumandee, WIBuilt 1965 · S/N 690 N5670QMiller Steven J · Fresno, TXBuilt 1965 · S/N 691 N5678QAndersen Allen E · Sandy Valley, NVBuilt 1965 · S/N 695 N5682QNagel Mildred J · Akron, OHS/N 697 N5686QBolton Nicolas · Murfreesboro, TNBuilt 1965 · S/N 699 N5692QOpen Air Aviation LLC · Colorado Springs, COBuilt 1965 · S/N 702 N5696QTrilogy Alliance Group LLC · Kearney, NEBuilt 1965 · S/N 762 N5697QReed Timothy W · Terrell, TXBuilt 1965 · S/N 815 N5698QCaughell David S · Bartlesville, OKBuilt 1965 · S/N 705 N5701QMalters James E · Fulda, MNBuilt 1965 · S/N 763 N5705QBlack David W Trustee · Redding, CAS/N 712 N5719QHiner Jeffrey N · Salt Lake City, UTBuilt 1965 · S/N 718 N5721QRawski Aviation LLC · Kingwood, TXBuilt 1965 · S/N 764 N5725QBaughman Air Service Inc · Stockton, KSBuilt 1965 · S/N 721 N5731QSomers James K Trustee · Montgomery, TXBuilt 1965 · S/N 724 N5733QBlue Skies Flying Club · Burien, WABuilt 1965 · S/N 725 N5735QBeler Arnold Ray II · Redlands, CABuilt 1965 · S/N 726 N5737QBross Stephen W · Burke, VABuilt 1965 · S/N 727 N5763QMach 1 Air Services LLC · Los Angeles, CABuilt 1965 · S/N 740 N5771QLuchterhand Charles · Salem, ORS/N 744 N5773QGunnerson Spencer · Murfreesboro, TNBuilt 1965 · S/N 745 N5775QSinger David · Vandalia, OHBuilt 1965 · S/N 746 N5781QFranklin Mountain Group Corp · Nashville, TNBuilt 1965 · S/N 749 N5785QSw Industry Inc · Wilmington, DEBuilt 1965 · S/N 751 N5789QWayden John R · El Paso, TXBuilt 1965 · S/N 873 N5795QStandard Charter LLC · Centennial Park, AZBuilt 1965 · S/N 756 N5799QHanson Bryan R · Shawnee, KSBuilt 1965 · S/N 758 N57CPBryant Stephen · Norwalk, OHBuilt 1966 · S/N 1135 N5805QLam Michael · Bellaire, TXBuilt 1965 · S/N 768 N5807QDavis Kevin B · Bellmawr, NJBuilt 1965 · S/N 769 N5809QSpicer Larry E · Milwaukee, WIS/N 770 N5811QElliott Areospace LLC · Kalispell, MTBuilt 1965 · S/N 771 N5813QWalmsley Stephen R Jr · Menifee, CABuilt 1965 · S/N 772 N5817QMcinnis Services LLC · O Brien, FLS/N 774 N5823QRegistered aircraftBuilt 1965 · S/N 777 N5825QHobgood Joel A · Sharpsburg, GABuilt 1965 · S/N 778 N5827QPromises LLC · Pompano Beach, FLBuilt 1965 · S/N 859 N5829QHenery L Bodmer Inc · Kenmare, NDBuilt 1965 · S/N 780 N5831QCueva Arturo A · Los Angeles, CABuilt 1965 · S/N 781 N5833QDyer Albert L · New Smyrna Beach, FLBuilt 1965 · S/N 782

Back to Mooney M20E