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.

N64575N64575 LLC · Cheyenne, WYBuilt 1982 · S/N 17275585N6457DTristar Aviation Services LLC · Hendersonville, TNBuilt 1979 · S/N 17272809N6457JHatcher Clifford J · Dallas, GABuilt 1968 · S/N 28-4878N6457QRegistered aircraftBuilt 1967 · S/N 670536N6457WWeston Keith M · Ogdensburg, NYBuilt 1964 · S/N 28-20530N64585Lay Lawrence W · Douglass, KSBuilt 1977 · S/N 7-0311N6458JFlorida Tectonics Inc · Weirsdale, FLBuilt 1968 · S/N 28-4880N6458LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284400N6458VWilson David P · Lumberton, TXBuilt 1980 · S/N 172RG0714N6458WJones Larry · Clovis, NMBuilt 1965 · S/N 28-20531N6459RLogical Drive Inc · Siler City, NCBuilt 1966 · S/N 28-21645N6459ULinck Market Inc · Little Rock, ARBuilt 1962 · S/N 2205N6459WBillingsley Littleton C Jr · Spicewood, TXBuilt 1964 · S/N 28-20532N645AWHobart Aviation Inc · Akron, OHBuilt 1981 · S/N 28-8116305N645DBBailey Dennis L · Oakdale, CABuilt 2004 · S/N 24345N645DDAmes Donald L Trustee · Park City, UTBuilt 2010 · S/N 81775N645DTScenic Mountain Air Inc · Moose Pass, AKBuilt 1982 · S/N 18-8309022N645EJFogelin Eric S · Shasta, CABuilt 2008 · S/N 645EN645FLRule Charles Y · Mineral Point, WIBuilt 1971 · S/N 28-7125553N645FTFlorida Institute Of Technology · Melbourne, FLBuilt 2013 · S/N 2843705N645HChileprop LLC · Mimbres, NMBuilt 1929 · S/N 1220N645KNoyes Jeffery A · Bridgeport, TXS/N 75-5080N645KAHelocraft Holding Co Inc · Pembroke Pines, FLBuilt 2009 · S/N S1931N645LCJohnston Laura S · Seattle, WABuilt 2003 · S/N 263N645NDUniversity Of North Dakota · Grand Forks, NDBuilt 2019 · S/N 2881146N645RD&S Development LLC · Spring, TXBuilt 1964 · S/N 30-240N645RDVeterinary Surgical Supply (Vss) LLC · Kalispell, MTBuilt 2009 · S/N 90541N645RFHagge Hal E · Eagle River, AKBuilt 1968 · S/N 18-8711N645SStewart Dennis M · Fernley, NVBuilt 2015 · S/N 72943N645SAGerrish Ronald M · San Antonio, TXBuilt 2005 · S/N S-0007N645SDDacy Julia A · Harvard, ILBuilt 1964 · S/N 30-524N645SPRegistration Pending · Bennett, CORegistration pendingBuilt 1998 · S/N 172S8052N64608A S Air LLC · Lantana, FLS/N 17275592N6460DVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1947 · S/N 19640N6460LRichmor Aviation Inc · Scotia, NYBuilt 1980 · S/N 15284401N6460MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284742N6460QDel Gado Raul L · Victorville, CABuilt 1967 · S/N 670539N6460UHayes Toby G · Idaho Falls, IDBuilt 1962 · S/N 2206N64611Great North Air LLC · Shelburne, NHBuilt 1982 · S/N 17275593N64617Melbourne Flight Training LLC · Melbourne, FLBuilt 1982 · S/N 17275594N6461CTripacer Strategic Consulting LLC · Dover, DES/N 28-7816425N6461QGanos Christ · Brookfield, WIBuilt 1967 · S/N 680003N6461RBetsy N6461r LLC · Novato, CABuilt 1966 · S/N 28-21648N6461VRegistered aircraftBuilt 1980 · S/N 172RG0716N6461WOverstreet Aviation LLC · Sunray, TXBuilt 1964 · S/N 28-20534N6462CA&J Aircraft Leasing Inc · Burlington, COBuilt 1978 · S/N 28-7816426N6462DN2893e LLC · Reno, NVBuilt 1979 · S/N 17272813N6462JRentz Bradford C · Baxley, GABuilt 1968 · S/N 28-4885N6462QPlummer Joshua · Fort Mill, SCBuilt 1967 · S/N 680004N6462RGoodens Floorcovering Inc · Tallapoosa, GABuilt 1966 · S/N 28-21650
Back to AD 90-04-06 R1