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.

N5770QJohnson Darryl · Fowler, COBuilt 1965 · S/N 3087 N5772QTweten Gary L · Glasgow, MTS/N 3088 N5778QPars Avn Corp · Wilmington, DEBuilt 1965 · S/N 3091 N5780QMuegge Erik L · Keller, TXBuilt 1965 · S/N 3092 N5782QSkylions LLC · Wichita, KSBuilt 1965 · S/N 3093 N5784QArias Raymond G · Wesley Chapel, FLS/N 3094 N5786QMartinez Todd P · Vacaville, CABuilt 1965 · S/N 3095 N5788QMccabe David P · Tower, MNBuilt 1965 · S/N 3096 N5790QSurman Stephen · Draper, UTBuilt 1965 · S/N 3097 N5792QScott David L · Nampa, IDS/N 3098 N5796QFortier Jeremy · Alma, ARBuilt 1965 · S/N 3100 N5798QBradley Brian · Las Vegas, NVBuilt 1965 · S/N 3101 N57CVMarsico Gary W · Poland, OHBuilt 1963 · S/N 2634 N5804QMoffet Jeffrey C · Lawrence, KSS/N 3111 N5808QSaathoff Michael A · Stockton, MOBuilt 1965 · S/N 3113 N5816QHigh Flying Vision LLC · Clarksdale, MSBuilt 1965 · S/N 3117 N581SBHudson Harold Daniel · Williamsburg, VABuilt 1965 · S/N 3115 N5820QSmith Douglas C · Lewisville, TXBuilt 1965 · S/N 3119 N5822QKnudsen Ernst W · Ennis, TXBuilt 1965 · S/N 3120 N5824QTss-Glass Machinery Sales Inc · Fort Worth, TXS/N 3121 N5826QN5826q LLC · Sheridan, WYBuilt 1965 · S/N 3122 N5828QGreater Cincinnati Aero Club LLC · Alexandria, KYBuilt 1965 · S/N 3123 N5832QHli Aviation LLC · Red Banks, MSBuilt 1965 · S/N 3125 N5834QGill Harold P · Bolton, MABuilt 1965 · S/N 3126 N5842QBradford Michael · San Jose, CABuilt 1965 · S/N 3130 N5846QGardner Perry F · East Canaan, CTBuilt 1965 · S/N 3132 N5848QValenti Edgar M · Gig Harbor, WABuilt 1965 · S/N 3133 N5850QMcmoran Donald W · Mount Vernon, WAS/N 3134 N5852QOldham Jared K · Richfield, WIBuilt 1965 · S/N 3135 N5854QAlley Shane C · Jackson, MOS/N 3136 N5856QDison Timothy A · Nolensville, TNS/N 3137 N5860QBurton Karlis · Cantonment, FLBuilt 1965 · S/N 3139 N5866QBdo Aviation LLC · Dallas, TXBuilt 1965 · S/N 3141 N5868QGilpatric David L · Winchester, MABuilt 1965 · S/N 3142 N5870QScott Stewart · Columbia, MOBuilt 1965 · S/N 3143 N5872QAir Mods And Repair Inc · Robbinsville, NJBuilt 1965 · S/N 3144 N5876QJonesmont Air LLC · Taylor, AZBuilt 1965 · S/N 3146 N5880QSeely Scott · Edmond, OKBuilt 1965 · S/N 3148 N5882QBean Merton H III · Phoenix, AZBuilt 1965 · S/N 3149 N5884QOasis Aero Inc · Willmar, MNS/N 3150 N5888QCross The Line Sales Inc · Lexington, NCBuilt 1965 · S/N 3152 N5890QDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1965 · S/N 3153 N5894QBlech Fritz · Grants Pass, ORBuilt 1965 · S/N 3155 N5898QO'Neal Timothy L · Damascus, ORBuilt 1965 · S/N 3157 N58LRRush Hal Lee Jr · Oneonta, ALBuilt 1965 · S/N 2942 N5901QSpringer Jesse J · Avon, MNBuilt 1965 · S/N 3160 N5903QPressley Brent DBA · Morristown, TNBuilt 1965 · S/N 3186 N5905QWainwright Mitchell J · Saint Charles, MOBuilt 1965 · S/N 3161 N5911QFuller Christopher · Ottsville, PABuilt 1965 · S/N 3164 N5915QHaslem Patrick S · Dimondale, MIBuilt 1965 · S/N 3166

Back to Mooney M20C