OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-01-R1')
  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.

N78WARtd Aviation LLC · Hillsborough, NJBuilt 1977 · S/N 28R-7837077N7900PGoco Wireless Inc · Goliad, TXBuilt 1962 · S/N 24-3130N7900YLone Star Aircraft Holding Group LLC · Plano, TXS/N 30-987N7901YHinshaw Eric C · Lake Wales, FLBuilt 1966 · S/N 30-988N7902YCohn David · Port Townsend, WABuilt 1966 · S/N 30-990N7903CHocking Valley Flying Club Inc · Hebron, OHBuilt 1975 · S/N 28R-7635121N7903PCaple Colby L · Windsor, COS/N 24-3133N7905PComanche250 LLC · Sequim, WAS/N 24-3136N7905YPatterson Thomas A · Minerva, OHBuilt 1966 · S/N 30-994N7907PSchwartz Tyson E · Midland, TXBuilt 1961 · S/N 24-3138N7910PStanford Richard E · Oklahoma City, OKBuilt 1962 · S/N 24-3141N7914PBethers James D · Montpelier, IDBuilt 1962 · S/N 24-3145N7915YTurbine Financial Group LLC · Ogden, UTBuilt 1966 · S/N 30-1005N7916YHurlston Glen David · Leesville, LABuilt 1966 · S/N 30-1006N7919PBailey Stephen J · Wichita Falls, TXS/N 24-3151N7919YKeller Paul W · Austin, TXBuilt 1966 · S/N 30-1009N7920PM & K Zeiler Aircraft LLC · Lawrence, KSBuilt 1962 · S/N 24-3152N7922PKeener & Assoc Inc · North Myrtle Beach, SCBuilt 1963 · S/N 24-3155N7922YSuhrie Mark A · Oneida, KYS/N 30-1012N7923PRichards Michael Dean · Burneyville, OKBuilt 1962 · S/N 24-3156N7924PWest Texas Weather Modification Association · San Angelo, TXBuilt 1962 · S/N 24-3157N7925PJapundza Bob · Kokomo, INBuilt 1962 · S/N 24-3159N7928PPeterson Jay O · Las Vegas, NVBuilt 1962 · S/N 24-3162N7928YW Carney LLC · Ocala, FLBuilt 1966 · S/N 30-1019N7929PSmh Aviation LLC · Johnstown, COBuilt 1962 · S/N 24-3163N7929YMasek Lawrence J · Cuyahoga Falls, OHBuilt 1966 · S/N 30-1020N7930PBotimer Douglas L · Fullerton, CABuilt 1962 · S/N 24-3164N7930YShort Final LLC · Mooresville, NCS/N 30-1021N7931YCannonball Trucking · Friendswood, TXBuilt 1966 · S/N 30-1022N79331Harbour Aviation LLC · Weatherford, TXBuilt 1973 · S/N 34-7350339N7933PFoss Rick · Lemmon, SDBuilt 1962 · S/N 24-3167N7935CRfc Inc · Hiawatha, IABuilt 1975 · S/N 28R-7635122N7937PMr Dent Inc · Manheim, PABuilt 1962 · S/N 24-3173N7938YEai Aircraft LLC · Fairbury, NEBuilt 1966 · S/N 30-1029N7940YN7940y LLC · Eagle Harbor, MIBuilt 1966 · S/N 30-1032N7941PMcnew Johnnie Daniel · Paris, KYBuilt 1962 · S/N 24-3177N7942CN4143w LLC · Los Gatos, CABuilt 1975 · S/N 32R-7680069N7942YAtlantic Aero Marine Inc · Seaford, DEBuilt 1966 · S/N 30-1035N7945PArey Paul R · Cambridge, MDBuilt 1962 · S/N 24-3181N7945YLevel Up Aviation LLC · Newton, ALBuilt 1966 · S/N 30-1039N7946PLarsen Jordan T · Draper, UTBuilt 1962 · S/N 24-3182N7947PThorpe Jack · Raleigh, NCBuilt 1962 · S/N 24-3183N7948PDeruelle David · Shingle Springs, CABuilt 1962 · S/N 24-3184N7949PWalters Donald J · Mohave Valley, AZBuilt 1962 · S/N 24-3186N7949YReeve Howard E · Minot, NDBuilt 1966 · S/N 30-1045N7950PAnahuac Utilities LLC · Wrightsboro, TXBuilt 1962 · S/N 24-3187N7950YKool Wings Leasing LLC · Indianapolis, INBuilt 1966 · S/N 30-1046N7951CJaybec Corp · Pinecrest, FLBuilt 1975 · S/N 32R-7680070N7952CKramer Kartie K · Mckinney, TXBuilt 1975 · S/N 32R-7680071N7952YHufnagel Christopher R Trustee · Santa Fe, NMBuilt 1966 · S/N 30-1048
Back to AD 97-01-01 R1