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.

N1316WKurek Daniel L · Garden City, UTBuilt 1963 · S/N 204 N1317WMorgenfeld Thomas A · Camarillo, CABuilt 1963 · S/N 205 N1320WBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 208 N1327WHexom Nathan R · Bozeman, MTBuilt 1963 · S/N 215 N1329WKasowski Frank Jr · Becker, MNBuilt 1963 · S/N 217 N1330WPepke Mark · Memphis, TNBuilt 1963 · S/N 218 N1332WRegistered aircraftBuilt 1963 · S/N 220 N1333WJamieson Robert A · Titusville, FLBuilt 1963 · S/N 221 N1334WTwo Way Communications LLC · Graham, TXBuilt 1963 · S/N 222 N1335WCastanon Salvador L · Rancho Cucamonga, CABuilt 1963 · S/N 223 N1336WThree Six Whiskey LLC · Billings, MTS/N 224 N1337WTriple Tree Aerodrome Inc · Woodruff, SCBuilt 1963 · S/N 225 N1339W39 Whiskey LLC · Clovis, NMBuilt 1963 · S/N 227 N1340WJohnson Jon · El Paso, TXBuilt 1963 · S/N 228 N141TTActon Paul W · Blue Mound, KSBuilt 1965 · S/N 591 N142EJAskwig Michael C · Lincoln, MIS/N 372 N151DB1 Zero Sierra Whisky LLC · Helena, MTBuilt 1965 · S/N 832 N165AZBoyko Flying Services LLC · Ruso, NDBuilt 1964 · S/N 433 N16DRHibner Christopher J · Canton, MIBuilt 1964 · S/N 416 N17ADOlear Daniel J · Warren, MIBuilt 1968 · S/N 690008 N184JLPeters Bryan · Corpus Christi, TXBuilt 1963 · S/N 129 N188GHAer Lightfoot LLC · Alpena, MIBuilt 1964 · S/N 525 N18JKTalley Warbirds Inc · Longview, TXBuilt 1969 · S/N 690020 N1902YFlowers John H · Laurel, MSBuilt 1964 · S/N 287 N1928YMaddex William E · Battle Ground, WAS/N 235 N1932YDriver L Spence · Bay City, WIBuilt 1964 · S/N 239 N1934YMack Anita · Scott Afb, ILBuilt 1964 · S/N 241 N1935YHodges William L Jr · Spotsylvania, VABuilt 1964 · S/N 289 N1937YTirado Josue · Pembroke Pines, FLBuilt 1964 · S/N 244 N1939YMcconnell Kristopher P · Nampa, IDFirst renewal noticeBuilt 1964 · S/N 246 N1940YMiller Rollie R · Dillon, MTBuilt 1964 · S/N 247 N1944YHolcombe Thomas Hg · Moss, TNBuilt 1964 · S/N 251 N1946YTrimmer Benjamin M · Tomball, TXBuilt 1964 · S/N 253 N1948YGregory Michael Rybarczyk · West Chester, OHBuilt 1964 · S/N 255 N1949YHawkins Robert A · Lake Butler, FLBuilt 1964 · S/N 256 N1952YVess Derek Wayne · Kempner, TXBuilt 1964 · S/N 259 N1953YDavid Michael B · Miami Beach, FLBuilt 1964 · S/N 260 N1955YBeckworth Willis S · Gonzales, LABuilt 1964 · S/N 262 N1975LClarke Ted · La Luz, NMBuilt 1965 · S/N 673 N1977YTrychon Stephen A · Sterling, MABuilt 1964 · S/N 264 N1978YMeinert Matthew A · Columbia, MOFirst renewal noticeBuilt 1964 · S/N 265 N1980YJorgensen Sarah B · Anchorage, AKS/N 267 N1982YSale Reported · Mount Pleasant, SCSale reportedBuilt 1964 · S/N 269 N1987YTipton Inc · Turners Station, KYBuilt 1964 · S/N 274 N1988YReyst Derek C · Manchester, MIBuilt 1964 · S/N 275 N1990YRitt Karl T · El Paso, TXBuilt 1964 · S/N 277 N1991YRoise Jondavid G · Minot, NDBuilt 1964 · S/N 418 N1994YWeisinger Jason Aaron · Kyle, TXBuilt 1964 · S/N 281 N1995YGilliam Joel A · London, KYS/N 282 N1997YMcculley Lowell Bruce · Front Royal, VABuilt 1964 · S/N 284

Back to Mooney M20E