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.

N56996Zarn Douglas J · Amboy, MNBuilt 1973 · S/N 28-7425080N56997Bibb John G · Paragould, ARBuilt 1973 · S/N 28-7425081N56999Lofty Images LLC · Owosso, MIS/N 517N5699DClear Lake Management Corp · Wilmington, DEBuilt 1981 · S/N 510N5699HHalmans John D · Baker, MTS/N 16-310N5699NStyer David B · Pendleton, ORBuilt 1981 · S/N 1220N5699ULrh Equipment LLC · Pendleton, ORS/N 511N5699VMesmer Robert F · Grand Island, NYBuilt 1981 · S/N 512N569BSZanetta Wayne T · Portland, ORBuilt 2014 · S/N 18-1686N569DPHale William J · Whitehouse, TXBuilt 2008 · S/N 90707N569FLN7396w LLC · Coeymans Hollow, NYS/N 28-7125413N569MKindred Daniel P · Jacksonville, ILFirst renewal noticeS/N 20-0009N569MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.314N569NEMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1978 · S/N 15282580N569RVRicketts Michael D · Weirsdale, FLBuilt 2010 · S/N 91519N569SPGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2000 · S/N 172S8494N569TJAnderson Thomas C · Poplar Grove, ILBuilt 2013 · S/N 259RN569TSBig South Fork Aero Inc · Huntsville, TNBuilt 1993 · S/N 722-93N569WHGp Cub Air LLC · Sioux Rapids, IABuilt 1965 · S/N 18-8271N56AMPeavy Michael J · Chico, CABuilt 1976 · S/N 957N56BGGuernsey Gibson R · Belen, NMBuilt 1980 · S/N 140N56BVEuroaviation Inc Trustee · KematenBuilt 1978 · S/N AA5A0719N56CEWave Shack Acquisitions LLC · Lewes, DEBuilt 1991 · S/N LARES 0001N56CPBulldog Aviation LLC · Goodyear, AZBuilt 1969 · S/N 700003N56DBBerger Dale · Bay Village, OHBuilt 2002 · S/N 1128N56DDMeier Perry S · Conroe, TXBuilt 1976 · S/N D2DN56DFThorpe Arthur N Jr · Salisbury, MDBuilt 1980 · S/N 44-8107030N56DGEagle East Aviation Inc · North Andover, MABuilt 1976 · S/N 17266239N56DWReed John S · Wasilla, AKS/N 18-7709159N56EB56 Eb Inc · Jacksonville, FLBuilt 1968 · S/N 28R30647N56ECBpc Aviation LLC · Rosamond, CABuilt 1962 · S/N 17249661N56EKQuailair LLC Trustee · MichelstadtS/N 2890145N56EPSanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17270728N56ERGsell Bruce Ward · Southampton, NJBuilt 1979 · S/N AA5B-1094N56FAir Kings LLC · West Chester, PABuilt 1975 · S/N 17265348N56FASilver Express Co DBA · Miami, FLBuilt 1978 · S/N 172-69682N56FDDefibaugh Fred M · Chino Alley, AZS/N 3535N56FJRocky Mountain Construction LLC · Klamath Falls, ORBuilt 2023 · S/N AL-367N56FRWoods Mark T · Fernandina Beach, FLBuilt 1955 · S/N 260N56GBCalhoun Keith A · Springville, TNBuilt 1997 · S/N 56N56GH45g Aviation Services LLC · Fenton, MIBuilt 2022 · S/N 60523N56GTDonaldson Timothy A · Oklahoma City, OKBuilt 1976 · S/N AA5B-0344N56HCFaire Ken · Mojave Valley, AZBuilt 1976 · S/N 2N56HJRobinson Douglas J · Dayton, NVBuilt 1997 · S/N 24348N56HRStrachan Annmarie C · Overgaard, AZBuilt 2002 · S/N 81408N56HYCipolli Robert J · Montgomery, MABuilt 2003 · S/N 2222N56JFWadsworth Chad · Lake Havasu City, AZBuilt 1997 · S/N 53N56JSPoppy Wayne J · New London, WIFirst renewal noticeS/N 1001N56JUSurfield Ronald W · Leonardtown, MDS/N 22159N56KCCrawford William K · Ovilla, TXBuilt 2004 · S/N T018
Back to AD 90-04-06 R1