OpenAirDocs.org
AD 97-04-12

Registered aircraft · 6,745

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-04-12')
    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-04-12')
  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.

N1004FAeroag LLC · Portland, INBuilt 1988 · S/N 502-0025N1005MAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1302N1005VGb Spraying LLC · Bridgeport, NEBuilt 1988 · S/N 402-0694N1006YG B Aerial Applications Inc · Slaton, TXS/N 502-0031N10078Dallas Aero & Sales LLC · Poplar, MTBuilt 2013 · S/N 502B-2881N1007WAir Cover LLC · Frankford, MOBuilt 1988 · S/N 502-0032N1008FMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1988 · S/N 502-0033N1009FDavidson Richard E · Tchula, MSBuilt 2019 · S/N T34-484N1009LSouther Field Aviation Inc · Americus, GABuilt 1989 · S/N 502-0036N100AMBoundless Blue LLC · Scottsdale, AZBuilt 2018 · S/N 100-0259N100APTwin Otter Support Services LLC · Las Vegas, NVBuilt 1967 · S/N 22N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12N100BEBemis Manufacturing Co · Sheboygan Falls, WIBuilt 2004 · S/N FL-403N100BRIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N LA-116N100BZHartwell Holdings LLC · Dover, DEBuilt 1984 · S/N FA-32N100CCSeneca Tank · Des Moines, IABuilt 1982 · S/N 425-0170N100GP100gp LLC · Wilmington, DEBuilt 2011 · S/N LJ-2007N100JADolce Vita Assets LLC · Saint Petersburg, FLBuilt 2007 · S/N 865N100JFIsr Aviation LLC · Wilmington, DEBuilt 2005 · S/N 123N100KBExecutive Air Taxi Corp · Bismarck, NDBuilt 1979 · S/N LJ-820N100KLRobert Wiplinger N100kl LLC · South Saint Paul, MNBuilt 1955 · S/N 758 (1483)N100KNRak Kodiak LLC · Middletown, DEBuilt 2018 · S/N 100-0257N100UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-100N100VReserve Aviation LLC · Dallas, TXBuilt 1978 · S/N LJ-796N100YCFirst View Aviation LLC · Burlington, COBuilt 1999 · S/N 281N10114Hoppe Air LLC · Beaman, IAS/N 502-0043N10125North Delta Ag Aviation LLC · Sledge, MSBuilt 1989 · S/N 502-0047N10126Quiver River Flying LLC · Doddsville, MSBuilt 1989 · S/N 502-0050N10129Parrish Aerial Services LLC · Wilmington, DEBuilt 1989 · S/N 502-0051N1012BMidwest Aerial Applicators LLC · Whittington, ILBuilt 1989 · S/N 402-0712N1012ZBuffalo Aviation LLC · Monette, ARBuilt 1989 · S/N 502-0044N1013NVal Air 2 LLC · White River, SDS/N 401-0722N1014LSale Reported · Walnut, ILSale reported, pending cancellationBuilt 1989 · S/N 401A-0733N1017XAaa Aviation LLC · Donalsonville, GABuilt 1989 · S/N 402-0734N10185Oli Grow LLC · Baskin, LABuilt 1989 · S/N 502-0063N10189Whalen Mark P · Millington, MDBuilt 1989 · S/N 402A-0738N1019SBuffalo Ridge Airspray LLC · Milbank, SDS/N 502-0066N101AKPacific Diversified Investments Inc · Anchorage, AKBuilt 2025 · S/N 100-0356N101KQTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 100-0101N101PCSomers Charles · Hillsboro, ORBuilt 1978 · S/N 101N101PSJtech Solutions Inc · San Ramon, CABuilt 1982 · S/N 4250108N101SGSe Aviation LLC · Tupelo, MSBuilt 2001 · S/N BB-1785N101TAHatch Hyrum G · Gilbert, AZBuilt 1977 · S/N 421C0331N101UEAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC-101N101XWJoby Aero Inc · Santa Cruz, CABuilt 1993 · S/N 208B0382N1021BBeachy Flying Service LLC · Whittington, ILBuilt 1989 · S/N 502-0062N1022NBoyle Flying Service Inc · Boyle, MSS/N 502-0071N1024SAether Aircraft LLC · Roseville, MNBuilt 2011 · S/N 586N1025AAas LLC · Ovid, MIBuilt 1990 · S/N 502-0075N1026VPa1 208b-0319 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 208B0319
Back to AD 97-04-12