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.

N9081JPerkins Jimmy Keith · Lonoke, ARBuilt 1966 · S/N 28-3118N9081LReed William B Trustee · San Jose, CABuilt 1970 · S/N 224-70N9081VSale Reported · Phoenix, AZSale reportedBuilt 1968 · S/N 690015N90829Leading Edge Aviation Consultants LLC · Windsor, CTBuilt 1985 · S/N 28-8690011N9082DLeahy Garry E · Van Wert, IABuilt 1958 · S/N 18-6450N9082LSmethurst Jeffrey C · San Francisco, CABuilt 1970 · S/N 781-70N90839White Jake W · San Antonio, TXS/N 101N9083BNorth Coast Flight School Inc · Meadville, PABuilt 1985 · S/N 28-8590076N9083DSachs Randy S · S Huntington, NYBuilt 1986 · S/N 28-8690050N9083KShuey Robert D III · Albertville, ALBuilt 1977 · S/N 28-7890174N9083LPeavy Michael J · Chico, CAS/N 256-70N9084FIsland Bound LLC · Dunedin, FLBuilt 1980 · S/N 172RG0352N9084VLinear Air LLC · Herriman, UTBuilt 1968 · S/N 690018N9085JBligh Michelle C · Oceanside, CABuilt 1966 · S/N 28-3122N9085KSale Reported · Grayling, MISale reportedBuilt 1977 · S/N 28-7890175N9085LBlanton Jeffrey D · Valley Center, KSBuilt 1970 · S/N 226-70N9086DDarrow John K · Soldotna, AKBuilt 1958 · S/N 18-6460N9086JBrogan William J · Port Matilda, PABuilt 1966 · S/N 28-3123N9086KMedia Stew LLC · Carson City, NVBuilt 1977 · S/N 28-7890176N90874Myers Brian R · South Bend, INBuilt 1985 · S/N 28-8690014N90878Schmoll Steven D · Zimmerman, MNBuilt 1974 · S/N 194HN9087DBolden Family Farms · Little Rock, ARBuilt 1986 · S/N 2816001N9087LDeterding Jim L · Pond Creek, OKS/N 783-70N9088Sale Reported · Manvel, TXSale reportedBuilt 1929 · S/N 869N90882Bucciarelli Dominick F · Pueblo, COBuilt 1976 · S/N 848N9088DMetro Aircraft Co · Bloomington, MNBuilt 1986 · S/N 28-8616049N9088JRiggins Ryan W · Durango, COBuilt 1966 · S/N 28-3126N9088LLegends LLC · Willow, AKBuilt 1970 · S/N 782-70N9088QGolf Foxtrot Yankee LLC · Kingston, NYBuilt 1986 · S/N 2890002N9088TSlykerman John A · Bakersfield, CABuilt 1978 · S/N CCI-78-2N90898Nation Steven R · Hurricane, UTBuilt 2007 · S/N 24131N9089CCrew Sourcing Inc · Wilmington, DEBuilt 1985 · S/N 28-8690016N9089HDavis Joseph S · Andalusia, ALBuilt 1975 · S/N 17265936N908AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843802N908AFRobinson Craig M · Colfax, CABuilt 1967 · S/N 28-23976N908AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881946N908AZWingsleasing LLC · Wichita, KSS/N 40.388N908BLBoudreaux Jacques P · Shreveport, LABuilt 2006 · S/N 90854N908CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8331N908DRRhodes Dennis R · Taylorsville, GABuilt 2008 · S/N 91359N908JDNash Gregg Lynn · New Waverly, TXBuilt 2009 · S/N 81284N908NDUniversity Of North Dakota · Grand Forks, NDBuilt 2020 · S/N 2881368N908QCCook Hugh Q · Aurora, COBuilt 2020 · S/N 82854N908SCGomez Ryan Rene · Fort Worth, TXBuilt 1976 · S/N 177RG0943N908TBushby Harvey M · Minooka, ILBuilt 2009 · S/N M-II-2418N908WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281525N90908Charles Wilford W · Big Lake, AKBuilt 1981 · S/N 18-8109043N9090BHaynes Aviation LLC · Wetumpka, ALBuilt 1986 · S/N 2890003N9090LBascue Brandon D · Ward, ARFirst renewal noticeS/N 227-70N90912Snead Douglas A · Derby, KSBuilt 1972 · S/N 338-73
Back to AD 90-04-06 R1