AD 87-20-03 R2

Registered aircraft · 54,015

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-20-03-R2')
    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-20-03-R2')
  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.

N9487RBoyer Air Lc · West Des Moines, IABuilt 1978 · S/N R18200710N9487UCallejo Joseph S · Port Saint Lucie, FLBuilt 1976 · S/N 15078435N9488CGalloway Christopher · Davis, CABuilt 1982 · S/N T30300180N9488GTap Solutions Inc · San Diego, CABuilt 1979 · S/N 17273629N9488MAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264771N9488UGardner Christopher · Addison, TXBuilt 1976 · S/N 15078436N94891Avcorp Holdings Inc · Jackson, MIBuilt 1983 · S/N 15285806N94897Baca Raymundo · El Paso, TXBuilt 1978 · S/N 18266530N9489TRegistered aircraftRegistration pendingBuilt 1960 · S/N 57289N9489URodriguez Alonso Jr · Alamo, TXBuilt 1976 · S/N 15078437N9489XRegistration Pending · Libby, MTRegistration pendingS/N 21057789N9489ZMoody Bible Institute Of Chicago · Spokane, WABuilt 1981 · S/N U20606525N948RRed Baron LLC · Middletown, DEBuilt 1978 · S/N 177RG1318N948SMScenic Concepts LLC · La Crosse, WIBuilt 1982 · S/N 172RG1057N94908Robert E Carroll Logging Inc · Ebony, VAS/N 18266531N9490CBell Scott Walker · Greeley, COBuilt 1955 · S/N 31888N9490DMehrer Fritz J · El Cajon, CAS/N 172RG1185N9490HNovak Rickson J · Pine City, MNBuilt 1975 · S/N 17266177N9490XStrode Farms Inc · Owensboro, KYBuilt 1985 · S/N 18268538N9490YKearins John M · North Hampton, NHBuilt 1969 · S/N 20700110N94916Milne Dave · Snohomish, WABuilt 1978 · S/N 18266534N94918Urfer Kenneth M · Sparks, NVBuilt 1978 · S/N 18266535N9491BGuess Jonathan M · Pineville, LABuilt 1958 · S/N 55291N9491CTerhune Keith B · Crosby, TXS/N 31889N9492BPack Charles · Millington, TNBuilt 1958 · S/N 55292N9492HSchodack Aviation Association · Ghent, NYBuilt 1975 · S/N 17266178N94937Kidder Robert S · Burlington, KYBuilt 1978 · S/N 18266539N94938Kalaiselvan Arunram · Richland, GAS/N 18266540N9493BRowe Chad A · Fairbanks, AKBuilt 1958 · S/N 55293N9493CBlue Thunder LLC · Ketchum, IDBuilt 1955 · S/N 31891N9493TCorwin Bert C · Rapid City, SDBuilt 1960 · S/N 57293N9493XAce Pools · Choctaw, OKS/N 18268539N9493ZCcf Ventures Inc · Bangor, MEBuilt 1981 · S/N U20606527N94940Shurley Billy R · Cabot, ARBuilt 1978 · S/N 18266541N94944Jav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 18266542N94946Van Duzer John P · Alpine, CABuilt 1978 · S/N 18266544N9494GKelly William W · Springfield, ORBuilt 1977 · S/N 15279527N9494LRegistration Pending · French Village, MORegistration pendingS/N 57294N9494NMaine Department Of Inland Fisheries And Wildlife · Augusta, MEBuilt 1981 · S/N 18504365N9494UAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078442N94959Lane Community College · Eugene, ORBuilt 1983 · S/N 15285823N9495BFry John W · Vinita, OKBuilt 1958 · S/N 55295N9495DEichholz Kenneth D · Cordova, TNBuilt 1985 · S/N 172RG1187N9495HNelson Flying Service LLC · Lansford, NDBuilt 1975 · S/N 17266180N9495XLafranchi Logan Michael · Calistoga, CABuilt 1961 · S/N 21057795N94963Twin Cities Air Service LLC · Gray, MES/N 15285825N9496CGust Dale A · Boise, IDBuilt 1955 · S/N 31894N9496HKoropp Michael L · Anchorage, AKBuilt 1977 · S/N 18503442N9496MRegistered aircraftBuilt 1970 · S/N 21059396N9496THudson Willis C · Hendersonville, NCBuilt 1960 · S/N 57296
Back to AD 87-20-03 R2