OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,367

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:90-04-06-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:90-04-06-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.

N12261Davis Danny R · S Coffeyville, OKBuilt 1973 · S/N 17261909N1226AWalsh Brendan · Seattle, WAS/N 18-841N1226CFortine Joseph A · Adin, CABuilt 1953 · S/N 22-1031N1226FSnoopys Group Inc · Westerly, RIBuilt 1979 · S/N 17272978N1226JMores Glenn S · Boxford, MABuilt 1974 · S/N 226N1226TLinde Glenn F Jr · Juneau, WIBuilt 1972 · S/N 28-7205269N1226UAirborne LLC · Wilmington, DEBuilt 1976 · S/N 17266922N1227CMccall John L · Arlington, TXS/N 22-1034N1227TStieper David Paul · Forest Lake, MNBuilt 1972 · S/N 28R-7235241N1227UKelly William W · Springfield, ORBuilt 1976 · S/N 17266923N1227XVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N 198N1228REcko Air LLC · Springfield, MOBuilt 1989 · S/N 2841266N1228UBig Sky Aviation LLC · Glenmora, LABuilt 1976 · S/N 17266924N1229Fritzinger Thomas A · Maidens, VAS/N 1112N12290Read Andrea · Austin, TXFirst renewal noticeBuilt 1973 · S/N 17261912N12291Cisek Jason M · Westfield, MABuilt 1973 · S/N 17261913N1229TPiper Electric Inc · Deer Park, NYBuilt 1972 · S/N 34-7250267N1229UMcdonald Air Services LLC · Saint Johns, MIBuilt 1976 · S/N 17266925N1229WScott George H · Springdale, ARBuilt 2000 · S/N 5258N122ADRegistered aircraftBuilt 2005 · S/N 81308N122AKBarker Paul II · Rainbow City, ALBuilt 1991 · S/N 2028N122BPDiggins Charles J · Middleboro, MABuilt 1997 · S/N 22912N122BRHollon Blake D · Douglas, WYBuilt 1958 · S/N TD-65N122CFSouthwest Aviation Specialties LLC · Tulsa, OKS/N 15282778N122CWWentz Mark T · Milpitas, CAS/N 058N122EAHumpal Nathan A · San Antonio, TXBuilt 2003 · S/N 60553N122EZLawley Frederick Ellsworth III · Castro Valley, CAS/N 1297N122HSafeline Aviation LLC · Apache Junction, AZBuilt 1999 · S/N 1274-99N122HSMarbury Sherri E · Jackson, TNBuilt 1965 · S/N 28-2377N122JDGrasshopper Aviation LLC · Hockley, TXBuilt 2000 · S/N 1301-2000N122KCRomero Garcia Moises · Park City, UTBuilt 2003 · S/N 2105-LN122KRRutkowski Kurt A · Cresson, TXBuilt 1999 · S/N 2360N122MCShouk Aviation LLC · Waverly, OHBuilt 2007 · S/N 2844133N122MJHyper Flight Inc · Seattle, WABuilt 1977 · S/N 17270043N122MLLutz Michael A · Findlay, OHBuilt 2000 · S/N 645N122NAGilded Gull Aviation LLC · Middletown, RIBuilt 1981 · S/N 28-8216068N122PLSlip Stream Aviation Inc · Fort Mill, SCBuilt 2001 · S/N 3265N122PMFrench Benjamen M · Dillon, MTBuilt 2025 · S/N 001N122PPStout Andy · Livingston, TXBuilt 1990 · S/N 526N122RFDaniels Ronald C · Poughkeepsie, NYS/N 3397N122SGTanz LLC · Helena, MTBuilt 2004 · S/N 80094N122SSGrain Belt Aviation LLC · Malcolm, NEBuilt 1975 · S/N 17264842N122TCarraher Timothy J · Spalding, NEBuilt 1952 · S/N 18-2236N122TVButler Aaron · Rupert, IDBuilt 1976 · S/N 1049N122VTGordon William T · Evergreen, COBuilt 1976 · S/N 1046N122VUWeishaar Richard N III · Roselle, ILBuilt 1991 · S/N 10058N122WRRangers Flying Club Inc · Eden Prairie, MNBuilt 1975 · S/N 177RG0744N122XXGloss Mountain Aviation Foundation · Meno, OKBuilt 1990 · S/N 9001N1230Olson Raymond A · Somers, MTBuilt 1994 · S/N 073099N1230AHlavnicka Ruth M · Big Sandy, MTBuilt 2006 · S/N S1-06
Back to AD 90-04-06 R1