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.

N3378XBurdis W J · Beaver Falls, PABuilt 1966 · S/N 1093 N3383XHiger Matthew Ward · Las Vegas, NVBuilt 1966 · S/N 1096 N3384XWendt Wesley A · Leavenworth, KSBuilt 1966 · S/N 1097 N3388XRoth Joe D · Livingston, TXBuilt 1966 · S/N 1099 N338EEHansen Carl A · Bowie, MDBuilt 1965 · S/N 588 N3393XJohnson Terence A · Caldwell, IDBuilt 1966 · S/N 1102 N3398XWinkers John W Jr · Woodstown, NJBuilt 1966 · S/N 1105 N3403XWenkman Michael J · Madison, WIBuilt 1966 · S/N 1108 N3404XAero Nautical Electronics Inc · Starke, FLBuilt 1966 · S/N 1109 N3407XAerodrome Aviation LLC · Brighton, COBuilt 1966 · S/N 1110 N3408XHeid Jason A · Crystal, MNBuilt 1966 · S/N 1111 N3414XMoore Jason E E · Tomball, TXBuilt 1966 · S/N 1115 N3417XRobbins Brian C · Meridian, IDBuilt 1966 · S/N 1116 N3419XBrown Jarrod · Beaumont, TXBuilt 1966 · S/N 1118 N3424XCarroll Ronald M · Locust Grove, GABuilt 1966 · S/N 1120 N3425XY E Services Inc · Bradenton, FLBuilt 1966 · S/N 1121 N3433XRundus Timothy A · Chandler, AZBuilt 1966 · S/N 1125 N3434XAronhalt Daniel E · Columbus, INBuilt 1966 · S/N 1126 N3439XUpdraft Aviation LLC · Cedar City, UTS/N 1129 N3440XChurches Tyler A · Gypsum, COBuilt 1966 · S/N 1130 N3443XSaporito Timothy J · Warren, PABuilt 1966 · S/N 1131 N3444XBrey Ronald P · Van, TXS/N 1132 N3450XCarey Patrick M · Citrus Heights, CABuilt 1966 · S/N 1136 N3454XGarcia Eduardo G · Houston, TXBuilt 1966 · S/N 1138 N3458XDalton Robert E · San Martin, CABuilt 1966 · S/N 1140 N345WGMajors William B · Glen Carbon, ILBuilt 1967 · S/N 670038 N3460XKallner Carl Magnus · Jackson, NJBuilt 1966 · S/N 1142 N3464XMonroy Jonathon M · Olathe, KSBuilt 1966 · S/N 1144 N3465XKmlb Aviation LLC · Melbourne, FLBuilt 1966 · S/N 1145 N3469XMiller Brian · Nampa, IDBuilt 1966 · S/N 1147 N3473XStoner Jon L · Pocatello, IDBuilt 1966 · S/N 1149 N3478XCleveland Andrew D · Vancouver, WABuilt 1966 · S/N 1152 N3479XFrontier Land & Cattle LLC · Ozark, MOBuilt 1966 · S/N 1153 N3480XLorenzi Mark E · Lancaster, OHBuilt 1966 · S/N 1154 N3483XDoddy Del · Cincinnati, OHS/N 1155 N3485XCdm Flight Club Inc · La Jolla, CABuilt 1966 · S/N 1157 N3489XHanson Jonathan · Palmer, AKS/N 1159 N3493XKnepper Gary E · Canby, ORBuilt 1966 · S/N 1161 N3494XQuantum Returns Club LLC · Southampton, NYBuilt 1966 · S/N 1162 N3498XBackes Celso Jr · Pike Road, ALBuilt 1966 · S/N 1164 N36HNBush Thomas D Jr · Cypress, TXBuilt 1965 · S/N 754 N3755Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1964 · S/N 276 N3AMBeavers William W · Bear Creek, NCFirst renewal noticeBuilt 1966 · S/N 1013 N3QTNew World Enterprises Inc · Aiken, SCBuilt 1965 · S/N 903 N3SYHigh Planes Aero Club Inc · Longmont, COBuilt 1967 · S/N 670016 N400YSInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 693 N40TMN40tm LLC · Wilmington, DEBuilt 1966 · S/N 1063 N413HMDouble A Aviators LLC · Taylors, SCBuilt 1975 · S/N 21-1179 N413YKGoodner Terry Jack · Port Saint Lucie, FLS/N 818 N421ACCroft Dennis W · Spencerville, OHBuilt 1966 · S/N 1066

Back to Mooney M20E