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.

N7343LAir Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18-7509049N7343WRicht Jerry A · Cleveland, TNBuilt 1963 · S/N 28-1214N73441Stein Aporn U · Pepeekeo, HIBuilt 1976 · S/N 17267464N7344WRegistered aircraftBuilt 1963 · S/N 28-1221N73450Penn Yan Flying Club Inc · Penn Yan, NYBuilt 1976 · S/N 17267468N73451Airward Inc · Columbia, CABuilt 1976 · S/N 17267469N73452Hodges Jonathan D · Port Orchard, WABuilt 1976 · S/N 17267470N73453Mfa LLC · Mount Pleasant, SCBuilt 1976 · S/N 17267471N73454Yr-Aircraft Leasing LLC · Soldotna, AKBuilt 1976 · S/N 17267472N73455101 Flight LLC · Waterford, MIBuilt 1976 · S/N 17267473N73456K E F Enterprises · Plymouth, MABuilt 1976 · S/N 17267474N73457Bmg Aviation Inc · Bloomington, INBuilt 1976 · S/N 17267475N73459Stowers Joshua S · Niceville, FLBuilt 1976 · S/N 17267477N7345GJacks Air Service Inc · Greenville, MEBuilt 1970 · S/N 17259045N7345JAlpha 1 Aviation LLC · Helena, ALBuilt 1968 · S/N 28-24612N7345PGorski Tim B · Larsen, WIBuilt 1961 · S/N 24-2523N7345ZQuicksilver Air Inc · Fairbanks, AKBuilt 1965 · S/N 18-8307N73461Monk Crafton L · Saraland, ALBuilt 1976 · S/N 17267478N73462Farkas Dan · Wyoming, MIBuilt 1976 · S/N 17267479N73464Knight Kevin J · Fort Wayne, INBuilt 1976 · S/N 17267481N73468Tnt Airworks LLC · Hibbing, MNBuilt 1976 · S/N 17267484N7346GBentley Darrell Howard · Powell, TNBuilt 1970 · S/N 17259046N7346JJacobson Daniel · Neenah, WIBuilt 1968 · S/N 28-24620N73472Lajova LLC · Amarillo, TXBuilt 1976 · S/N 17267488N73473Lauro Michael J · Kailua Kona, HIBuilt 1976 · S/N 17267489N73477Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1976 · S/N 17267493N7347DOwens Tyle M · Kenai, AKBuilt 1957 · S/N 22-5138N7347GN7347g LLC · Miami, FLBuilt 1970 · S/N 17259047N7347WHinzman Mark D · Reno, NVS/N 28-1224N73481N73481 LLC · Eaton, COBuilt 1976 · S/N 17267497N73486Begley Edward · Glasgow, KYBuilt 1976 · S/N 17267501N73487Spiess Michael Trustee · Montague, CABuilt 1976 · S/N 17267502N73489Total Flight Aircraft Leasing LLC · Apex, NCBuilt 1976 · S/N 17267503N7348BPatry Andrew · El Mirage, AZBuilt 1977 · S/N A1520753N7348GHardy James H · Albany, NYBuilt 1970 · S/N 17259048N7348JDippolito Mario M · Sherwood, ARBuilt 1968 · S/N 28-24698N7348LMcmahan Harley B · Gakona, AKBuilt 1975 · S/N 18-7509050N7348WRosenau Dillon L · Upham, NDBuilt 1963 · S/N 28-1226N7349814a Flying Club Inc · Mooresville, NCBuilt 1976 · S/N 17267508N7349BWilliams Kiplin S · Midland, NCBuilt 1977 · S/N A1520754N7349JWolfe Frank A · Nahcotta, WABuilt 1968 · S/N 28-24699N7349KWimberly Fred N · Callao, VABuilt 1950 · S/N 20-256N7349WGritzo Russell E · Edgewood, NMBuilt 1963 · S/N 28-1228N734ACRich Lucas Aircraft Sales LLC · Lincoln Park, NJS/N 17268694N734AEFlight Club 502 Inc · Louisville, KYBuilt 1977 · S/N 17268696N734AHAnderson Zachary Q · Rudyard, MTBuilt 1977 · S/N 17268699N734AMGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 1977 · S/N 17268703N734AQBarrans Daniel L · Glenmoore, PABuilt 1977 · S/N 17268705N734ASStory Larry W · Double Oak, TXBuilt 1977 · S/N 17268707N734AULeading Edge Aviation Inc · Doylestown, PABuilt 1977 · S/N 17268709
Back to AD 90-04-06 R1