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.

N8323AWisconsin Aviation Inc · Watertown, WIBuilt 1981 · S/N 28-8216019N8323BMidcoast Helicopter Services Inc · La Ward, TXBuilt 1995 · S/N 2535N8323VToczek Keith E · Yankton, SDS/N 55N8323WConcord Aviation Services LLC · Concord, NHBuilt 1965 · S/N 28-2500N8324Veal Tim S · Egegik, AKBuilt 1953 · S/N 18-2377N8324EGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 17272189N8324USyren David N · Anchorage, AKBuilt 1995 · S/N 2570MN8324WSwofford Sherman A · Inman, SCBuilt 1965 · S/N 28-2501N8324YStein Anthony J · Locust Grove, GABuilt 1967 · S/N 30-1465N8325EAnzaldi Carl J · Cherry Valley, CABuilt 1959 · S/N 1503N8325LLeading Edge Flight Services Inc · Hampshire, ILBuilt 1980 · S/N 28-8116131N8325RSy Aviation LLC · Judsonia, ARS/N 28-22197N8325TColumbia Jet Center Inc · Columbia, MOBuilt 1980 · S/N 28-8116134N8325UCross Dustin · Tonto Basin, AZBuilt 1964 · S/N 17252225N8325VPct Hawk Inc · Wilmington, DEBuilt 1980 · S/N 28-8190143N8325WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1965 · S/N 28-2502N83268Wright Kim B · Bozeman, MTS/N 18-7609057N8326CNewman Carl D · Phoenix, AZBuilt 1980 · S/N 28-8190152N8326ENorton Eric D · Nauvoo, ILBuilt 1960 · S/N 1582N8326WBarnwell Sam M · Traverse City, MIBuilt 1965 · S/N 28-2504N8326YEastern Stearman Inc Trustee · Leesburg, VABuilt 1967 · S/N 30-1468N83271Nohrenberg Raymond C · Pingree, NDS/N 18-7609061N83272Bowker James D · Willow, AKBuilt 1976 · S/N 18-7609063N83275Perry Scott D · Hood River, ORBuilt 1976 · S/N 18-7609062N83278Hamlin Andrew J · Two Rivers, AKBuilt 1976 · S/N 18-7709047N8327RWelsh Rick F · Ewing, VABuilt 1966 · S/N 28-22199N8327WFuture Flying LLC · Manassas, VABuilt 1965 · S/N 28-2506N8327YKaeser Robert E · Lafayette, INBuilt 1967 · S/N 30-1469N83281Chandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 18-7609064N83283Hayton James B · Sedro Woolley, WABuilt 1976 · S/N 18-7609065N83285Dyches Abigail · Eagle River, AKBuilt 1976 · S/N 18-7609067N8328CSky Craft LLC · Powell, OHBuilt 1975 · S/N 28-7690116N8328PSale Reported · Lewes, DESale reportedS/N 24-3581N8328TOcala Aviation Services Inc · Ocala, FLBuilt 1981 · S/N 44-8107037N8328UHale Larry D · Charlotte, NCBuilt 1995 · S/N 2567N8328WTolmachev Nikolay A · Anchorage, AKBuilt 1965 · S/N 28-2507N8328YSims Chris · Colleyville, TXBuilt 1967 · S/N 30-1470N8329649 Ranch Co LLC · Odonnell, TXBuilt 1976 · S/N 18-7609068N83299Brewer Danny E Jr · Nikiski, AKBuilt 1976 · S/N 18-7609070N8329VBuck Timothy A · Howland, MES/N 119N8329YHarbock Inc · Wilmington, DEBuilt 1967 · S/N 30-1471N832ABeck John Edward · Newton, IABuilt 1951 · S/N 22-133N832ATDot Aviation LLC · Wilmington, DEBuilt 2012 · S/N 4496312N832DCCase Daniel J · Spokane, WABuilt 1979 · S/N 17271180N832RMMcbride Christen L · Elgin, TXBuilt 1996 · S/N 42121N832TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881706N832WWJacobson Richard T · Overton, NVS/N 814N8330LParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8116141N8330RBriggs Michael L · Howell, MIBuilt 1966 · S/N 28-22202N8330VJensen Carla J · Pingree, IDBuilt 1966 · S/N 43
Back to AD 90-04-06 R1