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.

N9794MYr-Aircraft Leasing LLC · Bethel, AKBuilt 1981 · S/N 20700730N9794VCooke George C IV Trustee · Richland, WABuilt 1974 · S/N 17264505N9794XLeingang Mark J · Olympia, WABuilt 1962 · S/N 21058094N97956N97956 LLC · Mesa, AZBuilt 1979 · S/N 18267253N97957Jca Aviation LLC · Wentzville, MOS/N 182-67254N97958Plate Jack R · Clarklake, MIBuilt 1979 · S/N 18267255N9795APatterson Roland O · Semmes, ALS/N 19256N9795BSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1982 · S/N 172RG1042N9795TWhite Cap Aviation LLC · Amsterdam, NYS/N 47595N9795VWilliams Bob L · Udall, KSS/N A1500565N97961Rutter Matthew J · Great Falls, MTBuilt 1979 · S/N 18267256N97963Nichols Timothy · Poulsbo, WAS/N 18267257N97968Moses Fredric P · Wayland, MABuilt 1979 · S/N 18267258N9796VKelley Aircraft LLC · Weyers Cave, VAS/N 17264506N9796XHulett George A · Woodland Hills, CABuilt 1962 · S/N 21058096N97970Mcveigh Scott M · Westlake Village, CABuilt 1979 · S/N 18267259N97971Gregory Scott L · Prescott, AZBuilt 1979 · S/N 18267260N97975Winga Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 18267262N9797GPowers Burton L · Anchorage, AKS/N 18052297N9797TBasham James L · Livingston, TXS/N 47597N9797XDeckpro LLC · Rexburg, IDBuilt 1962 · S/N 21058097N97981Grindstaff Aircraft Leasing Inc · Crossville, TNBuilt 1979 · S/N 18267266N97984Woody George R · Clinton, ARBuilt 1984 · S/N 17276244N9798ARupert Yuri · Lillian, ALFirst renewal noticeBuilt 1950 · S/N 19259N9798GJantz Merle Trustee · North Pole, AKBuilt 1972 · S/N 18052298N9798TRegistered aircraftBuilt 1960 · S/N 47598N9798ZWright Air Service Inc · Fairbanks, AKBuilt 1982 · S/N U20606665N97993N97993 LLC · Middleton, MABuilt 1979 · S/N 18267272N97995Lxs Farms LLC · El Paso, TXBuilt 1979 · S/N 18267273N97997Redline Aviation Inc · Sioux City, IABuilt 1979 · S/N 18267275N9799ESkyhigh Trade LLC · Wilmington, DEBuilt 1984 · S/N 18268447N9799HFriehe Berend · Moses Lake, WABuilt 1981 · S/N 18268033N9799TDeapen Jordan Derek · Clifton, TXBuilt 1960 · S/N 47599N979JFGoodspeed Air Service LLC · Oxford, CTBuilt 1966 · S/N 17254071N979PTCappe Ivestment Group LLC · Homestead, FLBuilt 1974 · S/N 17264503N97AVCertified Aviation LLC · Dawson, GAS/N 18266809N97BSSidewinder Services LLC · Genoa, NVBuilt 1973 · S/N 17262475N97DSWmg Aviation LLC · Ketchum, IDS/N 18504173N97EKern County Sheriffs Department · Bakersfield, CABuilt 1983 · S/N 21064788N97FAJalbert John E · Greenville, MEBuilt 1982 · S/N 18504373N97FCParker Cullen B · San Antonio, TXBuilt 1962 · S/N 18051106N97FRSmith Ralph E · Lyndonville, NYBuilt 1980 · S/N 17274188N97JBVieira Nunes Da Silva Raphael · Ethel, LABuilt 1966 · S/N 17255305N97JWDorn Albert William II Trustee · Tucson, AZBuilt 1978 · S/N R18200652N97MWRudderworks Aviation LLC · Fairfax Station, VABuilt 1975 · S/N 17264946N9800AB T Aircraft Restorations · Bellevue, WABuilt 1950 · S/N 7557N9800JButts James Allen · Gainesville, GABuilt 1975 · S/N A1500609N9800THerr Garrick D · Wasilla, AKBuilt 1960 · S/N 47600N9801ASpivey Kenneth R Jr · Vestavia, ALBuilt 1950 · S/N 7480N9801GTriad Aviation Academy LLC · Greensboro, NCS/N 17259701
Back to AD 87-20-03 R2