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.

N726CMEvans Douglas A · Amarillo, TXBuilt 2001 · S/N 1347N726DFTactical Aviation LLC · Brownstown, MIBuilt 1981 · S/N 28-8216023N726DTThompson Donald H · Tallahassee, FLBuilt 2000 · S/N 002N726GASouth Texas Air Force LLC · Mission, TXBuilt 1978 · S/N GA7-0025N726JHClearview Flying Club Inc · Westminster, MDBuilt 1977 · S/N 17269494N726JVGill James J · Anchorage, AKBuilt 1978 · S/N 18-7809088N726LLRegistration Pending · Fargo, NDRegistration pendingBuilt 2010 · S/N LL001N726MBBurgos Orlando · Venice, FLBuilt 1982 · S/N 17275766N726MMRiverside Flight Academy LLC · Riverside, CABuilt 1979 · S/N 17272970N726NDUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 2881488N726PKSimply Living LLC · Fort Myers, FLBuilt 2003 · S/N 90-109N726RVParris Brian · Long Beach, WABuilt 1997 · S/N 23012N726TFDewante Robert R · Corvallis, MTBuilt 1996 · S/N 0020184N7270DYoung Evan G · Anchorage, AKBuilt 1957 · S/N 18-5678N7270GBruneau Paul G Jr · Madison, MEBuilt 1970 · S/N 17258970N7270JJones Frederick W · Burgaw, NCS/N 28-24610N7270WEast West Aviation Club · DuffelS/N 28-1105N7271CChesley James Philip · Mesa, AZBuilt 1975 · S/N 28R-7635098N7271DCape May Aerial Advertising LLC · Cape May Ch, NJBuilt 1957 · S/N 18-5679N72727Hice Michael D · Cookeville, TNBuilt 1971 · S/N 177-01678N7272YToucan Aviation LLC · Bentonville, ARBuilt 1964 · S/N 30-311N7273KPetik Neil · Barney, NDBuilt 1950 · S/N 18-182N7274JFairway Chalet LLC · San Antonio, TXS/N 28-24617N7274WSky & Sea Horizons LLC · Memphis, TNBuilt 1965 · S/N 28-2895N7275CAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280503N7275DMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280790N7275JAmon Mccrary Bryley · Bullard, TXBuilt 1968 · S/N 28-24618N7275LLaughlin Jonathan · Rich Hill, MOBuilt 1965 · S/N 28 2405N7275REdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8026N7275WHinkley Dean E · Sun City, FLBuilt 1963 · S/N 28-1111N7275YCross John Benjamin · Lake Charles, LABuilt 1964 · S/N 30-314N7276DDolfi Ricky Jr · Palmer, AKS/N 18-5685N7276JWheeler Kelly E · Columbia Falls, MTBuilt 1968 · S/N 28-24619N7276KSaunders Timothy S · Utopia, TXBuilt 1950 · S/N 18-184N7276WFlyright Aviation LLC · Plymouth, MNBuilt 1963 · S/N 28-1114N72772Wells Danny L · Tipp City, OHBuilt 2021 · S/N 91495N7277KBaker Thomas A · Tijeras, NMBuilt 1950 · S/N 18-183N7277WOrganic Media Studio LLC · Hattiesburg, MSBuilt 1963 · S/N 28-1146N7277YDouble A Investments Inc · Rowland, NCBuilt 1964 · S/N 30-315N7278DAugustin Caleb J · Madison, ALS/N 18-5691N7278KHolden Daniel N · Anacortes, WABuilt 1950 · S/N 18-185N7278PGabrielson Guy G III · Peabody, MABuilt 1961 · S/N 24-2454N7279KRaven Wings LLC · Talkeetna, AKBuilt 1950 · S/N 18-187N7279PWestrand Jeffrey C · Amboy, WAS/N 24-2455N7279YChormicle James R · Littlerock, CABuilt 1964 · S/N 30-317N727ACLong Island Aviators LLC · Seaford, NYBuilt 1977 · S/N 28-7890128N727AJMeyer Joshua · Fairborn, OHBuilt 1968 · S/N 28-24624N727BHPiper 7bh LLC · Middleton, MABuilt 1974 · S/N 28-7415464N727DCCalianno David · Spring Hill, FLBuilt 1974 · S/N 17702086N727DDAlba Aviation Services Inc · Scottsdale, AZBuilt 2002 · S/N 3328
Back to AD 90-04-06 R1