Skip to content

Registered aircraft · 122

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 ('2071804')
  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 ('2071804')
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.

N7042XSale Reported · Larwill, INSale reportedS/N 15059142 N7043XMile High Flight Club Inc · Miami, FLBuilt 1961 · S/N 15059143 N7044XKlenoski Brian D · Fulton, MIBuilt 1961 · S/N 15059144 N7048XGartner Thomas M · Newton, KSBuilt 1961 · S/N 15059148 N7051XBobka Christian · Apple Valley, MNBuilt 1961 · S/N 15059151 N7067XAlpha Golf LLC · Glenpool, OKBuilt 1961 · S/N 15059167 N7084XPatry Aeronautical Institute · Kalispell, MTBuilt 1961 · S/N 15059184 N7085XGorman Michael G · Zephyr Cove, NVS/N 15059185 N7086XYocum Stuart · Kingman, AZBuilt 1961 · S/N 15059186 N7090XGoodrich Dianna L · Sebastopol, CABuilt 1961 · S/N 15059190 N7091XPonnequin Craig R · Marsing, IDBuilt 1961 · S/N 15059191 N7092XJackson Roy M II · San Angelo, TXBuilt 1961 · S/N 15059192 N7093XDreiling Timothy A · Lawrence, KSBuilt 1961 · S/N 15059193 N7096XMoran Margaret Smith · Como, MSBuilt 1961 · S/N 15059196 N7099XCornell Donald E · Turner, MTBuilt 1961 · S/N 15059199 N7100XSale Reported · Lincoln University, PASale reported, canceledBuilt 1961 · S/N 15059200 N7101XKountz Joseph P · Whitehall, MTBuilt 1961 · S/N 15059201 N7107XPowell L Alvin · Caldwell, IDBuilt 1961 · S/N 15059207 N7108XCortez Nelly · Ontario, CABuilt 1961 · S/N 15059208 N7111XGoodwin Joseph N · Grass Valley, CABuilt 1961 · S/N 15059211 N7112XKoplitz Wesley D · Oshkosh, WIBuilt 1961 · S/N 15059212 N7114XKnutson Wayne R · Tioga, NDBuilt 1961 · S/N 15059214 N7116XWeggel Roger · Fairbanks, AKBuilt 1961 · S/N 15059216 N7117XBoldog Sandor Alex · Andalusia, ALBuilt 1961 · S/N 15059217 N7118XRosier Wayne C · Lexington, NCBuilt 1961 · S/N 15059218 N7128XSchmitt Rudy · Brookshire, TXBuilt 1961 · S/N 15059228 N7131XEaa Charter 1093 · Midland, MIS/N 15059231 N7138XHalvorson Jerome B · Wyndmere, NDBuilt 1961 · S/N 15059238 N7141XWells Brent R · Atascadero, CABuilt 1961 · S/N 15059241 N7142XTownsend Charles D · Portage, MIBuilt 1961 · S/N 15059242 N7145XAthol Orange Aero Club Inc · Athol, MABuilt 1961 · S/N 15059245 N7147XBrooks Blaze W · Fairbanks, AKBuilt 1961 · S/N 15059247 N7148XLong Thomas S · Longview, TXBuilt 1961 · S/N 15059248 N7150XBrown Mitchell J · Herndon, PABuilt 1961 · S/N 15059250 N7151XWhite James D · Bozeman, MTS/N 15059251 N7152XGivens Eric J · Frankfort, OHBuilt 1961 · S/N 15059252 N7154XCapra James · Yakutat, AKBuilt 1961 · S/N 15059254 N7157XCorriveau Florian J · White Field, NHFirst renewal noticeBuilt 1961 · S/N 15059257 N7161XHendricks Nikole M · San Diego, CABuilt 1961 · S/N 15059261 N7162XJim L. Rentz · Bainbridge, GABuilt 1961 · S/N 15059262 N7167XMckissack Douglas R · Pooler, GABuilt 1961 · S/N 15059267 N7170XMccardle Guy D · Burnham, PABuilt 1961 · S/N 15059270 N7174XMcdaniel John P III · Marianna, FLS/N 15059274 N7179XMcmillan Sharon Mobley · Newnan, GABuilt 1961 · S/N 15059279 N7181XMozina Robert J · Mc Alpin, FLBuilt 1961 · S/N 15059281 N7186XSmith Calvin E · North Augusta, SCS/N 15059286 N7188XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1961 · S/N 15059288 N7189XZephyr Air Corp · Dellwood, MNBuilt 1961 · S/N 15059289 N7191XMiller William D · Blacksburg, VABuilt 1961 · S/N 15059291 N7193XRound Engine Aero · Nashville, MIS/N 15059293

Back to Cessna 150A