OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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.

N3113KHopf Jeffrey B · Llano, TXBuilt 2007 · S/N 47012TN3113PCampbell Gregory · Davis, ILS/N 23-1035N3114CWilkerson Bradley W · Caldwell, IDS/N 20030CN3114MFarber Adam J · Odessa, TXS/N 12-1807N3114TClark Thomas J · Saint George, UTBuilt 1967 · S/N 17700414N3115Bravo Charlie LLC · Johnston, IABuilt 1968 · S/N 1967N31159Eckel Kenneth P Jr · Santa Fe, TXBuilt 1940 · S/N 5375N3116Dart Gregory G · Mayville, NYBuilt 1970 · S/N RP1-SN31161Zerbe Monte K · Dayt Bch Sh, FLBuilt 1992 · S/N 585-320-332FBN3116QHenderson State University · Arkadelphia, ARS/N 17002CN3117Daacke Edwards J · Glen Rock, PAS/N JJD-1N3117AAtp Aircraft 8 LLC · Wilmington, DEBuilt 2008 · S/N 4496259N3117LAtp Aircraft 2 LLC · Wilmington, DEBuilt 2005 · S/N 4496202N3117ZYoung Donald L · Anniston, ALS/N 22-7062N31183Ial Corp · Lewes, DEBuilt 2007 · S/N AC-01N3118CChristensen Effie S · Wasilla, AKS/N 20034CN3118KNorth Carolina Wildlife Resources Commission · Raleigh, NCS/N 14060CN3118TButts Thomas E · Alma, GABuilt 1967 · S/N 17700418N3118ZTridogs LLC · Cleveland, GABuilt 1959 · S/N 22-7063N3119PKovacs Thomas A · Nashua, NHBuilt 1957 · S/N 23-1041N3119ZStoner Paul V · Austin, TXBuilt 1959 · S/N 22-7064N311AWWidener Adam S · Sharpsburg, GABuilt 1974 · S/N 28-7525015N311CBCampbell James S · Eloy, AZBuilt 1999 · S/N 3919N311CKLima Tango Aviation LLC · Mount Dora, FLBuilt 1977 · S/N AA5B0591N311DDSierra Aeronautics LLC · Gambier, OHBuilt 1960 · S/N DH-311N311ELashuay Donald I · Midland, MIBuilt 1946 · S/N 12-411N311EFLibra Air Inc · Las Vegas, NVBuilt 1979 · S/N 44-7995226N311EHFive Six Zero One LLC · Orange, CABuilt 1977 · S/N 17269158N311FHJamieson Robert F · Friday Harbor, WAFirst renewal noticeBuilt 2010 · S/N 242N311GBWhirlygig Enterprises LLC · Dover, DEBuilt 1988 · S/N S1350N311HBChristiansen Aviation LLC · Wilmington, DEBuilt 1979 · S/N 17272347N311JKHumphries John A · Elgin, SCBuilt 1996 · S/N 311N311KKeeler Allan A · Woodbury, CTBuilt 1954 · S/N 18-3597N311KGGrasse Alvin K · Longview, TXBuilt 2020 · S/N 74457N311KTBeers Kenneth W · Shirleysburg, PAS/N BD-016N311LBNewton Michael A · Cameron Park, CABuilt 1969 · S/N 700014N311LLSimpson Anthony · Bozeman, MTBuilt 2006 · S/N 82470N311LTSampson Terry W · Kimberly, ALBuilt 1975 · S/N AA5A-0035N311NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881904N311QGrant Roderick M · Dillingham, AKBuilt 1957 · S/N 18-5697N311RAFlight Tech Inc · Arlington, WAS/N 2995N311RGGriffith Thomas Alexander · Wellington, FLBuilt 2003 · S/N 80998N311SRed Rock Construction Inc · Hydro, OKBuilt 1964 · S/N 30-328N311SLSchmetter Kenneth E · Needville, TXBuilt 2013 · S/N AL-1175N311SSSeabolt Pilots LLC · Cave City, ARBuilt 1960 · S/N 24-1959N311TLark Aircraft Leasing · Port Townsend, WABuilt 1953 · S/N 18-2425N311XStevens Adam · Dacono, COBuilt 1963 · S/N 2592N311XMJordaan Neil S · Prescott, AZBuilt 2014 · S/N 82311N31200N7775mw LLC · Sand Lake, MIBuilt 1995 · S/N 20036CN3120ZGifford Thomas Lloyd · Canadian, TXS/N 22-7065
Back to AD 90-04-06 R1