Skip to content

Registered aircraft · 88

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

N6634UC A F E Aviation LLC · Gregory, SDBuilt 1963 · S/N 129 N6635UBistline Ladell J Sr · Colorado City, AZS/N 130 N6636UBurcham Jaime S · Advance, NCBuilt 1963 · S/N 131 N6642UCrawford Daniel G Trustee · Dryden, MIBuilt 1963 · S/N 137 N6645UFreemont Investors Inc · Bainbridge Island, WAS/N 140 N6647UMouton Charles J Jr · Gladewater, TXBuilt 1963 · S/N 142 N6648URygs Air LLC · Andover, MNS/N 143 N6649UKuykendall William · Yantis, TXBuilt 1963 · S/N 144 N6650ULarson Reid A · Medford, MABuilt 1963 · S/N 145 N6651UWilliams Jerry L · Cortez, COBuilt 1963 · S/N 146 N6653URevisky Veronica F · Minooka, ILBuilt 1963 · S/N 148 N6654UHarbison Aerospace LLC · Whites Creek, TNBuilt 1963 · S/N 149 N6655UL & L Aviation LLC · Sidney, NES/N 150 N6656UFanselow Dan L · White Bear Lake, MNBuilt 1963 · S/N 151 N6659UHempy David · Lexington, KYBuilt 1963 · S/N 154 N6660UCruz Edgardo N · Lakeland, FLBuilt 1963 · S/N 155 N6735USawyer Dean A DBA · Kerrville, TXBuilt 1963 · S/N 161 N6740UJust Air LLC · Victorville, CABuilt 1963 · S/N 166 N6744UMelia Alexander A · Jacksonville, FLBuilt 1963 · S/N 170 N6786UCowboy Perspective LLC · Comanche, TXBuilt 1963 · S/N 172 N6787USpokane Community College · Spokane, WABuilt 1963 · S/N 173 N6788UHoughton Lawrence A · Rsm, CABuilt 1963 · S/N 174 N6790UFischer Jody M · Fargo, NDBuilt 1963 · S/N 176 N6791UWarburton Frank W · Ware, MABuilt 1963 · S/N 177 N6792ULancaster Bryce S · Plano, TXBuilt 1963 · S/N 178 N6793UBaynard Daryon Severino · Austin, TXBuilt 1963 · S/N 179 N6794UProphecy Place Properties LLC · Montgomery, ALS/N 180 N6823UClark Bradley K · Ypsilanti, MIBuilt 1963 · S/N 182 N6824ULefevre Duane S · Grover, WYS/N 183 N6825URipley Holdings Ltd · Santa Monica, CABuilt 1963 · S/N 184 N6827ULeong Thomas M · El Monte, CABuilt 1963 · S/N 186 N6830UJilek Dominic A · River Falls, WIBuilt 1963 · S/N 201 N6910UEmbrey Quentin S · Beaver Dam, KYBuilt 1964 · S/N 242 N6913UShaw Brian D · Meadville, PABuilt 1964 · S/N 245 N6914ULiskey John W · Kelseyville, CABuilt 1964 · S/N 246 N78861Wood Jeffrey A · Willis, TXS/N 253 N78877Obrien Garrett G · Sheep Ranch, CABuilt 1965 · S/N 254 N998NCHoppe Joel A · Fort Myers, FLBuilt 1964 · S/N 250

Back to Mooney M20D