OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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:87-10-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:87-10-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.

N48MGarrison William E · Nickerson, KSBuilt 1996 · S/N BA-155N48MBCaddell Charles Thomas · Wadesboro, NCBuilt 2000 · S/N 60059N48MMDierks Herman D · Round Rock, TXBuilt 1967 · S/N RCM67N48NGSterling Air Inc · Little Rock, ARBuilt 1951 · S/N WD365N48PKWoodward Daniel S · Springville, UTS/N 5382N48PRBadrow Allan R · Warrenton, VABuilt 2002 · S/N 2843533N48RDMiller Montgomery A · Carmel, INBuilt 1982 · S/N 1N48RPClark Mitchell J · Parker, COBuilt 1978 · S/N 658-HN48SSiragusa Pamela L · Cypress, TXBuilt 1958 · S/N TD-40N48SJJohnston Stephen P · Hawley, MNBuilt 1948 · S/N 1466N48TDFoster Aviation LLC · Missoula, MTBuilt 1997 · S/N 123297N48TNWest Thomas L · Payson, AZBuilt 1975 · S/N 60-0214-094N48VZPrecision Jet Service Inc · Stuart, FLBuilt 1973 · S/N 32-7300044N48WLAtkinson Matthew D · Theodore, ALBuilt 1978 · S/N AA5B0892N48YKimble Robert · Marco Island, FLBuilt 1981 · S/N 27-8154022N4900CRider Bradley H · Juneau, AKBuilt 2013 · S/N AI-18062N4900JUniversal Technical Institute Inc · Avondale, AZBuilt 1968 · S/N 28R-30617N4900URegistration Pending · Rockville, MDRegistration pendingBuilt 2005 · S/N 2842240N4902FFlying Vikings Inc · Hayward, CABuilt 1979 · S/N 17273099N4902LObrien William M · Aptos, CABuilt 1967 · S/N 28-4269N4902SBbsa Flight LLC · Tucson, AZBuilt 1979 · S/N R18201442N4903LPlane Crazy Aviation LLC · Hollywood, SCBuilt 1967 · S/N 28-4270N4904GC & W Aviation LLC · Trumbull, CTBuilt 1979 · S/N 17273451N4904JLunken Air Group LLC · Cincinnati, OHS/N 28R-30622N4904LSchmick David D · Sturgis, MIBuilt 1967 · S/N 28-4271N4904PCivil Air Support LLC · Phoenix, AZBuilt 1961 · S/N 27-495N4904SO Neil Mark F · Suffolk, VABuilt 1979 · S/N R18201444N4905JMoore Albert III · Las Vegas, NVBuilt 1968 · S/N 28R-30623N4906JSeal Air LLC · San Juan Capo, CABuilt 1968 · S/N 28R-30624N4906LRitter Steven L · Harlingen, TXBuilt 1967 · S/N 28-4274N4906SSweeney Peter Allan · Irvine, CABuilt 1979 · S/N R18201446N4906TSmith Bruce · Leonardtown, MDBuilt 1972 · S/N 28R-7235158N4907JHarmon Neil A · North Chelmsford, MABuilt 1968 · S/N 28R-30625N4907LSmooth Landin Inc · Melville, NYBuilt 1967 · S/N 28-4222N4907PTabor Conor C · Littleton, COBuilt 1961 · S/N 27-498N4907TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250184N4907ZChristie Ian A H · Limon, COS/N 22-8492N4908JHolm R Stan · College Place, WABuilt 1968 · S/N 28R-30626N4908PJohnson Dalton S · Sterling, AKBuilt 1962 · S/N 18-7789N4909GRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1979 · S/N 17273456N4909SRice Philip V · Sublette, KSBuilt 1970 · S/N 28R-35681N490AFEiffert Matthew T · Ukiah, CABuilt 1970 · S/N 17701493N490BYancey Patrick D · Spirit Lake, IDS/N 1994N490DLWhidden William L · Lake Wales, FLBuilt 2012 · S/N 232N490GRWarnock Tony J · Mobile, ALS/N 97N490LLAntel Av Corp · Lewes, DEBuilt 2004 · S/N 18281432N490RRegistered aircraftBuilt 1999 · S/N 490RN490RVSmith William R · Seneca, PABuilt 2008 · S/N 20090N490SPSky Training LLC · West Milford, NJBuilt 1998 · S/N 172S8031N49105Carlyle Properties LLC · Columbia Falls, MTS/N 203
Back to AD 87-10-06 R1