Skip to content

Registered aircraft · 1,258

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

N5613QLysek Eric M · Erie, COBuilt 1965 · S/N 3005 N5615QKhan Awad A · Clearwater, FLBuilt 1965 · S/N 3103 N5617QRegistration Pending · Perryton, TXRegistration pendingBuilt 1965 · S/N 3007 N5621QOwens Ronald W · Newburgh, INS/N 3009 N5625QFly High Aviation LLC · Margate City, NJBuilt 1965 · S/N 3011 N5631QBayette Andrew · Calhan, COBuilt 1965 · S/N 3014 N5633QKeene John D · Spotsylvania, VABuilt 1965 · S/N 3015 N5649QTaylor Clayton T · Stockton, KSBuilt 1965 · S/N 3023 N5651QKingdom Air LLC · Diamondhead, MSBuilt 1965 · S/N 3024 N5655QJamil Mohammad Mahbub · Stockton, CABuilt 1965 · S/N 3026 N5657QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1965 · S/N 3027 N5659QKlempel Reuel David · Eltopia, WAS/N 3028 N5663QCullen Andrew W · Tennille, GAS/N 3030 N5667QLove Phillip Love · Rib Mountain, WIBuilt 1965 · S/N 3032 N5669QMills James A · Dearborn, MIBuilt 1965 · S/N 3033 N5673QBrown Maxwell · Palm Springs, CABuilt 1965 · S/N 3035 N5674QPac Hollow Flyers LLC · Omaha, NEBuilt 1965 · S/N 3105 N5675QZeigler Matthew James · Fairfax Station, VABuilt 1965 · S/N 3036 N5677QDeramus Doris L Executor · El Paso, TXS/N 3037 N5679QLambert John D · El Paso, TXBuilt 1965 · S/N 3038 N5681QSteixner Jessica M · Madison, TNBuilt 1965 · S/N 3039 N5687QRegistered aircraftBuilt 1965 · S/N 3042 N5689QReynolds Shawn E · Ventura, CAS/N 3043 N5693QKaufman Ben · Liberty, UTBuilt 1965 · S/N 3045 N5695QBabb Douglas L · Telford, PABuilt 1965 · S/N 3046 N5702QBailey Jacob Kyle · Rosharon, TXBuilt 1965 · S/N 3053 N5706QKnox James · Perryton, TXBuilt 1965 · S/N 3055 N5708QLowry Gregory A · Beaufort, SCBuilt 1965 · S/N 3056 N5710QHopper Ronald W · Thousand Oaks, CABuilt 1965 · S/N 3057 N5712QChambliss Walton Aviation Enterprises LLC · Greer, SCBuilt 1965 · S/N 3058 N5716QEdick Thomas M · Wasco, CABuilt 1965 · S/N 3060 N5722QMyers Shawn · Louisville, KYBuilt 1965 · S/N 3063 N5726QAllen Colin S · Leonardtown, MDBuilt 1965 · S/N 3065 N5728QKuss Luke A · Hutto, TXBuilt 1965 · S/N 3066 N5732QAir Lords Inc · Middletown, DEBuilt 1965 · S/N 3068 N5736QWard Troy · Odessa, TXS/N 3070 N5738QGuillen Gregorio J · Lopatcong, NJS/N 3071 N5739QMorell Timothy S · Lino Lakes, MNBuilt 1965 · S/N 3108 N5740QOasis Aero Inc · Willmar, MNBuilt 1965 · S/N 3072 N5745QHuseman Joseph F · De Witt, IABuilt 1965 · S/N 3159 N5746QKing Jeremy · Sandy Springs, GAS/N 3075 N5750QMelnyk Richard V · Uniontown, PABuilt 1965 · S/N 3077 N5752QJackson John E · Oak Harbor, WABuilt 1965 · S/N 3078 N5754QHamm Martin C · Southport, NCBuilt 1965 · S/N 3079 N5756QDominguez Juan · Austin, TXBuilt 1965 · S/N 3080 N5758QAviation Forza Inc · Pompano Beach, FLS/N 3081 N5760QHill Jonathan Troy · Taylorsville, KYBuilt 1965 · S/N 3082 N5762QCross Brian K · Winters, CABuilt 1965 · S/N 3083 N5764QJas Aircraft LLC · Summerland Key, FLS/N 3084 N5766QSalmon Jerome L · Albany, NYS/N 3085

Back to Mooney M20C