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.

N493JPRadtke Michael K · Mesilla, NMBuilt 2006 · S/N 2004N493MAGreat Planes Aviation Inc · Rochester, MNBuilt 2001 · S/N 2843486N493RMRaritan Valley Flying School · Princeton, NJBuilt 1999 · S/N 17280784N493SHForsman David G Co-Trustee · South Haven, MNBuilt 1968 · S/N 17256881N49404Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281240N4940EFlyright Aviation Inc · North Las Vegas, NVBuilt 1978 · S/N 17271681N4940FJackson Christopher M · Clearwater, FLBuilt 1976 · S/N 28R-7635445N4940GN4940g LLC · Portsmouth, NHS/N 17273487N4940LDrown William K · Columbus, OHS/N 28-4310N4940UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842228N49417Rich John E · Dunnellon, FLS/N 15281248N49419Ds Flight Services LLC · Battle Ground, WAS/N 15281250N49423Johnson Shem E · Bonners Ferry, IDBuilt 1978 · S/N 15281254N49424Xin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 15281255N4942HFlorida Flyers Flight Academy Inc · Saint Augustine, FLBuilt 1979 · S/N 15284036N49434943 LLC · Kalispell, MTBuilt 2014 · S/N 4311N49432Northshore Group LLC · Wilmington, DEBuilt 1978 · S/N 15281262N49434California In Nice Inc · San Jose, CABuilt 1979 · S/N 15283458N49438Crickmer Charles C · Overton, NVBuilt 1978 · S/N 15281267N49439Wisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1978 · S/N 15281268N4943LBonus Kurt · Wind Lake, WIBuilt 1980 · S/N 15284245N4943ZBlackford Robert G · Mt Airy, MDBuilt 1961 · S/N 22-8538N49447Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281274N4944LWilson Zane D · Fairbanks, AKBuilt 1967 · S/N 28-4313N4944VDavies William T · Auburn, WABuilt 1955 · S/N 1N4944ZHoppes Larry J · Springville, INBuilt 1961 · S/N 22-8540N49455Above All Aviation Inc · Goleta, CABuilt 1978 · S/N 15281281N4945JAsher Academy · Cameron, TXS/N 28R-30692N4945LAlahmadi Hussein I · Avon, CTS/N 28-4314N4945ZWillis James · Pelham, ALBuilt 1961 · S/N 22-8541N49461Blue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 15281287N4946BTippetts Kelly · Richmond, KSS/N CH-346N4946LAndrews University · Berrien Springs, MIBuilt 1967 · S/N 28-4315N4946TElite Fleet Jacksonville LLC · Jacksonville, FLS/N 28-7225286N49471Aeroquest LLC DBA · Olive Branch, MSBuilt 1978 · S/N 15281294N4947GRiya Aviation LLC · Tracy, CABuilt 1980 · S/N 17273494N4947JElite Fleet LLC · Spofford, NHBuilt 1968 · S/N 28R-30694N4947LAmoth Dallas V · Bonners Ferry, IDBuilt 1967 · S/N 28-4316N4947ZSatreaas Kenneth A · Verona, NDBuilt 1961 · S/N 22-8543N4948Andersen Bret E · Chugiak, AKBuilt 1969 · S/N 18-8745N4948BKrause Aviation LLC · Geneva, ILBuilt 1955 · S/N DH-4N4948GTrece Inc · Adair, OKS/N 17273495N4948ZSenn Joshua · Depauw, INBuilt 1961 · S/N 22-8545N4949GFalcon Aviation LLC · South Saint Paul, MNBuilt 1979 · S/N 17273496N4949LLim Young Keun · Carthage, MOBuilt 1967 · S/N 28-4318N4949MCorben Sport Planes Museum LLC · Toccoa, GAS/N 20-640N4949ZPeeples Ryan · Folkston, GABuilt 1961 · S/N 22-8546N494ABGluff Alan D · Franklin, INBuilt 2012 · S/N 91692N494AMOsprey Holding Company LLC · Foley, ALBuilt 1978 · S/N 17269969N494DSBeulah Ltd Trustee · Wilmington, DEBuilt 2003 · S/N 40.294
Back to AD 90-04-06 R1