OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N1678HBrown Gregory B · New London, CTBuilt 1977 · S/N 28-7790330N1678JCloudhoppers Inc · Effingham, ILBuilt 1967 · S/N 28-24079N1679ARostron Christopher M · Kokomo, INS/N 22-441N1679PClearwater Potlatch Timber Pa · Orofino, IDBuilt 1954 · S/N 18-4068N167AMVandeventer Larry D · Charlotte, NCBuilt 1999 · S/N 23163N167BHHolliday Robert R · Andover, KSBuilt 1966 · S/N 17255345N167BWMartin Jennifer · Palm Desert, CABuilt 1974 · S/N 12475N167CJMunn Oliver L · Ocala, FLBuilt 2010 · S/N 25879N167CSBalister Adrian G · Colorado Springs, COS/N 23197N167CWNorinsky David · Petaluma, CABuilt 2002 · S/N 1001N167GTPreferred Procurement LLC · Sheridan, WYBuilt 2001 · S/N 2007N167JMMiller James D · Wilmington, NCBuilt 2017 · S/N 071N167LDRegistered aircraftS/N 670105N167MSMullinax Robert A · Toccoa, GABuilt 1993 · S/N 2105N167PCBlue Mountain Flyers Inc · Palmerton, PABuilt 2003 · S/N 1349-2003N167QHanson John W · Stewartville, MNBuilt 2009 · S/N HC012N167QQGrondahl Chad R · Peyton, COBuilt 1966 · S/N 670149N167RMSellman Richard · Chadron, NEBuilt 1967 · S/N 18-8514N167RVWelch Jason · Concrete, WABuilt 2016 · S/N 001N167SDierenfeldt William Travis · Manhattan, KSS/N MC-18N167TCFarzaneh-Far Ramin · Brookline, MABuilt 2001 · S/N 1304-2000N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188N1680APaprocki Jason C · Fairplay, COS/N 20-842N1680GSears Richard A · Stevensville, MDBuilt 1968 · S/N 135N1681PWarner Philip · San Marcos, CABuilt 1954 · S/N 22-2467N1682AMackie Scott B · Woodstock, GABuilt 1952 · S/N 20848N1682JBeatty Gary A · Mosinee, WIFirst renewal noticeBuilt 1967 · S/N 28-24083N1683JMiranda Emigdio · El Dorado Hills, CAS/N 28-24084N1684GMitchell Gary N · Kansas City, KSBuilt 1968 · S/N 139N1684JJarriel Investments Inc · Register, GABuilt 1967 · S/N 28-24086N1685Lane Aviation LLC · Tijeras, NMBuilt 2008 · S/N 030-53/54-704N1685GBrisson Gisele A · Hollister, CABuilt 1968 · S/N 194N1685PMckinney Derrill L · Rio Linda, CABuilt 1954 · S/N 22-2471N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093N1686JPatterson John E · Jacksonville, ILBuilt 1967 · S/N 28-24088N1687GSimon Mitchell B · Edison, NJFirst renewal noticeS/N 196N1687JMarsh Flyers LLC · Britton, SDBuilt 1968 · S/N 28-24089N1687PSofia De Venecia LLC · Southampton, NYBuilt 1954 · S/N 22-2473N1688ERegistered aircraftFirst renewal noticeBuilt 1978 · S/N 17271095N1688JTalley Charles B · Ignacio, COS/N 28-24091N1688TCape May Aero LLC · Cape May, NJBuilt 1970 · S/N 28-7125005N1688VAvstem Incorporated · Mc Grath, AKBuilt 1974 · S/N 17263714N1689JHouff Christopher J · Mount Crawford, VABuilt 1968 · S/N 28-24092N1689TFun Flyers LLC · Rapid City, SDBuilt 1970 · S/N 28-7125006N168ABerry James N · Abilene, TXBuilt 2001 · S/N JC8N168ALWittman Matthew · New York, NYBuilt 2000 · S/N 60168N168BCWildlife Air LLC · Dubois, WYBuilt 2006 · S/N 482-2006N168BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881768N168DMarolf Duke · Seward, AKBuilt 1963 · S/N 18-8293N168DDIndian Beach Aviation LLC · Clayton, NCBuilt 2003 · S/N 23811
Back to AD 90-04-06 R1