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.

N72BWChapman Oliver J · Wingo, KYBuilt 1950 · S/N 18-159N72BZParker Bruce C · Boise, IDBuilt 2010 · S/N 21N72CCCaterfull Inc · Miami Beach, FLBuilt 1975 · S/N 17266347N72CDG Brinkman Aviation Inc · Naperville, ILBuilt 1971 · S/N 28-7205013N72CVMccullough Wayne L · Greenfield, INBuilt 1958 · S/N 22-6115N72CWWalsh Chris · Harrison, IDBuilt 2020 · S/N 22398N72DCopenhaver Tracy K · Anthony, KSBuilt 1972 · S/N 14-72N72DBDavis James M · Tuscaloosa, ALBuilt 1972 · S/N 202N72DDMildebrandt Donald E · East Troy, WIBuilt 2006 · S/N 375N72DEBaschwit Janie · Mooresville, INBuilt 1990 · S/N 001N72DLD Air LLC · The Colony, TXBuilt 1976 · S/N 263-76N72EBVector Airmotive LLC · Frisco, TXS/N 1211-95N72ERMaierhoffer Henry F Jr · Sylvania, GABuilt 1977 · S/N 17269501N72FDEngesath David H · Duluth, MNBuilt 1974 · S/N 17263913N72FYStrongpoint Real Estate Group LLC · Danville, PABuilt 1966 · S/N 3425N72GSSmith Gregory S · New Orleans, LABuilt 2007 · S/N 70473N72HQKirby Bobby J Jr · Hernando, FLBuilt 1977 · S/N 11966721N72HYTwedt Dennis · Baker, MTBuilt 2004 · S/N 2279N72JCBores Scott J · Huron, OHS/N 3324N72JHBooher Stephen R · Corrales, NMBuilt 1999 · S/N 1N72JNTroy I Mounts Md Inc · San Juis Obispo, CABuilt 1974 · S/N 17263882N72KBBennett Aviation LLC · New York, NYBuilt 2012 · S/N 3155N72KCYeilding R Edward · Florence, ALBuilt 1972 · S/N 298-72N72KJJameson Kirk A · Lake Panasoffkee, FLBuilt 2018 · S/N BC11117009AN72KPMorrison Robert H · Fort Denaud, FLBuilt 1994 · S/N 1234N72KWPerformance Aviation LLC · Wilmington, DEBuilt 1972 · S/N 2028N72LFLarrabee Joey S Trustee · Holyoke, COBuilt 2005 · S/N 1388-2005N72LMCoonan Paul M · Huntsville, MOS/N AA5-0217N72LPRavens Rebuilders Inc · Ellenboro, WVBuilt 2003 · S/N 0152N72LTReynolds Cindy L · Wills Point, TXBuilt 1968 · S/N 580863N72MMagical Thing Air LLC · Jasper, INBuilt 2003 · S/N DM0287MTAN72MGAerosox LLC · Diamondhead, MSBuilt 1967 · S/N 680033N72MHQuasar Aircraft Corp · Jacksonville, FLBuilt 1978 · S/N 28R-7918008N72MLLoudis Leonard A · Arvada, COBuilt 2007 · S/N 70928N72MVBeck Douglas J · Lincoln, NEBuilt 2001 · S/N 80842BN72MWStaggs Austin · Cudjoe Key, FLBuilt 1963 · S/N 30-171N72NEr Flight LLC · Reedsville, PABuilt 1971 · S/N 28-7205125N72NVCarroll Cecil Dean · Dexter, MOBuilt 2009 · S/N 70086N72NXNexair Avionics LLC · Plymouth, MABuilt 1976 · S/N 17267923N72PGFox William Casey Trustee · Pipe Creek, TXBuilt 1998 · S/N 631N72PMAircraft & Aviation Professionals LLC · Coldwater, MIS/N AA1A-0426N72QTRegistered aircraftBuilt 1972 · S/N 365-72N72RCSchmid Mark D · Haddon Heights, NJBuilt 1996 · S/N 459N72RJEngerer Dennis E · Northville, MIBuilt 1968 · S/N 28R-30891N72RMSparks Brian E · Monmouth, ORBuilt 1981 · S/N 8020CN72RPVisscher Fred D · Madison, GABuilt 1952 · S/N 18-2214N72RVHarral Blake G · Prescott Valley, AZFirst renewal noticeBuilt 1999 · S/N 2401N72SAInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 17272017N72SFMcintosh Stephen · Fishers, INBuilt 2003 · S/N 3053N72STSierra Tango Air LLC · Senoia, GAS/N 17269433
Back to AD 90-04-06 R1