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.

N9501MCasterline Douglas J · Kansas City, MOBuilt 1966 · S/N 670078 N9502MStorer Daniel A · Guthrie, OKBuilt 1966 · S/N 670079 N9503MCurell Kenneth E · Centerville, OHBuilt 1966 · S/N 670080 N9504MNawratil Nicholas · Richmond, TXBuilt 1966 · S/N 670081 N9505MLeahy Michael P · Downers Grove, ILBuilt 1966 · S/N 670082 N9507MSanford Russell G · Brooks, GABuilt 1966 · S/N 670084 N9511MBenjamin Joseph · Erie, COBuilt 1966 · S/N 670088 N9512MBible Larry · Mount Pleasant, TXBuilt 1966 · S/N 670089 N9513MHangar9llc · Queen Creek, AZBuilt 1966 · S/N 670090 N9514MHolen Benjamin E · Ketchum, IDBuilt 1966 · S/N 670091 N9515MReid Stephen M · Gardner, KSBuilt 1966 · S/N 670092 N9516MBurrell John Eric · Springfield, VABuilt 1966 · S/N 670093 N9518MPritchard Benjamin Ross · Cedar Rapids, IABuilt 1966 · S/N 670095 N9519MNiemeyer John P · Cortland, NEBuilt 1966 · S/N 670096 N9520MCoker Steve L Jr · Tyler, TXBuilt 1966 · S/N 670097 N9522MCrouch Mark W · Cumming, GABuilt 1966 · S/N 670099 N9525MVaughn Robert Bruce · Macon, GABuilt 1966 · S/N 670102 N9526MRegistered aircraftBuilt 1966 · S/N 670103 N9529MWilson Judy · Stamps, ARBuilt 1966 · S/N 670106 N9531MWright Bradley S · Quitaque, TXS/N 670108 N9533MHattensty Robert Wade · Burleson, TXBuilt 1966 · S/N 670110 N9535MGillman Charles J · Houston, TXBuilt 1966 · S/N 670112 N9537MWatts Brett M · Prescott, AZBuilt 1966 · S/N 670114 N9539MPfaltzgraff George E A · Solon Springs, WIBuilt 1966 · S/N 670116 N9540MBostrom Zachary J · Ballwin, MOBuilt 1966 · S/N 670117 N9543MReedy Coleman · Cool, CAS/N 670120 N9545MStull Ronald Wayne Jr · Ward, ARBuilt 1966 · S/N 670122 N9546MHood Michael T · Parrottsville, TNS/N 670123 N9547MDenig Daniel D · Albuquerque, NMBuilt 1966 · S/N 670124 N9548MPetersen Todd Anthony · Simi Valley, CABuilt 1966 · S/N 670125 N954NBreda John A · Needham, MABuilt 1968 · S/N 680131 N9550MAccess Chicago Inc · Orland Park, ILBuilt 1966 · S/N 670127 N9551MLoafman Michael A · Bowling Green, KYBuilt 1966 · S/N 670128 N9553MLolob Llp · Bozeman, MTBuilt 1966 · S/N 670130 N9554MJohnson Kevin L · Bowling Green, KYS/N 670131 N9555MCarroll Brendan O · Aloha, ORS/N 670132 N9556MVictory Lane Aviation LLC · Concord, NCBuilt 1966 · S/N 670133 N9559MPerez Hector R · Orange Park, FLBuilt 1966 · S/N 670136 N9560MPontarolo Michael A Trustee · Pacific Grove, CABuilt 1966 · S/N 670137 N9562MPhillips Gary C · Midland, MIBuilt 1966 · S/N 670139 N9564MCheung Charlotte · San Jose, CABuilt 1966 · S/N 670141 N9566MRegistered aircraftAssigned, pending cancellationS/N 670143 N9567MArrowline Holdings LLC · Brookfield, CTBuilt 1966 · S/N 670144 N9568MKinney William A · Missouri City, TXBuilt 1966 · S/N 670145 N9571MSale Reported · Sacramento, CASale reportedBuilt 1966 · S/N 670148 N9573MAndrews Geoffrey M · Stoneham, MABuilt 1966 · S/N 670150 N9576MRpm Commander Holdings Inc · Vero Beach, FLS/N 670153 N9577MStaton Jered · Rochester, MNBuilt 1966 · S/N 670154 N9580MRegistration Pending · Campbellsville, KYRegistration pendingBuilt 1966 · S/N 670157 N9584MKing Wesley C Jr · Dayton, OHBuilt 1966 · S/N 670161

Back to Mooney M20F