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.

N8749ESheboygan Flight Plane I LLC · Sheboygan, WIBuilt 1976 · S/N 28-7615158N8749FTsr Sky Chicken LLC · Cleveland, TXBuilt 1952 · S/N 52-0074N8749NPowell Randell W · Wachapreague, VABuilt 1969 · S/N 28-25569N8749ZRegistered aircraftBuilt 1978 · S/N 177RG1351N874ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881388N874CCValiair Ltd Co Trustee · Casper, WYBuilt 2001 · S/N 9931CCN874KGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1929 · S/N 135N874NPBruther Thomas J · Temecula, CABuilt 2009 · S/N 90874N874SCRichards Ryan J · Boise, IDS/N 18-7409112N874TJJasper Tara · Santa Rosa, CABuilt 2018 · S/N CC19-0034N874WJPage Ward Carlton · Reston, VABuilt 2013 · S/N 82874N8750Kellander Thomas · Fairmont, MNBuilt 1973 · S/N 468-73N8750ECrosscheck Ftc LLC · Greeneville, TNBuilt 1976 · S/N 28-7690197N8750NMidwest Avionics LLC · Peculiar, MOBuilt 1969 · S/N 28-25570N8750VKeller Klaus · Thetford Center, VTBuilt 1975 · S/N 1104-75N8751EHansen William L · Shasta Lake, CABuilt 1976 · S/N 28-7690198N8751FLay Jerry K · Minonk, ILBuilt 1962 · S/N 52-0073N8751VClemens Robert Lyle · Oklahoma City, OKS/N 200-75N8752Fender Darrell L · Colfax, WABuilt 1973 · S/N 469-73N8752VRichard Flying Service Inc · Rayne, LABuilt 1975 · S/N 317-75N8752YTwin Engine Freedom LLC · Port Saint Lucie, FLBuilt 1969 · S/N 30-1905N8753Carlson Jeffrey M · La Jolla, CABuilt 1973 · S/N 361-73N8753CSlayden Steven M · Rhome, TXBuilt 1953 · S/N 18-2836N8753NWright Pamela J · Easton, PABuilt 1969 · S/N 28-25573N8753VScott Gorski Aviation Aerobatics · Bothell, WABuilt 1975 · S/N 201-75N8754ESix Two Seven Aviation LLC · Sardis, MSBuilt 1976 · S/N 28-7625155N8754VLoomer Donald W · Williston, NDBuilt 1975 · S/N 855-75N8754YAmelia Air 863 LLC · Lakeland, FLBuilt 1969 · S/N 30-1908N87553Wais Richard J · Leesburg, FLS/N 114N8755ABluegrass Aircraft Group LLC · Benton, KSBuilt 1997 · S/N 80864N8755CDebra Cay LLC · Scottsdale, AZBuilt 2003 · S/N 10223N8755EGokoffski Anthony · Larkspur, CAS/N 28-7690200N8755MTraver Ronald D · Lantry, SDS/N M-543N8755VBoettcher Michael W · Soldotna, AKBuilt 1975 · S/N 854-75N8755YTwo Twins Aviation Inc · Wilmington, DEBuilt 1969 · S/N 30-1909N8756CDt Aviation LLC · Ontario, CABuilt 1976 · S/N 28-7615125N8756DExecutive Holdings LLC · Fairbanks, AKS/N 22-5940N8756EHowell Richard · Louisville, KYS/N 28-7690201N8756MMutschler George R · Paradise Valley, AZS/N M-544N8756YAgri Business Aviation Inc · Sparta, ILBuilt 1969 · S/N 30-1910N8757CKellermann Denis J · Lompoc, CABuilt 1953 · S/N 18-2844N8757ELa Copious LLC · Pinetop, AZFirst renewal noticeS/N 28R-7635211N8757MHolmes Charles E · South Bend, INBuilt 1963 · S/N M-545N8757N57 November LLC · Charlotte, NCBuilt 1969 · S/N 28-25576N87583Floten William F · Seattle, WABuilt 1946 · S/N 151N87589Johanson Jason · Groveland, CAS/N UC1-R158N8758CYuknis Leonard F · Wasilla, AKBuilt 1953 · S/N 18-2842N8758EMiller Kevin · Dover, DEBuilt 1976 · S/N 28R-7635212N8758MAndrew Manuel Driscoll · South Yarmouth, MABuilt 1964 · S/N M-546N87592Sorensen Eric N · Hilo, HIS/N 160432
Back to AD 90-04-06 R1