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.

N1015EBrown Richard T · Anaheim, CABuilt 1965 · S/N 255 N1220XBuilding Enclosure Institute Inc · Hallandale Beach, FLBuilt 1963 · S/N 191 N1223XAirspeed Consulting LLC · Mounds, OKBuilt 1963 · S/N 194 N1224XAlpha Aviation Mission Outreach Center Inc · Muskogee, OKBuilt 1963 · S/N 195 N1225XSuda Inc · Lindsborg, KSBuilt 1963 · S/N 196 N1227XVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N 198 N13TMSuntech LLC · St George, UTBuilt 1963 · S/N 115 N1909YDuncan Lori Ann · New Tazewell, TNBuilt 1964 · S/N 204 N1910YPeabody Riley A · Minnetonka, MNBuilt 1964 · S/N 205 N1912YFrokjer Dean C · Saint Croix Falls, WIBuilt 1964 · S/N 207 N1913YSchmitt William Joseph · Santa Cruz, CABuilt 1964 · S/N 208 N1915YJordan S Connor · Elizabeth City, NCBuilt 1964 · S/N 210 N1916YLarsen Adam P · Gresham, ORBuilt 1964 · S/N 211 N1917YMock Joseph R · Huntsville, TXBuilt 1964 · S/N 212 N1919YSu Ryan · Saint Augustine, FLBuilt 1964 · S/N 214 N191PALa Mooneytte LLC · Seabrook, SCBuilt 1964 · S/N 248 N1922YDurso Joseph M Jr · Mesa, AZBuilt 1964 · S/N 217 N1923YHyde Joe G · San Angelo, TXBuilt 1964 · S/N 218 N1924YHull Thomas · Midland, TXS/N 219 N1925YMapes Peter B · Oscoda, MIBuilt 1964 · S/N 220 N1926YRoss Dustin · Georgetown, TXBuilt 1964 · S/N 221 N193DRLinden Elizabeth M · Mc Farland, WIS/N 193 N1957YGuedon Aviation LLC · Natchez, MSBuilt 1964 · S/N 222 N1959YJam Aviation LLC · Wallace, MIBuilt 1964 · S/N 224 N1960YWhite Duwayne F · Hermiston, ORBuilt 1964 · S/N 225 N1961YWarnock Tony J · Mobile, ALS/N 226 N1962YRuther Jimmie M · Vacaville, CABuilt 1964 · S/N 227 N1963YLane Cary · Sapello, NMBuilt 1964 · S/N 228 N1964YPerry Shawn M · Springfield, OHS/N 229 N1965YSvoboda Patrick J · Bucyrus, KSBuilt 1964 · S/N 230 N1966YWeyhrich Dorothy · Windsor, COBuilt 1964 · S/N 231 N1969YBiggs Clifford G · Washington, UTS/N 234 N1971YMaurer Andrew · Pepper Pike, OHBuilt 1964 · S/N 236 N2738WMead James R · Jonesboro, ARBuilt 1966 · S/N 260 N31MAlley Shane C · Jackson, MOS/N 188 N428RBHouser Blue D · Edgemoor, SCBuilt 1963 · S/N 128 N5584QHurst Jonathan T · Seekonk, MABuilt 1964 · S/N 256 N6522UWilliamson Truman Dorman · Terrell, TXS/N 1 N6607UN6607u LLC · Commerce City, COBuilt 1963 · S/N 102 N6608URb II LLC · Walker, MNS/N 103 N6610UTreichler Peter DBA · East Aurora, NYBuilt 1963 · S/N 105 N6611UVan Koevering Dennis Jay · Hudsonville, MIBuilt 1963 · S/N 106 N6612UGiem James L · Coupeville, WABuilt 1963 · S/N 107 N6614UVanderford Kenneth W · Fort Worth, TXBuilt 1963 · S/N 109 N6615UDobos Lester J · Bordentown, NJBuilt 1963 · S/N 110 N6622UArmistead Jack R · Birmingham, ALBuilt 1963 · S/N 117 N6626UCramer Brett E · Sloughhouse, CABuilt 1963 · S/N 121 N6629UHanggee Sanford C · Aurora, COBuilt 1963 · S/N 124 N6630UBartholow Paul V · Santa Rosa, CABuilt 1963 · S/N 125 N6631UMitchell Caleb C · Hebron, NEBuilt 1963 · S/N 126

Back to Mooney M20D