OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,915

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.

N43994Harrison Shawn · Salisbury, MDBuilt 1977 · S/N 28R-7703327N439PTKnot Mach LLC · Mchenry, ILBuilt 1974 · S/N 34-7450179N43BLockard Seth J · Lebanon, TNBuilt 1963 · S/N 30-226N43TLT M L Aircraft Inc · Narrowsburg, NYBuilt 1971 · S/N 24-5001N43WGMaxfield Kenneth B Trustee · Murray, UTBuilt 1977 · S/N 28R-7703280N4401TMcelroy Shawn · East Falmouth, MABuilt 1972 · S/N 28R-7235026N4406TPollard John R · Melbourne, FLBuilt 1972 · S/N 28R-7235034N440DMBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 34-7670040N44104Reed Matthew · Lander, WYS/N 28R-7435295N44140Helmandollar Steven W · Elkhorn, NEBuilt 1974 · S/N 28R-7435298N4414TRegistration Pending · Rockford, MIRegistration pendingBuilt 1972 · S/N 28R-7235041N44157Gregoire Alexandra Jennifer · Orlando, FLBuilt 1974 · S/N 28R-7435299N441CKWinters John H · Birch Run, MIBuilt 1975 · S/N 28R-7535314N44229Cabelka Jerry L · Glendale, AZBuilt 1974 · S/N 28R-7435301N4422XKeys Andrew S · Harvest, ALBuilt 1975 · S/N 28R-7635038N4424TKoplin Adam · Big Stone City, SDBuilt 1972 · S/N 28R-7235046N44254Bridges D Scott · Paducah, KYBuilt 1974 · S/N 28R-7435304N4428TGauvin Daniel G · Newport, VTBuilt 1972 · S/N 28R-7235047N4428XLeopold Nathan · Fond Du Lac, WIBuilt 1975 · S/N 28R-7635040N442GBas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28R-7703208N4430XIsland Piper LLC · Portland, ORBuilt 1975 · S/N 34-7670041N44327Big Duke Aviation LLC · Oshkosh, WIBuilt 1974 · S/N 28R-7435306N44332International Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 34-7450068N4434XLusher Frank W II · Prichard, WVBuilt 1975 · S/N 28R-7635041N4437SVenture West LLC · Mesa, AZBuilt 2015 · S/N 2844156N4437WVenture West LLC · Mesa, AZBuilt 2015 · S/N 2844157N44388Zavoda Scott E · Strongsville, OHBuilt 1974 · S/N 28R-7435307N4438DMa Aviation LLC · Danville, ILBuilt 2015 · S/N 2844158N4439XMccormick Robert E · Yakima, WABuilt 1975 · S/N 28R-7635043N44416Registration Pending · Punta Gorda, FLRegistration pendingBuilt 1974 · S/N 34-7450209N4441XKaschak Tom · Stateline, NVBuilt 1975 · S/N 34-7670043N4443XFox Two LLC · Camino, CABuilt 1975 · S/N 28R-7635044N44443Jax Navy Flying Club · Jacksonville, FLBuilt 1974 · S/N 28R-7535001N44458Forsman Airways LLC · Glenwood, MNBuilt 1974 · S/N 28R-7435309N4445XRegistration Pending · Midlothian, TXRegistration pendingBuilt 1975 · S/N 32R-7680017N4446XRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1975 · S/N 34-7670044N444CPMercure Ryan K · Eads, TNBuilt 1963 · S/N 30-230N444DPStratospheric Ventures LLC · Saint Petersburg, FLBuilt 1974 · S/N 28R-7435167N444DRWheels Up LLC · Midway, KYS/N 32R-7780328N444FWKuntz Clark · Tallahassee, FLBuilt 1977 · S/N 32R-7780425N444JSIndigo Of South Fl Inc · Sunrise, FLS/N 28R-7703287N444MJMcfarlin Lucinda · Nacogdoches, TXS/N 32R-7780083N444PAExecutive Aviation LLC · Peoria, AZBuilt 1979 · S/N 34-7970324N444SAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250183N444SLD And E Consulting LLC · Taylor, ARBuilt 1973 · S/N 28R-7335111N44521Silker Services LLC · Schaumburg, ILBuilt 1974 · S/N 28R-7435311N4452TUtehin Nick A · San Mateo, CABuilt 1972 · S/N 28R-7235053N4452XAlpha Dairy Chi LLC · Locust Grove, OKBuilt 1975 · S/N 28R-7635048N44552Hemdmm Corp · Wilmington, DEBuilt 1974 · S/N 34-7570003N4455FCharlie Foxtrot LLC · Palm Beach Gardens, FLBuilt 1976 · S/N 32R-7680448
Back to AD 97-01-01 R1