AD 90-04-06 R1

Registered aircraft · 68,377

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.

N8857NWolf Terry T · Lake Katrine, NYBuilt 1969 · S/N 28-25712N8857YLewis Leslie S · Glendale, AZBuilt 1970 · S/N 39-12N88587Tucker Anthony W · Brazoria, TXBuilt 1946 · S/N 16213N8858CLebron Renard Jr · Gulfport, MSBuilt 1953 · S/N 18-2922N8858JBirdie N88 LLC · Conifer, COBuilt 1965 · S/N 28-2928N8858LRedro Inc · Owatonna, MNBuilt 1974 · S/N AA1B-0358N8859DBbc Group LLC · Sanford, NCBuilt 1958 · S/N 22-6030N8859NThrash Enterprises LLC · Clarksville, TNBuilt 1969 · S/N 28-5340N885ACWingsleasing LLC · Wichita, KSBuilt 2020 · S/N 2881396N885ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496322N885CFJulian Michael · Las Vegas, NVBuilt 2025 · S/N 140228N885FTFlorida Institute Of Technology · Melbourne, FLBuilt 2006 · S/N 4496225N885SABlevins Edgar R · Zachary, LABuilt 2001 · S/N 0014N885SMDews Robert Mark · Jefferson, TXS/N 24673N8860DCooley Tony A · Dallas, ORBuilt 1958 · S/N 22-6032N8860JBjg LLC · Langdon, NHBuilt 1965 · S/N 28-2826N8860LCrowe George J · East Ridge, TNBuilt 1974 · S/N AA1B-0360N88610Cape May Aerial Advertising LLC · Rio Grande, NJBuilt 1946 · S/N 16238N8861FMurtaza Syed S · Minneapolis, MNBuilt 1976 · S/N 28-7715292N8861NMcdonald Timothy A · Rush City, MNBuilt 1969 · S/N 28-25410N8862FAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 28-7715293N8862LTisdale Matthew · Alameda, CABuilt 1974 · S/N AA1B-0362N8862NHatley Wayne S · Hermitage, TNBuilt 1969 · S/N 28-25717N8862TAdams Donald L · Huntsville, ALBuilt 2010 · S/N 72640N8862YState Of Montana · Helena, MTBuilt 1973 · S/N 18-7409026N8863CClearsky II LLC · Tyler Hill, PABuilt 1953 · S/N 22-1494N8863DSanders Darrel T · Camp Douglas, WIBuilt 1958 · S/N 22-6037N8863FCain James W · Big Rapids, MIS/N 63-0243N8864DMarsteller Paul A · Tallulah Falls, GABuilt 1958 · S/N 22-6038N8864LArnold Charles E · Lowell, MABuilt 1974 · S/N AA1B-0364N8864YMiller Donald W · Harrisonburg, VABuilt 1970 · S/N 39-19N8865CMayo Jesse J · Fairbanks, AKS/N 20-1034N8866CEckels Shaun R · Pickerington, OHBuilt 1953 · S/N 20-1031N8866FReynolds Darryl G · Wills Point, TXBuilt 1969 · S/N 0242N8866NYu Hermon Lemuel C · Mays Landing, NJBuilt 1969 · S/N 28-26251N8866YCarson Ryan P · Albuquerque, NMBuilt 1971 · S/N 28-7125339N8867NMulloy Dennis · Indian Mound, TNBuilt 1969 · S/N 28-25729N8867PAnderson Keith C · Puyallup, WABuilt 1970 · S/N 18-8867N8867YPiper Thirty Nine LLC · Glasgow, MTBuilt 1970 · S/N 39-22N8868Hodges Jay W · Graham, TXBuilt 1973 · S/N 931-73N8868JGannon Robert M · Hamburg, NYBuilt 1968 · S/N 28-24354N8869JRoot Roger T · Moscow, IDBuilt 1965 · S/N 28-2841N8869NCarland Ralph B · Altoona, PABuilt 1969 · S/N 28-25731N8869YCome Fly Away LLC · Waterloo, ILBuilt 1970 · S/N 39-24N886ACAir Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881397N886ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496323N886BNairn Bryan D · Edgewood, WABuilt 2001 · S/N 21963N886ECUp And Up Aviation LLC · Magnolia, TXBuilt 1977 · S/N 28-7816262N886PBarrons Aviation Services LLC · Henderson, NVBuilt 1962 · S/N 2328N886RASmith Daryl N · Coventry, CTBuilt 1959 · S/N 22-6944
Back to AD 90-04-06 R1