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.

N74561George James H · Punta Gorda, FLBuilt 1976 · S/N AA5B-0252N74562Hamm Donald S · Carrollton, TXFirst renewal noticeS/N 1873N74564November Alpha LLC · Dover, DEBuilt 2005 · S/N 3908N74565Shai Evan · Oak Bluffs, MABuilt 1961 · S/N 1876N74566Kerns Stanley M · Berryville, VABuilt 1961 · S/N 1877N74568Willis Charles D · Katy, TXBuilt 1961 · S/N 1879N7456GGregory Larry C Trustee · Farmington, MOS/N 129N7456JSchwier Ronald G Jr · Bloomfield, NJBuilt 1968 · S/N 28R-30954N74571Mccurry Richard H · El Dorado, CABuilt 1961 · S/N 1882N74573Strout Adam Geoffrey · Manchester, MABuilt 1961 · S/N 1884N74574Burrell Helicopters LLC · D Hanis, TXBuilt 2005 · S/N 3913N74576Varnes Mark R · Westminster, CAS/N 1887N74579Bethell A Ray · Heavener, OKFirst renewal noticeBuilt 1961 · S/N 1890N7457JMoretti Stephen B · Cranston, RIBuilt 1968 · S/N 28R-30808N7457LPiper Lover LLC · Centennial, COBuilt 1975 · S/N 18-7509051N7457RFoster Adam W · Midland, TXBuilt 1966 · S/N 28-22002N7457WNilsson Tim E · Yreka, CABuilt 1963 · S/N 28-1346N7457YPeter Prince Aviation Center LLC · Milton, FLBuilt 1964 · S/N 30-520N74581Lane Tyler R · Berthoud, COS/N 1892N74582Moo Nee LLC · Vero Beach, FLBuilt 1962 · S/N 1893N74583Mile High Carpet Rides LLC · Dover, DEBuilt 2005 · S/N 3923N74586Rainwater Farms LLC · Dover, DES/N 1897N74587Curtis David W · Watertown, NYBuilt 1961 · S/N 1898N7458DWheeler Evan L · North Pole, AKBuilt 2019 · S/N 001N7458JReeves Stephen · Watford City, NDBuilt 1968 · S/N 28R-30810N7458KMy Piper Pacer LLC · Everett, WABuilt 1950 · S/N 20-370N7458WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1963 · S/N 28-1347N74590Registration Pending · Barry, TXRegistration pendingBuilt 1976 · S/N AA5B-0253N74591Tiger Aero LLC · Beresford, SDBuilt 1976 · S/N AA5B-0254N74592Higgs III Cyrus H · Jackson, TNBuilt 1976 · S/N AA5B-0255N74593Sandlin Jesse L · Chesterfield, VABuilt 1976 · S/N AA5B-0257N74594Pinger Kevin R · Palo Alto, CAS/N AA5B-0260N74595Ehrhard Robert A · Jasper, INBuilt 1976 · S/N AA5B-0263N74596Cato James W · Las Cruces, NMS/N AA5B-0264N74597Airman Helicopter Inc · Fort Lauderdale, FLBuilt 2005 · S/N 3927N74599Fletchair Inc · Comfort, TXBuilt 1976 · S/N AA5B-0267N7459JEvans Charles Dewayne · Cumby, TXBuilt 1968 · S/N 28R-30811N7459LStewart Martin J · Anchorage, AKBuilt 1975 · S/N 18-7509054N745CWKnight Verl D · Caldwell, IDBuilt 1988 · S/N 699N745FWWalther Frank C · Crawford, COBuilt 1980 · S/N 15283905N745GCHill Jack C · Arnold, MOBuilt 2023 · S/N 8-4263N745LMMurley Stephen L · Boerne, TXBuilt 2015 · S/N 70346N745LSWeaver Chris D · Hallam, NEBuilt 1974 · S/N 291-74N745MSSchamel Michael A · Salem, INS/N 126-74N745NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843860N745PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881017N745RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1990 · S/N 2841327N745SPBanks Douglas Trent III · Huntsville, ALBuilt 2000 · S/N 172S8677N745TWTumbleweed Leasing Co Inc · Salt Lake City, UTS/N 17269624N745ZZin Services LLC · Dover, DES/N 17280513
Back to AD 90-04-06 R1