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.

N15725Hassell Dan J · Ketchikan, AKBuilt 1991 · S/N S1565N15726Aircraft Repair Center · Lake Worth, FLBuilt 1972 · S/N 28-7325147N1572RBurke Kenneth L · Colleyville, TXBuilt 1975 · S/N AA5B-0072N1572VWaldroup Anthony Wayne · Konawa, OKBuilt 1974 · S/N 17263673N1572XRaleigh Flying Club LLC · Raleigh, NCBuilt 1975 · S/N 28-7515425N15731Parsons Allen L · Marriottsville, MDBuilt 1972 · S/N 28-7305129N15734Wayland Flyboys LLC · Wayland, IABuilt 1972 · S/N 28-7305131N15739Flymart Inc · Hastings, FLS/N 28-7305132N1573AHanson Scott F · Grantsburg, WIBuilt 1951 · S/N 20-803N1573RGrand Scott LLC · Okemos, MIBuilt 1975 · S/N AA5B-0073N1573ZSmith David J · Duluth, MNBuilt 2014 · S/N 001N15741Jps Flight School LLC · Salem, ORBuilt 1972 · S/N 28-7305134N15744West Kentucky Flyers Corp · Murray, KYBuilt 1972 · S/N 28R-7335086N1574XQuinones Roland · Plano, TXS/N 28R-7535338N15753Bischoff Daniel C · Camano Island, WABuilt 1972 · S/N 28-7325152N15755Fitzgerald Lee M · High Springs, FLBuilt 1973 · S/N 28-7325154N15757Dickinson Ross · Tilden, TXBuilt 1972 · S/N 28-7305137N15759Williams Sean Aaron · Whiteland, INBuilt 1973 · S/N 28-7325155N1575HCardinal Shares Inc · Rochester, MNS/N 177RG0749N1575KSnodderly Jean · Ward Cove, AKBuilt 1946 · S/N 4302N1575RSpurlock Daniel C · Harrogate, TNS/N AA5B-0075N1575VMissouri Reliability Services LLC · Maryville, MOBuilt 1974 · S/N 17263675N15760Been Flyin LLC · Colchester, CTBuilt 1972 · S/N 28-7325157N15762Carlevaro Bruce C · Edmond, OKBuilt 1972 · S/N 28-7305140N15763First Pryority Bank · Pryor, OKBuilt 1972 · S/N 28-7305141N15764Leyva Jose Luis · New Smyrna Beach, FLBuilt 1972 · S/N 28R-7335089N15765Moulder Tyler Dane · Huntsville, ALBuilt 1972 · S/N 28R-7335090N15768Khleb Hub LLC · Palm Coast, FLBuilt 1973 · S/N 28-7325156N1576AHile Adam V · Apple Creek, OHBuilt 1951 · S/N 20-790N1576JInspire Aviation LLC · Magnolia, TXBuilt 1967 · S/N 28-23982N15770Collett Palmer · Frankfort, KYBuilt 1972 · S/N 28-7325159N1577AYoung Carl J · Lubbock, TXBuilt 1951 · S/N 20-812N1577ESeibert Lynn K · Fresno, CAS/N 1131N1577PPaulson Dean S · Eagle River, AKBuilt 1954 · S/N 18-3740N15782Crane Austin · Redlands, CAS/N 28-7305144N15783Pretorius Anthony · Easley, SCBuilt 1972 · S/N 28-7305145N15789Sidc2 LLC · North East, MDBuilt 1973 · S/N 34-7350094N1578HKramer Jason K · Longview, TXBuilt 1975 · S/N 177RG0752N1578SLamberson Jeremy A · Placerville, CAS/N S9611 0201N1579ADelap Jay · Collinsville, OKBuilt 1951 · S/N 20-813N1579JTornow Saxon Michael · Highland, UTS/N 28-23987N1579RSkelton James P Jr · Lithia Springs, GABuilt 1975 · S/N AA5B-0079N1579TPedro Christopher M · Dushore, PABuilt 1997 · S/N 5055N157AMPhotofax Inc · Gilberts, ILFirst renewal noticeBuilt 2001 · S/N 2157N157ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010053N157BBPtc Flyers LLC · Peachtree City, GABuilt 2014 · S/N 72004N157DF157df LLC · Madison, WIS/N 17260646N157DLSweet David L · Clovis, CABuilt 2010 · S/N 21079N157GSRegistered aircraftBuilt 1997 · S/N 20480N157GWFoster Colt D · Eagle River, AKBuilt 1957 · S/N 18-6182
Back to AD 90-04-06 R1