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.

N88EStarlite Aviation Technologies LLC · Las Vegas, NVBuilt 1973 · S/N 17261476N88GMField Drew H · Dallas, TXBuilt 1972 · S/N 150-73318N88HQAviation Capital Management LLC · San Jose, CABuilt 1973 · S/N 18262714N88HSShields Edwin G · York, SCBuilt 1968 · S/N 15069271N88JDRichardson H L · Reform, ALBuilt 1978 · S/N 18266643N88KMTsukii Toshikazu · Tucson, AZBuilt 1977 · S/N 177RG1181N88KNRegistration Pending · Santa Rosa, CARegistration pendingBuilt 1966 · S/N 15065181N88KWDonnell James C · Crowville, LABuilt 1966 · S/N 17254367N88MALowry Michael L · Chesterton, INBuilt 1957 · S/N 34691N88MLProstar Flight Services LLC · Bozeman, MTBuilt 1979 · S/N 18267701N88NGBakke Dale W · Yankton, SDBuilt 1977 · S/N 177RG1223N88PBBraswell Jerrold W · Dillingham, AKS/N 207-00498N88PKGray Farms Inc · Albany, ORBuilt 1971 · S/N 18260772N88RBWarner David J · Englewood, OHBuilt 1972 · S/N 18261282N88RKJkg LLC · Idaho Falls, IDBuilt 1966 · S/N 18256967N88SYYamashita Bruce · Honolulu, HIBuilt 1969 · S/N 17258613N88TNErwa Mohamed · Lago Vista, TXBuilt 1979 · S/N P3370341N88YWCharlston Michael M · Haleiwa, HIS/N 15283335N8900BMathews Denis W · Quanah, TXBuilt 1958 · S/N 36700N8900TSkyote LLC · Boise, IDBuilt 1960 · S/N 52800N8901BThompson Douglas P Trustee · Alton Bay, NHBuilt 1958 · S/N 36701N8901XHilde Justin · Statesboro, GABuilt 1961 · S/N 18253301N89021Tevik Michael A · Provo, UTBuilt 1978 · S/N 15282598N8902BLeonard William L · Gettysburg, PABuilt 1958 · S/N 36702N8902TShort Steven A · Neillsville, WIBuilt 1960 · S/N 52802N8902VFlycarolina LLC · Concord, NCS/N 17264259N89038Gross Matthew D · Saint Paul, MNFirst renewal noticeBuilt 1978 · S/N 15282606N8903XGreene Bruce · Asheville, NCBuilt 1961 · S/N 18253303N8904VWaymaker Aviation LLC · Yukon, OKBuilt 1974 · S/N 17264261N8904XPlanes Of Fame Air Museum · Chino, CABuilt 1961 · S/N 18253304N89054Stcup 152 LLC · Chicago, ILBuilt 1978 · S/N 15282611N89055Hageman George · Pebble Beach, CABuilt 1978 · S/N 15282612N8905BGamble Dennis H · Cottonwood, ALBuilt 1958 · S/N 36705N8906SHoskins Brent E · Caldwell, IDBuilt 1965 · S/N 15062206N8906TTln Aviation LLC · Stanwood, WABuilt 1960 · S/N 52806N8906VLewis David A · Broadalbin, NYBuilt 1974 · S/N 17264263N89071Pavco Inc · Gig Harbor, WABuilt 1978 · S/N 15282617N89073O Reilly Thomas P · Oscoda, MIBuilt 1978 · S/N 15282618N8907BRaven Aviation LLC · Lexington, KYBuilt 1958 · S/N 36707N8907GInfinity Aviation · Pine Island, MNBuilt 1970 · S/N 18260447N8907QBurks Excavation Corp · Hailey, IDBuilt 1976 · S/N U20603562N8907VSmith Melvin Roy · Gulf Breeze, FLBuilt 1977 · S/N R1722323N8907XFrey Harlan Jerome · Carey, OHBuilt 1961 · S/N 18253307N8908BAxmacher Mark A · Hillsboro, OHBuilt 1958 · S/N 36708N8908TWinit Matthew C · Woodland, WABuilt 1960 · S/N 52808N89090Huggins Elissa D · El Paso, TXBuilt 1978 · S/N 15282626N89098Dobbelaere Craig · Oakwood, OHBuilt 1978 · S/N 15282630N8909TFinley Steven V · Fort Collins, COBuilt 1960 · S/N 52809N8909XHubbert Stephen B · Owasso, OKBuilt 1961 · S/N 18253309N890PGCp Air LLC · Indianapolis, INBuilt 1965 · S/N 17253864
Back to AD 87-20-03 R2