Skip to content

Registered aircraft · 1,258

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

N2622WMohamed Eman Z · Lubbock, TXBuilt 1966 · S/N 3295 N2623WThornhill Jeff P · Goodyear, AZBuilt 1966 · S/N 3296 N2627WDiamond Engineering & Service Co · Granger, INBuilt 1966 · S/N 3297 N2631WPlanes & Parts Inc · Weston, FLBuilt 1966 · S/N 3299 N2632WKrapp Transfer · Jamestown, NDBuilt 1966 · S/N 3300 N2637WCox James L · Fort Worth, TXBuilt 1966 · S/N 3302 N2641WRampini Daniel G · Cleveland, OHBuilt 1966 · S/N 3303 N2651WStolworthy Spencer D · Maple Valley, WABuilt 1966 · S/N 3307 N2652WRegistered aircraftBuilt 1966 · S/N 3308 N2657WRegistered aircraftBuilt 1966 · S/N 3310 N2662WEaton Mark E · Houston, TXBuilt 1966 · S/N 3312 N2671WSchwister Daniel Edward · Woodinville, WABuilt 1966 · S/N 3315 N2672WGallatin Aviation Enthusiasts LLC · Fairbanks, AKBuilt 1966 · S/N 3316 N2677WSaunders Charles A · Scott Depot, WVBuilt 1966 · S/N 3318 N2681WAb Mooney LLC · Durham, NCBuilt 1966 · S/N 3319 N2696WButler Collin · Danvers, MABuilt 1966 · S/N 3325 N2702WMedic Choppers LLC · Springdale, ARS/N 3329 N2707WLund Tyler David · San Diego, CABuilt 1966 · S/N 3331 N2712WFadio David C · Elmira, NYBuilt 1966 · S/N 3333 N2713WDutro Tammy S · Dublin, OHBuilt 1966 · S/N 3334 N2723WSenneff James L · Clarence, NYBuilt 1966 · S/N 3337 N2724WHebert David D · Mcalester, OKBuilt 1966 · S/N 3338 N2728WNash Richard D · Edgewood, WABuilt 1966 · S/N 3339 N2730WKegg Larry R · Chesapeake, VABuilt 1966 · S/N 3429 N2733WMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3341 N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344 N2744VHerrenkohl Robert D · Bay Point, CAS/N 3346 N2748WZweifel Jonathan R · Chandler, AZBuilt 1966 · S/N 3347 N2753WGleaton Marcus H · Weatherford, TXBuilt 1966 · S/N 3349 N2759WBar F Aviation LLC · Scottsbluff, NES/N 3352 N2768WGlenn Larry W · Bunn, NCBuilt 1966 · S/N 3355 N2769WHarper Leonard D · Peyton, COBuilt 1966 · S/N 3356 N2783WCrain James D · Hood River, ORBuilt 1966 · S/N 3361 N2784WBoeckman Thomas J · Carroll, IABuilt 1966 · S/N 3362 N2793WSchneider Aerial Inc · Rugby, NDBuilt 1966 · S/N 3365 N2798WSb Enterprise LLC · Marshall, TXBuilt 1966 · S/N 3367 N2902LIvey Steven L · Graniteville, SCBuilt 1967 · S/N 670065 N2903LSchillinger Bradley Charles · Honeoye Falls, NYBuilt 1967 · S/N 670066 N2935LCrc Medical Staffing Inc · Mansfield, LAS/N 670069 N2936LWencko Paul Andrei · Saint Petersburg, FLBuilt 1967 · S/N 670070 N2938LAmend Keith R · Hagerman, IDBuilt 1967 · S/N 670072 N2939LDonahue Paul · West Palm Beach, FLS/N 670073 N2940LFlyingchamp LLC · Missoula, MTBuilt 1967 · S/N 670074 N2942LMurphy Paul James · Falls Church, VABuilt 1967 · S/N 670076 N2944LJohnson Tyler Jeffrey · Pensacola, FLBuilt 1967 · S/N 670078 N2945LDutko Adam Michael · Elyria, OHBuilt 1967 · S/N 670079 N2946LRegistration Pending · Denver, NCRegistration pending, pending cancellationBuilt 1967 · S/N 670080 N2947LPeoples John Robert Jr · Hixson, TNBuilt 1967 · S/N 670081 N2949LShaker M R · Green Bay, WIS/N 670083 N2956LZembower Christopher L · Cumberland, MDBuilt 1967 · S/N 670090

Back to Mooney M20C