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.

N2789WShort Robert N II · Lincoln, CABuilt 1966 · S/N 1169 N2790WMoondogger LLC · Yakima, WAS/N 1068 N2791WToothman John · Fairmont, WVS/N 1069 N2796WPennington Jeffrey B · Wrightwood, CABuilt 1966 · S/N 1072 N2797WWebb John H Jr · Paulding, OHBuilt 1966 · S/N 1073 N28XArdis Mitchell Farm LLC · Winnsboro, TXBuilt 1964 · S/N 347 N300MDHeywood Bruce N · Panguitch, UTS/N 400 N301SMCameron Ottis W · Comfort, TXFirst renewal noticeBuilt 1964 · S/N 534 N302AMHughes Jason · Visalia, CABuilt 1965 · S/N 618 N30EGPlane Fun Inc Tr Trustee · Snellville, GAS/N 345 N31617Valiair Limited Co Trustee · Casper, WYBuilt 1965 · S/N 515 N31SMWings Over Texas Aviation Inc · Killeen, TXBuilt 1965 · S/N 635 N3212FMcdonald Ronald W · Olive Branch, MSBuilt 1967 · S/N 670005 N3214FPicker Larry L · Stanfield, ORBuilt 1967 · S/N 670007 N3215FWinick Scott R · Jay, VTBuilt 1967 · S/N 670008 N3216FPerry Edward Glen Trustee · Ozark, ARBuilt 1967 · S/N 670009 N3219FTop Flight Detail LLC · Middlebury, INS/N 670012 N3224FShaffer Aviation LLC · Keystone Heights, FLBuilt 1967 · S/N 670017 N3230FRegistered aircraftBuilt 1967 · S/N 670023 N3232FSilver Wings LLC · Vero Beach, FLBuilt 1967 · S/N 670025 N3233FPlank Lester L · Montgomery, INBuilt 1967 · S/N 670026 N3234FLastochka LLC · Kalispell, MTBuilt 1967 · S/N 670027 N3235FRosario Michael J · Memphis, TNBuilt 1967 · S/N 670028 N3238FKercheval Todd R · Georgetown, TXS/N 670031 N3240FJ Smith LLC · Lewes, DEBuilt 1967 · S/N 670033 N3242FSbflyer LLC · Ooltewah, TNBuilt 1967 · S/N 670035 N3244FKempton Brian J · Huntsville, TXBuilt 1967 · S/N 670037 N3247FWilliams Matthew D · Xenia, OHS/N 670040 N3249FRoberto Jeffrey M · Piscataway, NJBuilt 1967 · S/N 670042 N3250FMantissa Corporation · Charlotte, NCBuilt 1967 · S/N 670043 N3251FRegistered aircraftBuilt 1967 · S/N 670044 N3252FBubes Michael D · Cocoa, FLBuilt 1967 · S/N 670045 N3255FThomas Clayton · Culleoka, TNBuilt 1967 · S/N 670048 N3257FBrandon M Ten Hoopen · Bay Shore, NYBuilt 1967 · S/N 670050 N3259FBrown Scott J · Liberty, SCS/N 670052 N3262FCm&K Enterprises Inc · Brandon, MSBuilt 1967 · S/N 670055 N3263FVelazquez Carlos A · Lexington Park, MDBuilt 1967 · S/N 670056 N3264FWhite Sawyer A · Longmont, COBuilt 1967 · S/N 670057 N3265FOsborne Allen Wright · Waxhaw, NCBuilt 1967 · S/N 670058 N3266FStolar Michael · Washington, VABuilt 1967 · S/N 670059 N333AGRegistered aircraftBuilt 1975 · S/N 21-1168 N333KRSimmons Anthony T · Easley, SCBuilt 1966 · S/N 1290 N3344SLewis James P Jr · Castle Rock, COBuilt 1965 · S/N 710 N3353XBain Jonathan · Newark, DEBuilt 1966 · S/N 1078 N3354XVirginia Aircraft Rentals LLC · Broadway, VABuilt 1966 · S/N 1079 N3364XDel Bene Dean A Trustee · Monee, ILBuilt 1966 · S/N 1085 N3368XI Have A Plane LLC · Lake Oswego, ORS/N 1087 N3369XCollins Jerod William · Conifer, COBuilt 1966 · S/N 1088 N3374XLee Rollin Kim · Panaca, NVS/N 1091 N3377XPenalo Garcia William J · Toa Baja, PRBuilt 1966 · S/N 1092

Back to Mooney M20E