OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,019

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.

N102KYPatriot Aviation LLC · Rostraver Township, PABuilt 1978 · S/N P21000093N102LAIowa Lakes Community College · Estherville, IAS/N 17259038N102PRRico Aviation Services Inc · Miami, FLBuilt 1976 · S/N 17266462N102SJHelms Robert J · Alton, UTBuilt 1971 · S/N 17259570N102UCWest Valley Flying Club · Palo Alto, CABuilt 1980 · S/N 15284832N10300Registration Pending · Centreville, VARegistration pendingBuilt 1973 · S/N 15074832N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319N10310Solow Aviation LLC · Port Saint Lucie, FLBuilt 1973 · S/N 15074836N10312Allmann Mark F Trustee · Kent, WABuilt 1973 · S/N 15074837N1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996N1031VIntelinair Geospatial LLC · Indianapolis, INBuilt 1974 · S/N U20602409N1032DKilponen Jeffrey G · Irving, TXBuilt 1951 · S/N 7716N1032MHoyer Bryan H · Friday Harbor, WABuilt 1970 · S/N 15071732N1032VMatlock Jimmy R · Granbury, TXBuilt 1976 · S/N R1722088N1037MHager Winfield D · Peytona, WVBuilt 1970 · S/N 15071737N1037TJohnson Shem E · Bonners Ferry, IDBuilt 1972 · S/N 18260859N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989N10380Jones Jeffrey J · Wallingford, PABuilt 1973 · S/N 15074842N1039GFountain Keith E · Jacksonville, NCBuilt 1979 · S/N 21063174N103ALJordan John S · Sullivan, MOBuilt 1977 · S/N 0599N103AMN103am LLC · Chehalis, WABuilt 1974 · S/N 18502615N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923N103CTSocolosky Stephen Gerard · East Hartford, CTBuilt 1973 · S/N 17253365N103DCCarver Clarence K · Lutz, FLBuilt 1973 · S/N 15075419N103DLDunwoody Duane E D · Savage, MNS/N 55913N103FRSargent William A · Watford City, NDBuilt 1974 · S/N 15075569N103PBBentley Jeffrey W · Kenmore, WABuilt 1957 · S/N 34372N103RAArizone Game And Fish Dept · Phoenix, AZS/N U20605995N103UC426th Aero Squadron LLC · Cropwell, ALBuilt 1980 · S/N 15284243N10403Burgess Michael A · Wagener, SCS/N 15074846N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697N1040PShogren Dennis · Grand Terrace, CAS/N R18200368N1040VWilliamson Peter D · Houston, TXBuilt 1976 · S/N R1722090N10410Clark George A · Worcester, MABuilt 1975 · S/N 17702321N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484N1041MHubbard Bennett L · Piedmont, ALBuilt 1975 · S/N 18264214N1041SN1041s LLC · Key West, FLBuilt 1977 · S/N 17268658N10420Kinney Powell Mcvay · Coppell, TXBuilt 1975 · S/N 17702324N10425Moskewich Raymond J · Morgan, VTS/N 15074854N10428Stoup Kevin D · Altus, OKS/N 15074855N1042GPorter David G · Stuart, FLS/N 36704N1042SPiper Cameron · Winchester, VABuilt 1977 · S/N 172-68662N10433Sodak Angus Inc · Reva, SDBuilt 1951 · S/N 20128N10439Great Lakes Air Ventures LLC · Mason, MIBuilt 1973 · S/N 15074860N1043DDarr Dennis L · Boron, CABuilt 1951 · S/N 7655N1043FBakkes Francois · Sitka, AKBuilt 1975 · S/N 18502700N1043SAmerican Aviator LLC · Newark, DEBuilt 1977 · S/N 172-68679N10446Schell Brothers II LLC · Rehoboth Beach, DEBuilt 1973 · S/N 172-62515N1044DMcadam Charles T · Wichita, KSBuilt 1951 · S/N 7656N1044SHubbell Wallis E · Tucson, AZS/N 52829
Back to AD 87-20-03 R2