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.

N2915LZorro Stephen · Rocklin, CABuilt 1967 · S/N 670309 N2916LPospisil Thomas · Rockwood, PABuilt 1967 · S/N 670310 N2917LDobbs J S · Medford, ORBuilt 1967 · S/N 670311 N2921LFellowship Of The Wing LLC · Riverton, UTBuilt 1967 · S/N 670315 N2923LHess Daniel G · Sonora, CABuilt 1967 · S/N 670317 N2926LJade Aviation LLC · Minot, NDS/N 670320 N2926MDramstad Harold · Helena, MTBuilt 1975 · S/N 22-1282 N2927LStahl John R · Union Dale, PABuilt 1967 · S/N 670321 N2928LForristel Andrew · Temecula, CABuilt 1967 · S/N 670322 N292LGSale Reported · Miller, SDSale reported, pending cancellationBuilt 1975 · S/N 22-1232 N2930LSantana Maria M · Pearland, TXS/N 670324 N2932LBcs Aviation LLC · Dothan, ALBuilt 1967 · S/N 670326 N2969LSeegers Matt J · Westlake Village, CABuilt 1967 · S/N 670328 N2972LMorris Russell K · Cameron Park, CABuilt 1967 · S/N 670331 N2977LMills Brian · Atascadero, CABuilt 1967 · S/N 670336 N2980LJentes Charles A · Smithville, OHFirst renewal noticeBuilt 1967 · S/N 670339 N2982LBurgdorf Brandon M · Evansville, INBuilt 1967 · S/N 670341 N2985LHeskett Sean D · Steamboat Springs, COBuilt 1967 · S/N 670344 N2991LRussell Daniel · Louisville, KYS/N 670350 N2993LGoutell Carl R · Marco Island, FLBuilt 1967 · S/N 670352 N2995LS&S Wings And Wheels LLC · Wilmington, DEBuilt 1967 · S/N 670354 N301LMN301lm LLC · Monee, ILS/N 670323 N311LBNewton Michael A · Cameron Park, CABuilt 1969 · S/N 700014 N315SBKusler Bradley D · Lincoln, NES/N 700005 N3205FHawkins William J II · Saint Petersburg, FLS/N 680002 N3207FGoodwin Winston L · Cypress, TXBuilt 1967 · S/N 670361 N3212CChambers Todd R · Brundidge, ALS/N 670513 N3272FCarroll Daniel T · Holbrook, AZBuilt 1967 · S/N 670365 N3273FRydeen Carl Edward · Little Falls, MNBuilt 1967 · S/N 670366 N3275FThree Chopt Flying Club · Charlottesville, VABuilt 1967 · S/N 670368 N3280FChristian Edward A · Evans, GABuilt 1967 · S/N 670373 N3281FCapps Daniel Boyce · Newcastle, OKS/N 670374 N3283FMorgan Lance A · Georgetown, TXBuilt 1967 · S/N 670485 N3284FHicks Raymond K · Villa Rica, GABuilt 1967 · S/N 670377 N3285FAir Mods And Repair Inc · Robbinsville, NJS/N 670378 N3287FSchaumberg John · Lebanon, INS/N 670380 N3288FFlightbyte LLC · Wilmington, DEBuilt 1967 · S/N 670381 N3289FRubiales Mauricio A Jr · San Diego, CABuilt 1967 · S/N 670382 N328CMSimunaci Jeffrey · Placitas, NMS/N 670100 N3291FEvans Derek M · Fresno, CABuilt 1967 · S/N 670384 N3292FGoodwin Darrell W · Richmond, TXBuilt 1967 · S/N 670385 N3294FWatkins Grant M · Durant, OKBuilt 1967 · S/N 670387 N3297FCadillac Aircraft Services Inc · Cadillac, MIBuilt 1967 · S/N 670390 N333AZCossalter Wade C · Esko, MNBuilt 1966 · S/N 670186 N333MTGesl Gregg R · New Braunfels, TXBuilt 1968 · S/N 680142 N3372XLeahy David J · Delaware, OHBuilt 1966 · S/N 670028 N3409NSchaffhauser Daniel · Garland, TXBuilt 1967 · S/N 680042 N3410NPedersen Bruce J · Sandpoint, IDS/N 680043 N3420NKurth Larry A · Williston, FLBuilt 1967 · S/N 680047 N3427NWackerle Timothy S · Marshall, MIS/N 680049

Back to Mooney M20F