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.

N3430NKellner Darlene D · Lancaster, PABuilt 1967 · S/N 680050 N3435NBailey Robert B · Damascus, ORBuilt 1967 · S/N 680052 N3435XYeaw Norman E · Hazel Green, ALBuilt 1966 · S/N 670032 N3438NDurst Luke · Panhandle, TXBuilt 1967 · S/N 680053 N343EDKobe Thomas J Jr · Lake Placid, FLBuilt 1967 · S/N 680006 N3440NAshpaugh James A · Bryan, TXBuilt 1967 · S/N 680054 N3444NPeck Justin · Forest City, PABuilt 1967 · S/N 680055 N3455NRegistered aircraftBuilt 1967 · S/N 680057 N3459NHageman Robert · Austin, TXBuilt 1967 · S/N 680058 N345TMScott Daily Inc · Ash Flat, ARBuilt 1975 · S/N 22-1217 N3461NBrown Hugh · Lubbock, TXBuilt 1967 · S/N 680060 N3463NN83993 LLC · Cherry Hill, NJFirst renewal noticeBuilt 1967 · S/N 680061 N3468NState 48 Aviation LLC · Scottsdale, AZBuilt 1967 · S/N 680064 N3470NDavis Brandon K · Kansas City, MOBuilt 1967 · S/N 680065 N3475XSilva Phillip S · Henderson, NVBuilt 1967 · S/N 670249 N3484NPietsch Warren A · Minot, NDBuilt 1967 · S/N 680067 N3486NRose Thomas Z · Santa Ana, CABuilt 1967 · S/N 680068 N3488NValley Aviation LLC · Fargo, NDBuilt 1967 · S/N 680070 N3490NRegistration Pending · Prescott, AZRegistration pendingBuilt 1967 · S/N 680071 N3491NArmstrong William · Scotts Valley, CABuilt 1967 · S/N 680072 N3494NCox Eric L · Sheridan, WYBuilt 1967 · S/N 680074 N3498NBedard Timothy S · Pittsburgh, PABuilt 1967 · S/N 680075 N3501XRoark Ken W · Cisco, TXBuilt 1966 · S/N 670039 N3505HSingleton Todd D · Lexington, TNBuilt 1976 · S/N 22-1425 N3505XSiegel Craig A · Tucson, AZBuilt 1966 · S/N 670043 N3506XBevers David A · Colfax, CABuilt 1966 · S/N 670044 N3507HCreel Adam · Hoover, ALBuilt 1976 · S/N 22-1426 N3508XPietrs Robert A · Madison, ALS/N 670046 N3509HPer Ardua Ad Astra Inc · San Luis Obispo, CABuilt 1976 · S/N 22-1427 N3510NVenture Eleven Aero LLC · Huntsville, ALBuilt 1967 · S/N 680077 N3510XCuccia Joseph A · Hazen, NDBuilt 1967 · S/N 670048 N3511HAvmd LLC · Houston, TXBuilt 1976 · S/N 22-1429 N3512XTaylor Logan · Live Oak, CABuilt 1966 · S/N 670050 N3515NClauson Jesse W · Agawam, MABuilt 1967 · S/N 680079 N3515XSayre Mikko · Madison, WIBuilt 1966 · S/N 670053 N3516XThompson Richard F · Boone, NCBuilt 1966 · S/N 670054 N3517NTronaas Chris E · Hamilton, MTBuilt 1967 · S/N 680080 N3521HCochran William T · Clermont, FLBuilt 1976 · S/N 22-1433 N3522NRegistration Pending · Mandeville, LARegistration pendingBuilt 1967 · S/N 680082 N3523HGrossman Rebecca L G · Slate Hill, NYBuilt 1976 · S/N 22-1434 N3524NRickard Donald S · Florence, ALBuilt 1967 · S/N 680083 N3524XKendrick Brian S · Kerrville, TXBuilt 1966 · S/N 670061 N3525HDavis Rodney M · Savannah, GABuilt 1976 · S/N 22-1435 N3526NDace Joshua R · Rochester Hills, MIBuilt 1967 · S/N 680084 N3526XSchiebel Philip A · Walla Walla, WAS/N 670063 N3527NMooney 3527 LLC · North Las Vegas, NVS/N 680085 N3529XPurpose Flight Inc · Wilmington, DES/N 670066 N3530XLorenz George W · Downers Grove, ILBuilt 1966 · S/N 670067 N3532XShipley James P · Los Alamos, NMBuilt 1966 · S/N 670069 N3534HBeatty Don K · Mount Ulla, NCBuilt 1977 · S/N 22-1437

Back to Mooney M20F