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.

N7840VShedd John G · Hopewell, NJBuilt 1965 · S/N 462 N7841VKohler Donald L W · Hernando, FLS/N 463 N7844VBanterra Bank · Marion, ILBuilt 1964 · S/N 465 N7845VRivera Jaime · San Antonio, TXS/N 466 N7879VRowan James T Jr · Silver City, NMBuilt 1964 · S/N 471 N79326Campbell Scott W · Del Mar, CABuilt 1964 · S/N 536 N79327Hobby Randy K · Santa Claus, INBuilt 1964 · S/N 537 N79329Resource Capital Inc · Henderson, NVS/N 539 N79330Prater Kerrie J · Maurice, LABuilt 1964 · S/N 540 N79335Summer G Livin LLC · Cedar Rapids, IABuilt 1965 · S/N 545 N79337Thoreson Alvin J · Granada, MNS/N 547 N79338Baber Fredrick Marshall · Punta Gorda, FLBuilt 1964 · S/N 548 N79340Windsperger Kevin L · Kirksville, MOBuilt 1965 · S/N 550 N79341Sigmon Thomas W · Surprise, AZBuilt 1965 · S/N 551 N79346Chandler John · San Gabriel, CABuilt 1964 · S/N 556 N79347Aguilar William A · Puyallup, WABuilt 1965 · S/N 557 N79350Ocala Aviation Services Inc · Ocala, FLBuilt 1965 · S/N 560 N79351Dust Devils Aviation LLC · Richland, WABuilt 1965 · S/N 561 N79358Henderson Steven R · Madison, WIBuilt 1965 · S/N 568 N79359Schultz Steven R · Tea, SDBuilt 1965 · S/N 569 N79360Lewis Robert T · Avondale, AZBuilt 1965 · S/N 570 N79361Narayan Systems LLC · Dayton, OHBuilt 1965 · S/N 571 N79362Esfandiari Ozra · Las Vegas, NVS/N 572 N79363Holmes Shaun B · Georgetown, TXBuilt 1965 · S/N 651 N79365Durden Bobby D Jr · Statesboro, GABuilt 1965 · S/N 575 N79368Jmr Investments LLC · San Antonio, TXS/N 578 N79374Johnson Stephen C · Columbus, OHBuilt 1965 · S/N 584 N79383De Michele Fabio Jose Delgado · Pembroke Pines, FLBuilt 1965 · S/N 590 N79387Luckenbach Adam W · Friendswood, TXBuilt 1965 · S/N 592 N79391Scott William H · Mount Pleasant, SCS/N 594 N79393Frandsen Travis · Rexburg, IDS/N 595 N79397Scholl Aaron K · Abbeville, ALBuilt 1965 · S/N 597 N79399Schneider Uwe · Port Orange, FLBuilt 1965 · S/N 598 N79808Registration Pending · Rocky Hill, CTRegistration pendingBuilt 1964 · S/N 472 N79810Boltinghouse James K · Sunrise Beach, MOBuilt 1964 · S/N 474 N79811Registration Pending · Summerville, SCRegistration pendingBuilt 1964 · S/N 475 N79812Ridgerock Aero LLC · Tuba City, AZBuilt 1964 · S/N 476 N79818Estabrook Mark A · Acton, MABuilt 1964 · S/N 482 N79819Garcia Kimberly Jazmin · Lancaster, CAS/N 483 N79821Wargo John · Crestview, FLS/N 485 N79823Burns Robert A · Leavenworth, KSBuilt 1964 · S/N 487 N79824Stoner Chase G · Havre, MTBuilt 1964 · S/N 488 N79825Ramin Reuben F · Tomball, TXBuilt 1964 · S/N 489 N79826Martin Kevin J · Blairstown, NJBuilt 1964 · S/N 490 N79827Lengel Alex M · Burlington, COBuilt 1964 · S/N 491 N79829Scott Nicholas · Lufkin, TXBuilt 1964 · S/N 493 N79832Leonard Anesthesia Services Inc · Carlsbad, CABuilt 1965 · S/N 496 N79833Mclenaghan Alvin N · Phoenix, AZBuilt 1964 · S/N 497 N79835Campoamor Sanchez Fernando · Washington, DCBuilt 1964 · S/N 499 N79836Scheel Aviation LLC · Camas, WABuilt 1964 · S/N 500

Back to Mooney M20E