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.

N7771WWhitman Edward G · River Falls, WIBuilt 1964 · S/N 28-1773N7771YDakota Executive Flight Inc · Miller, SDBuilt 1965 · S/N 30-857N7772CCummings David P · Grayson, LABuilt 1975 · S/N 28-7625084N7772DWilliams Stephen M · Fort Walton Beach, FLBuilt 1957 · S/N 18-5958N7772GWings Over Texas Holdings LLC · Denton, TXBuilt 1970 · S/N 17259472N7772NZmq Aviation LLC · Minneapolis, MNBuilt 1968 · S/N 28-5219N7773NDmac Aircraft LLC · Savannah, GABuilt 1968 · S/N 28-5221N7773WVida Kenneth J · Harrison Township, MIBuilt 1964 · S/N 28-1776N7773YBismuth Robert · Seattle, WABuilt 1965 · S/N 30-859N7774CTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1973 · S/N 0093N7774DPosson John L Trustee · Petaluma, CABuilt 1957 · S/N 18-5957N7774GElliott Miles · Porterville, CABuilt 1970 · S/N 17259474N7774NRai Jeff · Nazareth, PABuilt 1968 · S/N 28-5222N7774TPanjab Aviation · Las Vegas, NVBuilt 1979 · S/N ME-191N7774WSanto Chanselor L · Pasco, WABuilt 2008 · S/N 115MN7774YReed John · Seattle, WABuilt 1965 · S/N 30-860N7775ACarbon Cub 5x LLC · Sun Valley, IDBuilt 2025 · S/N CCK-2000-0112N7775CValpey R Wesley Jr · Medford, MEBuilt 1964 · S/N 21N7775GMondragon Vidahk D · Reseda, CAFirst renewal noticeBuilt 1970 · S/N 17259475N7775HDunshee Kevin G · Laluz, NMBuilt 1946 · S/N 12-673N7775MDennis Bruce · Rapid City, MIBuilt 1974 · S/N 20-0021N7775NHarris Mark · Greenville, SCBuilt 1968 · S/N 28-5223N7775SWildes Thomas · Chippewa Falls, WIBuilt 1976 · S/N 227-76N7776DSecond Delaware Corp · Moorestown, NJBuilt 1957 · S/N 18-5961N7776GGulf Atlantic Airways Inc · Gainesville, FLBuilt 1970 · S/N 17259476N7776MPinckney Robert L · Elgin, SCFirst renewal noticeBuilt 1974 · S/N 21-0032N7776NSkylark Flight Training LLC · Wilmington, DEBuilt 1968 · S/N 28-5224N7776PHardin Gerald A · Port Clinton, OHFirst renewal noticeBuilt 1962 · S/N 24-2993N7776ZThatcher William Scott · Eau Claire, WIBuilt 1966 · S/N 18-8483N7777CSouthern Sky LLC · Henderson, NVBuilt 1976 · S/N 17267334N7777DMorris Blain E · Delta Junction, AKBuilt 1954 · S/N 18-5962N7777HSale Reported · Jennings, LASale reportedBuilt 1946 · S/N 12-709N7777KMoss Conrad C · South Pittsburg, TNBuilt 1950 · S/N 22-2N7777PWeihe Philip D · Cleveland Heights, OHBuilt 1961 · S/N 24-2994N7777WAmmon Roadable Aircraft LLC · Manchester, NHBuilt 1964 · S/N 28-1781N7777YDigati Anthony J · Mentone, CAS/N 30-863N7778Carpenter Darrell W · Midland City, ALBuilt 1973 · S/N 177RG0349N7778BPeters Ben C · Leavenworth, WAS/N 2750N7778NAsari Investments LLC · Knoxville, TNBuilt 1968 · S/N 28-5225N7778YSpiegel Eitan · San Francisco, CABuilt 1965 · S/N 30-864N7779CDicey Aviation LLC · Somerset, KYBuilt 1975 · S/N 28-7615063N7779DEssman Kenneth R · Burlington, WIS/N 18-5964N7779HRenfro Jacqueline L · Bethel, AKBuilt 1946 · S/N 12-677N7779JLehrkamp Mike C · Caputa, SDBuilt 1966 · S/N 536N7779NPhyxsius Aviation LLC · El Paso, TXBuilt 1968 · S/N 28-5226N7779WHolowatsch Sergio O · Archer, FLBuilt 1964 · S/N 28-1785N7779YMccool Kenneth W · Olive Branch, MSBuilt 1965 · S/N 30-865N777AHJarhead Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 17261695N777CCJohnston Steven M · Lyle, WABuilt 1984 · S/N S-300-CC-1N777CRRhodes Curt W · Reno, NVBuilt 1973 · S/N 2044
Back to AD 90-04-06 R1