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.

N586FLAce Aircraft Leasing Inc · Nazareth, PABuilt 1971 · S/N 28-7125444N586KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843917N586MAWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1999 · S/N 2843297N586RHLugar Daniel A · St Helena Is, SCS/N 597RN586SRice James L · Mckinney, TXBuilt 1981 · S/N 17274646N587Plane Management LLC · Conroe, TXBuilt 1972 · S/N 649N58700Mile High Advertising Inc · Doylestown, PABuilt 1942 · S/N 75-3908N5870QScott Stewart · Columbia, MOBuilt 1965 · S/N 3143N5870UWhite Thomas A · Roanoke, TXBuilt 1970 · S/N 28-26702N5871LSleeper James A · Middleburg, FLBuilt 1972 · S/N AA5-0071N5871QNeosho Investments LLC · Neosho, MOBuilt 1965 · S/N 800N5871ZJohnson Nathan P · Rapid City, SDBuilt 1963 · S/N 22-9729N58720International Air Services Inc Trustee · Carson City, NVS/N 75-4633N5872LMai David A · Chattanooga, TNBuilt 1972 · S/N AA5-0072N5872QAir Mods And Repair Inc · Robbinsville, NJBuilt 1965 · S/N 3144N5872ZCollins James T · Blossvale, NYBuilt 1963 · S/N 22-9728N5873QSternhagen Richard A · Friendship, WIBuilt 1965 · S/N 801N5873WPropst David A · Exchange, WVS/N 28-2503N5873ZSchramm Thomas L · South Rockwood, MIBuilt 1963 · S/N 22-9731N5874DFeuerborn Ethan T · Boise, IDBuilt 1960 · S/N 187453N5874UFlying Wright Aviation LLC · Henderson, NVS/N 28-26707N5874ZGodbey Patrick · St Simons Island, GABuilt 1963 · S/N 22-9732N5875HPresten Eric A · Vineburg, CABuilt 1949 · S/N 16-493N5875UTews Jamie S · Greenville, WIBuilt 1970 · S/N 28-26708N5875VCrew Michael A · Phoenix, AZBuilt 1977 · S/N 28-7716209N5875ZReed John F · Bemus Point, NYBuilt 1963 · S/N 22-9733N5876DKirkendall James · N Richlnd Hls, TXBuilt 1956 · S/N 22-4557N5876LWilson James · Bagwell, TXS/N AA5-0276N5876U3shahs Aviation LLC · Temecula, CAS/N 28-26709N5876WKiss George C · Bangor, PAS/N 28-2552N5876ZDraper Scott · Rutland, VTBuilt 1963 · S/N 22-9736N5877FFeldvary John · Jackson, MIBuilt 1976 · S/N 28-7715155N5877LFlyboys Aviation LLC · Sioux City, IABuilt 1972 · S/N AA5-0077N5877QKenyon Alexandrea A · Costa Mesa, CABuilt 1965 · S/N 803N5877VWest Keith W · Slatington, PABuilt 1977 · S/N 28-7790505N5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 17271949N5878GConner Norman V · Lakewood, WABuilt 2005 · S/N 70179N5878HDelaware Taildraggers LLC · Hancock, NYBuilt 1949 · S/N 16-495N5878LGomez Blanco Rafael · Lakewood, CABuilt 1972 · S/N AA5-0078N5878UAlbright Jasper N · Raleigh, NCBuilt 1970 · S/N 28-26710N5878WWorrell Wayne · Campbellsville, KYBuilt 1965 · S/N 28-2555N5879HParlin Larrol L · Friday Harbor, WABuilt 1949 · S/N 16-497N5879LN5879l LLC · Lewes, DEBuilt 1972 · S/N AA5-0229N5879UJacobs Levon Jr · Oak Hill, FLBuilt 1970 · S/N 28-26713N587BHitterman James D · Metropolis, ILBuilt 1994 · S/N 3185N587KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843928N587KBSwihart Painting LLC · Bolivar, MOBuilt 1978 · S/N 103978N587MALong Island Aviators LLC · Seaford, NYBuilt 2002 · S/N 2843517N587PAVan Hatten Michael Sr · Fairbanks, AKBuilt 1989 · S/N 1809033N587SPPinnacle Aviation Services Inc · Encinitas, CABuilt 2000 · S/N 172S8518
Back to AD 90-04-06 R1