Skip to content

Registered aircraft · 268

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

N33082Lewis Milton K · Cortez, COBuilt 1940 · S/N 5-431 N33087Swanson Timothy James · Bannister, MIS/N 5-437 N33180Van Wagner Aerial Media LLC · Hollywood, FLS/N 5-456 N33187Haggerty John J Jr · Skaneateles, NYBuilt 1940 · S/N 5-462 N33265Sigler Daniel E · Canby, ORBuilt 1940 · S/N 5466 N33269Bender Evan D H · Linville, VABuilt 1940 · S/N 5-470 N33271Brock Timothy S · Cullman, ALBuilt 1940 · S/N 5-472 N33279Daniel Kass · Simi Valley, CABuilt 1940 · S/N 5-480 N33295Aspinwall David · Soquel, CABuilt 1940 · S/N 5485 N33403Drag Your Tail LLC · Lewes, DEBuilt 1940 · S/N 5-492 N33410Newberry Brandon G · Kevil, KYBuilt 1940 · S/N 5-500 N33415Million John B · Westminster, MDS/N 5-505 N33421Koemer Aviation Inc · Kankakee, ILBuilt 1940 · S/N 5-510 N334SSchneider Michael H · Inola, OKBuilt 1938 · S/N 5-218 N35020Spears Dennis R Jr · Modesto, CABuilt 1941 · S/N 5-528 N35025Bennett Jacob W · Carrollton, MSBuilt 1941 · S/N 5535 N35029Wallis Bruce W · Kingwood, TXBuilt 1941 · S/N 5539 N35035Registration Pending · Oak Grove, MNRegistration pendingBuilt 1941 · S/N 5-545 N35037Toman Michael · Painesville, OHBuilt 1941 · S/N 5-547 N35042Cayce Dick L Jr · Longview, TXS/N 5-554 N35175Evans D F · Perry, GAS/N 5-562 N35180Schildberg Matthew J · Greenfield, IABuilt 1941 · S/N 5-567 N35189Green William D · Fairbanks, AKBuilt 1941 · S/N 5-576 N35197Jackson Robbin S · Grafton, OHS/N 5-585 N35275Harvey Daniel P · Port Leyden, NYBuilt 1941 · S/N 5-593 N35277Uber James E · Sanborn, NYBuilt 1941 · S/N 5-594 N35279Registration Pending · North Hampton, NHRegistration pendingBuilt 1941 · S/N 5-597 N35280Hoffman Steven L Trustee · Nokomis, ILBuilt 1941 · S/N 5-598 N35283Maynard Marc L · Dartmouth, MAS/N 5-601 N35288Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1941 · S/N 5-605 N35290Dougherty Robert E · Mosheim, TNBuilt 1941 · S/N 5-608 N35297International Air Services Inc Trustee · Carson City, NVFirst renewal noticeS/N 5-616 N35298Lawson Larry · Morgantown, WVBuilt 1941 · S/N 5-618 N35374Phelan Ricky R · Jefferson, ORBuilt 1941 · S/N 5-625 N35380Saxton William S · Yarmouth Port, MABuilt 1941 · S/N 5629 N35381Pss Air Inc · Middlesboro, KYS/N 5-630 N35393Maga Montana LLC · Kalispell, MTS/N 5-644 N35394Acs Aviation LLC · Burlington, VTBuilt 1941 · S/N 5-643 N35400Aero Maintenance Inc · Vancouver, WAS/N 5-650 N35409Sandvik Randall L · Palmer, AKBuilt 1941 · S/N 5-660 N35412Whitley Brett A · Montgomery, TXBuilt 1941 · S/N 5-663 N35413Piper Cub J5a LLC · Westford, MABuilt 1941 · S/N 5664 N35417Classic Aircraft Restoration LLC · Gladstone, MIBuilt 1941 · S/N 5-668 N35424Terkeurst William J IV · Gurley, ALBuilt 1941 · S/N 5-675 N354GFN354gf LLC · Daytona Beach, FLS/N 5-654 N35589Bracale Glenn S · Anchorage, AKFirst renewal noticeS/N 5-693 N35595Airspace Aerial Media LLC · Saint Louis, MOBuilt 1941 · S/N 5-691 N35601Stinnett Spencer P · Athens, ALS/N 5-694 N35604Welch Troy O · Graford, TXS/N 5697 N35607Woodham Jesse C III · Thomasville, GAS/N 5-700

Back to Piper J5A