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.

N5839QSnodgrass Michelle B · Sierra Vista, AZBuilt 1965 · S/N 785 N5841QGuziec Philip R · Riverwoods, ILS/N 786 N5843QKeane Christopher · Salem, NHBuilt 1965 · S/N 787 N5859QHill Larry J · Idaho Falls, IDBuilt 1965 · S/N 795 N5867QO'Connor Stan R Jr · Knightdale, NCBuilt 1965 · S/N 798 N5871QNeosho Investments LLC · Neosho, MOBuilt 1965 · S/N 800 N5873QSternhagen Richard A · Friendship, WIBuilt 1965 · S/N 801 N5877QKenyon Alexandrea A · Costa Mesa, CABuilt 1965 · S/N 803 N5883QSnyder Stephen L · Lebanon, TNBuilt 1965 · S/N 806 N5897QBarsi Jeffrey D · Bonham, TXBuilt 1965 · S/N 813 N5900QGiannobile A Paul · Dover, OHFirst renewal noticeBuilt 1965 · S/N 816 N5902QYow Franklin S · Grand Blanc, MIBuilt 1965 · S/N 817 N5904QLorincz Dennis K · Wadsworth, OHBuilt 1965 · S/N 833 N5908QT&T Aviation LLC · Clarksville, TNBuilt 1965 · S/N 819 N5912QWilson Paul M · Bonifay, FLS/N 821 N5916QSeidel Daniel F · Los Altos Hills, CABuilt 1965 · S/N 823 N5918QNorheim Bjoern T · Phoenix, AZBuilt 1965 · S/N 824 N5920QKellogg Annabelle S · Cumming, GABuilt 1965 · S/N 825 N5924QWright Andrew · Sacramento, CABuilt 1965 · S/N 827 N5928QSchmidt Tyren A · Albertville, MNBuilt 1965 · S/N 829 N5938QNeely Eric R · Seagoville, TXBuilt 1965 · S/N 830 N5942QBravo J Bravo Aviation LLC · Louisville, KYBuilt 1965 · S/N 831 N5958QInnovative Orthopedics Inc · Arcadia, OKBuilt 1965 · S/N 840 N5962QNewell Robert T · Angel Fire, NMBuilt 1965 · S/N 842 N5966QFarwell Jason E · Lansing, KSBuilt 1965 · S/N 844 N5969QAbdelsalam Moustafa Gamal · Buena Park, CABuilt 1965 · S/N 845 N5973QFarias Gerardo M · Panama City Beach, FLS/N 847 N5976QEscobar Timothy · San Antonio, TXBuilt 1965 · S/N 848 N5979QBlount Aviation LLC · Metairie, LABuilt 1965 · S/N 849 N597NDNicholas James Esch · Cedar Rapids, IABuilt 1967 · S/N 670041 N5986QFord Christopher D · Brunswick, GAS/N 852 N5987QHardesty William A · San Diego, CABuilt 1965 · S/N 853 N5990QShowman Benjamin J · Danville, ALBuilt 1965 · S/N 854 N5993QDeley Mike · Menifee, CABuilt 1965 · S/N 855 N5GHDowin Robert R · Doylestown, PABuilt 1970 · S/N 700046 N5SMBearss Gordon M · Topeka, KSBuilt 1974 · S/N 21-0051 N6005QBittle Gary D · Bald Knob, ARBuilt 1965 · S/N 861 N6006QLevie Jeffrey T · Mount Holly, NCS/N 862 N6009QDelone Charles P · Sarasota, FLBuilt 1965 · S/N 863 N6012QClassic Aircraft LLC · West Point, NEBuilt 1965 · S/N 864 N6016QAbrahem Bishoy · Bakersfield, CABuilt 1965 · S/N 866 N6018QWilson Reed · Arlington, VABuilt 1965 · S/N 868 N6027QBergh Robert P · Hammett, IDS/N 874 N6028QSky Partners LLC · Sylacauga, ALBuilt 1965 · S/N 875 N6031QWhittier Frank · Las Vegas, NVBuilt 1965 · S/N 876 N6033QHerfield Colton · Lawton, OKBuilt 1965 · S/N 878 N6041QDonohue Mark A · Red Lodge, MTBuilt 1965 · S/N 882 N6042QMacfie Andrew · Richmond, CABuilt 1965 · S/N 883 N6046QRed Desert Aviation LLC · Hurricane, UTBuilt 1965 · S/N 885 N6051QWhite Jeffrey M · Carlsbad, CABuilt 1965 · S/N 888

Back to Mooney M20E