Skip to content

Registered aircraft · 721

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

N7783MOrourke James Kevin · Omaha, NES/N 22-0031 N7785MPalermo Michael S · Carter Lake, IABuilt 1974 · S/N 22-0033 N7787M628 Investments LLC · Stanley, NDBuilt 1974 · S/N 22-0035 N7798MFessler Brian Clark · Centennial, COBuilt 1974 · S/N 22-0040 N7799MMazzillo Paul J · Madeira Beach, FLBuilt 1974 · S/N 22-0041 N789LCEquity Property Group LLC · Welch, OKBuilt 1976 · S/N 22-1337 N803RMAs Filed LLC · Culver City, CABuilt 1969 · S/N 690039 N8040EHolt Todd E · Delta, UTBuilt 1968 · S/N 680015 N810MMSale Reported · Shreveport, LASale reportedBuilt 1969 · S/N 690020 N811SSFarabaugh Mark · San Diego, CABuilt 1967 · S/N 670064 N84ABBald Eagle Aero LLC · Chesapeake, VABuilt 1967 · S/N 670461 N862HLWilliams Michael D · Midlothian, TXBuilt 1974 · S/N 22-0075 N89LWClose Bert W · Peachtree City, GABuilt 1967 · S/N 680096 N9002NJohnson Lawrence F · Anchorage, AKBuilt 1966 · S/N 670021 N9056VBare David · Colorado Springs, COBuilt 1968 · S/N 690004 N9057VBrossard Pierre · New Albany, MSBuilt 1968 · S/N 690005 N9058VPellikan Jake E · Staten Island, NYBuilt 1968 · S/N 690006 N9062VJacobsen Dennis S · Reno, NVBuilt 1968 · S/N 690009 N9064VMitchell Benjamin · Riverdale, UTBuilt 1968 · S/N 690010 N9068VPyle Brian D · Mooresville, NCBuilt 1968 · S/N 690012 N9070VPinneo Mark · Foley, ALBuilt 1968 · S/N 690013 N9074VLounsbury Joseph Jr · Palm Coast, FLBuilt 1968 · S/N 690015 N9076VRegistration Pending · Morristown, TNRegistration pendingBuilt 1969 · S/N 690016 N9084VLinear Air LLC · Herriman, UTBuilt 1968 · S/N 690018 N9097VKnutson Alan R · Chaska, MNBuilt 1969 · S/N 690021 N9103VMullis Stephen P Jr · Hazlehurst, GABuilt 1969 · S/N 690022 N9113VBarry Dustin Michael · Highland, ILBuilt 1969 · S/N 690026 N9115VBovo Paolo · San Benito, TXBuilt 1969 · S/N 690027 N9117VEdgerton Bruce M · Ottsville, PABuilt 1969 · S/N 690028 N911MBHarry Thomas C · Boiling Springs, PABuilt 1966 · S/N 670042 N9121VDelta Tango Golf LLC · San Angelo, TXBuilt 1969 · S/N 690029 N9125VLuymes Kirk M · Wessington Springs, SDBuilt 1969 · S/N 690030 N9135VPierro Darrell · Cohasset, CABuilt 1969 · S/N 690033 N9147VN206ht LLC · Pulaski, IABuilt 1969 · S/N 690037 N9150VUrness John · Oakland, CABuilt 1969 · S/N 690038 N9158VMellinger David S · Lusby, MDBuilt 1969 · S/N 690040 N9165VJohnson Michael · Huntington Beach, CABuilt 1969 · S/N 690041 N9168VSnow James W · Avon, INS/N 690042 N9171VMau Allen D · Stockton, CABuilt 1969 · S/N 690044 N9188VValiair Limited Co Trustee · Casper, WYBuilt 1969 · S/N 690049 N9196VScherbarth Kenneth C · Eatonville, WABuilt 1969 · S/N 690051 N9203VInnovative Poultry Products LLC · Olar, SCBuilt 1969 · S/N 690053 N9205VBlaylock James · Las Vegas, NVS/N 690054 N9212VKocher Edward A · Longview, TXBuilt 1969 · S/N 690057 N9223VQuick Janice L · Wrightwood, CABuilt 1969 · S/N 690060 N9230VCloud Surfing Aviation LLC · Costa Mesa, CAS/N 690062 N9233VRenner David C Jr · Belleville, ILBuilt 1969 · S/N 690063 N9243VRedtail Holdings LLC · Mountain Home, ARBuilt 1969 · S/N 690065 N9248VBoardman Thomas M · Greenwich, NYBuilt 1969 · S/N 690068 N9264VSly David P · Nevada, IAS/N 690073

Back to Mooney M20F