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.

N76KFRegistration Pending · Grenada, MSRegistration pendingBuilt 1974 · S/N 153-74N76KRSorensen Bjarne K · Vero Beach, FLBuilt 1983 · S/N 353N76KSSchroepfer Ken J · Pecatonica, ILBuilt 2007 · S/N 70229N76LThacker Flying Club LLC · Griffin, GAS/N DH-183N76LCHacienda Hills Skyhawk LLC · Laveen, AZBuilt 1977 · S/N 17268925N76LMPavlovich Martin · Menomonee Falls, WIS/N 22604N76LNHillsboro Aero Academy LLC · Hillsboro, ORS/N 957N76LYYonge Laurie W Jr · Oklawaha, FLBuilt 1964 · S/N 302N76MKMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME186N76MLDunn Courtland E Jr · West Grove, PABuilt 1974 · S/N 446-74N76MMRichardson John H · Monticello, NMBuilt 1957 · S/N 18-6031N76MXAzdair Jamie A · Alhambra, CAS/N 1N76NATri Flying Tigers Inc · Wilmington, DEBuilt 1960 · S/N 23-1909N76NCDonald K Ashley · Bradenton, FLBuilt 1976 · S/N M-1787N76NKNaples Jet Management LLC · Naples, FLS/N ME-334N76NNSale Reported · Middletown, OHSale reported, canceledBuilt 1979 · S/N ME-158N76NPCollins Shannan S · Justin, TXS/N SA-300-726N76PFRodriguez Amable Omar · Hialeah, FLBuilt 1982 · S/N 28-8216151N76PPGround Effect Aviation LLC · Ogden, UTBuilt 2007 · S/N 494-2007N76PQBoyd Benjamin L · Kila, MTBuilt 1976 · S/N 18-7609130N76PTMcmurtrey Michael · Farmington, MNBuilt 1974 · S/N MC228N76RSCocke James A · Clarendon, TXBuilt 1976 · S/N 683-HN76RTEmax LLC · Perry, GABuilt 1970 · S/N LB-27N76RVVandevort Lynn A · Manitowoc, WIBuilt 1999 · S/N 23420N76RWThomas Allen C · Willow, AKBuilt 1953 · S/N 18-1886N76SBAdams Simmie A · Bealeton, VABuilt 1975 · S/N M-1776N76SHConrad Edgar · Mc Alpin, FLBuilt 1995 · S/N 22886N76SLLarsh Steven S · Libby, MTBuilt 2004 · S/N 1001N76SSNorth Texas Aeronautics LLC · Burleson, TXS/N 17263711N76TAAhlhorn Travis W · New Braunfels, TXS/N 17276025N76TCCox Thomas R · Kirkland, WABuilt 2001 · S/N 80500N76TJBais Tim · Escondido, CABuilt 1994 · S/N 21675N76TXBrenner Kurt · Saint Ann, MOBuilt 1976 · S/N 28-7625102N76VAHartzell Propeller Emp Flg Club · Piqua, OHBuilt 1976 · S/N M-1786N76VMSwartz Aviation Group LLC · Argyle, TXBuilt 2010 · S/N 82155N76WEEnglert William R · Advance, NCBuilt 2010 · S/N 2667N76WLBuckel Joseph T · Ellison Bay, WIBuilt 1976 · S/N VAC-57-76N76WNCorben David Meyer · Lafayette, INBuilt 1978 · S/N 433HN76WPHowes Robert P · Belleview, FLFirst renewal noticeS/N AA5A-0090N76WWOakley James H · Spring Valley, CABuilt 1976 · S/N 18-7609114N76WYFarmer Bill · Argyle, TXBuilt 2013 · S/N 3186N76XGreen Steven L · Fairbanks, AKBuilt 1948 · S/N 12-4036N76YHose Jerry A II · Oregon, ILBuilt 1985 · S/N 71N76YBJames Marvin L · Scio, ORBuilt 1976 · S/N 8056N76YDBeasley Charles A · Spencer, VABuilt 1975 · S/N 199-75N7700MWood Duck Loop LLC · Mooresville, NCBuilt 1967 · S/N 670118N7700WGleasman Steven J · Rockton, ILBuilt 1964 · S/N 28-1692N7701AEdb Air Inc · Wilsonville, ORBuilt 2001 · S/N 4496089N7701DChrysler Sheldon A · Pueblo, COFirst renewal noticeS/N 22-5372N7701HRenshaw Raymond E · Huntersville, NCBuilt 1946 · S/N 12-592
Back to AD 90-04-06 R1