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.

N8960CChristensen Todd S · Wasilla, AKBuilt 1954 · S/N 18-3261N8960JRegistered aircraftFirst renewal noticeBuilt 1965 · S/N 28-2982N8961CHuguenard Jefferson · Alpharetta, GABuilt 1976 · S/N 28-7615135N8961LStanton Kathleen Z · Burneyville, OKS/N AA1B0661N8961VHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17264317N8961ZHein-Reece Linda K · Shelton, WABuilt 1973 · S/N 17262110N8962FEmbry Aero Ltd · Greenville, ILBuilt 1973 · S/N 430196N8962JStory Allen D · Arlington, TXBuilt 1965 · S/N 28-2984N8962MAshcraft Todd W · Elgin, ILBuilt 2010 · S/N 001N8962YChoate Cass Joseph · Toone, TNS/N 39-122N8963DDoyle Patrick H · Keller, TXBuilt 1958 · S/N 22-6127N8963YNess Rent A Car Inc · Fargo, NDS/N 39-123N896482fly-Safety LLC Trustee · Azle, TXBuilt 1977 · S/N 15282816N8964DThomas Daniel C · Shady Shores, TXBuilt 1958 · S/N 22-6128N8964JKemper Kevin K · Granite Bay, CABuilt 1992 · S/N 028N8964VOneill Jared · Gilroy, CABuilt 1974 · S/N 17264320N89652Lexington Flying Club Inc · Lexington, KYBuilt 1978 · S/N 15282819N89653Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282820N8965CMisner Darrell R · Kasilof, AKBuilt 1953 · S/N 18-2945N8965DSale Reported · Beech Creek, PASale reportedBuilt 1958 · S/N 22-6129N8965JN8965j LLC · Anchorage, AKBuilt 1966 · S/N 28-2987N8965LWeber Daniel M · Oconomowoc, WIBuilt 1974 · S/N AA1B-0415N8965YLucid Thought Consulting LLC · Terre Haute, INS/N 39-127N89661Kelly William W · Springfield, ORBuilt 1978 · S/N 15282821N89664Mulligan James Michael Trustee · Mesa, AZBuilt 1978 · S/N 15282822N8966DDodd Robert L · Humboldt, IABuilt 1958 · S/N 22-6130N8966JBrown Bradford K · Leoti, KSBuilt 1965 · S/N 28-2988N8966LMoffatt Thomas O · Kennesaw, GABuilt 1974 · S/N AA1B-0416N8966VCreider Paul E · Tulsa, OKBuilt 1974 · S/N 17264322N8967JJust Plane Fun LLC · Sunrise, FLBuilt 1965 · S/N 28-2990N8967LGoertz Anton O · Santa Fe, NMS/N AA1B-0417N8967TKellys Flying Service LLC · Warrensburg, MOBuilt 1981 · S/N 28-8190209N8967YQualitair LLC Trustee · MichelstadtBuilt 1971 · S/N 39-130N89681Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282824N8968CDowd John J Jr · Syracuse, KSBuilt 1953 · S/N 18-2978N8968DCleary Katherine E · Mulberry, FLBuilt 1958 · S/N 22-6132N8968JStevens Raymond W · Norfolk, VAS/N 28-2991N8968LAg Aircraft Holdings LLC · Port Saint Lucie, FLBuilt 1974 · S/N AA1B-0418N8968QSonnichsen Landen D · Delta Junction, AKBuilt 2021 · S/N 5802N8968VLittle Gordon D · Watertown, SDS/N 17264324N89693Rjw Aviation LLC · Tampa, FLBuilt 1978 · S/N 15282827N8969CStrahl Guenter H · Jackson, NJBuilt 1976 · S/N 28-7690173N8969VCrowley Brett A · Wasilla, AKS/N 17264325N8969YTrident Aero Services LLC · Park City, UTBuilt 1971 · S/N 39-132N896ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881414N896AKQuadcub Utah LLC · Salt Lake City, UTS/N 1N896ASSilverstein Adam R · Pittstown, NJBuilt 2007 · S/N 82089N896B49 Holdings LLC · Cheyenne, WYBuilt 2021 · S/N MB27N896BCClute William A · Simpsonville, SCBuilt 2011 · S/N 001N896CFMiles Air Leasing LLC · Canonsburg, PABuilt 1968 · S/N 28-4852
Back to AD 90-04-06 R1