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.

N88092Verhulst Charles · Reva, SDBuilt 1974 · S/N 723-74N88098Merriwether David E · Whitesburg, GABuilt 1974 · S/N 467-74N880CBJ-Airco LLC · Nashville, TNBuilt 1973 · S/N 17262582N880FWebfoot Aviation LLC · Chesterfield, MOBuilt 2023 · S/N 3417N880FTFlorida Institute Of Technology · Melbourne, FLBuilt 2000 · S/N 4496033N880HCBadger Heli Corp · Wilmington, DEBuilt 1989 · S/N 1208N880JGGray Richard D · White Stone, VABuilt 2022 · S/N 82827N880MABrekken Chris · Prescott, WIBuilt 2007 · S/N 2433N880MXCool Breeze LLC · Shelbyville, KYBuilt 2002 · S/N 002DCN880PUPurdue University Trustees · West Lafayette, INBuilt 2025 · S/N 2881949N880RVHamilton David S · Locust Grove, GABuilt 2003 · S/N 80001N880THAviation Peter Corp Of New York · New York, NYBuilt 1980 · S/N 172RG0522N8810CGroenwegen Bruce C · Snohomish, WABuilt 1953 · S/N 22-1423N8810DNorman Timothy J · Tofte, MNBuilt 1958 · S/N 22-5979N8810NShawl Robert M · Woodlake, CABuilt 1969 · S/N 28-25657N88110Lovas Thomas A · Anchorage, AKBuilt 1974 · S/N 725-74N88118Richard Thomas W · Greenville, MSBuilt 1974 · S/N 726-74N88119Aysta Nathan P · Hermantown, MNBuilt 1974 · S/N 606-74N8811UAlder William D III · Athens, OHBuilt 1965 · S/N 17252718N8811YHutchinson Douglas E · Cle Elum, WABuilt 1969 · S/N 30-1968N8812DSowders Darwin G · Robinson, TXBuilt 1958 · S/N 22-5981N8812YSpain Air LLC · Dadeville, ALBuilt 1969 · S/N 30-1969N88130Harper Clayton E · Seabrook, TXBuilt 1974 · S/N 727-74N88134Morris William F B · Klamath Falls, ORBuilt 1974 · S/N 1040-74N8813MMja Flight LLC · Justin, TXBuilt 1964 · S/N TD-571N8813NLangton Shane A · Boise, IDBuilt 1969 · S/N 28-25660N88140Green Flying Machine LLC · Prior Lake, MNBuilt 1974 · S/N 1042-74N88144Hitchens Steven · Conesville, OHS/N 79-74N88149Cheshire Brad F · Flower Mound, TXS/N 157-74N8814FBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 28-7790268N8814JCarey H Dwain · Cheyenne, WYBuilt 1965 · S/N 28-2766N8814NMarshall Lance A · Portland, ORBuilt 1969 · S/N 28-25661N8814YTwin C 14y LLC · Cape Coral, FLBuilt 1969 · S/N 30-1972N88156Wilcox Aerial Applications Inc · Tilden, NEBuilt 1974 · S/N 730-74N8815NJenkins Roger Clayton II · Plain Dealing, LABuilt 1969 · S/N 28-25663N8815YBauer Andrew J · Concord, NCBuilt 1969 · S/N 30-1973N88161Jordan Jay S · Wasilla, AKBuilt 1974 · S/N 84-74N88165Becker Aaron S · Santa Cruz, CABuilt 1974 · S/N 731-74N8816CNye Brian M · Independence, ORS/N 22-1427N8816JHuff Roger A · Johnstown, OHBuilt 1965 · S/N 28-2770N88172Hughes Glenn D · Wrightsville Beach, NCBuilt 1974 · S/N 470-74N8817CSharon Ricky E · Roberta, GABuilt 1976 · S/N 28-7625132N8817JMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1965 · S/N 28-2771N8817YWiehl Thomas K III · Earlysville, VABuilt 1969 · S/N 30-1975N88181Oglesby Holdings LLC · Henrico, VABuilt 1974 · S/N 732-74N88182Dachnowicz Peter A · Avon, CTBuilt 1974 · S/N 471-74N88184Delmolino Kevin R Sr · Walkersville, MDBuilt 1974 · S/N 472-74N88188Blair Keeley A · Erie, COBuilt 1974 · S/N 473-74N88189Ocean Aerial Ads Inc · Ocean City, MDS/N 89-74N8818CHalligan Austin C · Sidney, NES/N 22-1433
Back to AD 90-04-06 R1