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.

N94328Gottschalk John R · Atwater, CABuilt 1978 · S/N 18266410N9432CTexas Co Title Inc · Kalispell, MTS/N 31830N9432DRegistered aircraftBuilt 1984 · S/N 172RG1160N9432MRound Table Aviation LLC · Munster, INFirst renewal noticeBuilt 1970 · S/N 21059332N94334Play For Today LLC · Michigan City, INBuilt 1978 · S/N 18266412N94338Auto Action LLC · Peralta, NMBuilt 1978 · S/N 18266415N9433EKozma Peter · San Diego, CABuilt 1979 · S/N 17272264N9433LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276556N9433MDels Inc · Mountain Home, ARBuilt 1970 · S/N 21059333N9433TDoyle Victoria L · Salem, ORBuilt 1960 · S/N 57233N9433XVorlander Daniel S · Mount Pleasant, SCBuilt 1985 · S/N 18268525N9434594345 LLC · Ashaway, RIBuilt 1978 · S/N 18266417N9434BNamtvedt Erik · Wasilla, AKS/N 55234N9434NAnderson Thomas R · Renton, WABuilt 1981 · S/N 18504355N9434TChurch Philip M · Statesville, NCBuilt 1960 · S/N 57234N94359Jbm Enterprises LLC · Bristol, RIS/N 18266419N9435BPalladino Michael A · Pinehurst, NCFirst renewal noticeBuilt 1981 · S/N 172RG0821N9435CBackcountry Adventures LLC · Big Lake, AKBuilt 1955 · S/N 31833N9435MEngelhardt Angelo Lomeli · Spring, TXBuilt 1976 · S/N 18264754N9436BWhitsell Jesse T · Sterling, CTBuilt 1958 · S/N 55236N9436MIkg Air LLC · Page, AZBuilt 1981 · S/N 20700689N94371Coppage Farm Services Inc · Braggadocio, MOBuilt 1978 · S/N 18266421N9437DRichmor Aviation Inc · Scotia, NYBuilt 1984 · S/N 172RG1161N9437UAom Aircraft LLC · Wilmington, DES/N 15078385N9438CKrupinski Floyd M · Chugiak, AKBuilt 1955 · S/N 31836N9438HBering Capital LLC · Anchorage, AKS/N 17266155N9438MIdaho Transportation Department · Boise, IDBuilt 1978 · S/N U20604546N9438NSallmon James Henry · Sandpoint, IDBuilt 1981 · S/N 18504356N9438TBray Max W Jr · Dora, ALBuilt 1960 · S/N 57238N94391Gall Michael R · Breckenridge, COBuilt 1978 · S/N 18266423N94397Koenitzer Judson B · Chetek, WIBuilt 1982 · S/N 15285662N9439BAv Dak Inc · Crystal, NDBuilt 1981 · S/N 172RG0822N9439CYellowstone Overflight Inc · Belgrade, MTBuilt 1955 · S/N 31837N9439ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1979 · S/N 17272265N9439URautiola Patricia H · Rosemount, MNS/N 15078387N9439XBallard Richard D · Juneau, AKBuilt 1961 · S/N 21057739N9439YR C S Drilling Company Inc · West Lake Hills, TXBuilt 1981 · S/N 21064505N943AHHaley Keith · Tonawanda, NYBuilt 1981 · S/N 21064377N943KSStark James E Trustee · Sun City, AZBuilt 1978 · S/N 17270273N943SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15279675N94400Macinnis James Michael · Copley, OHBuilt 1982 · S/N 15285663N94401Maui Aviators LLC · Pukalani, HIBuilt 1982 · S/N 15285664N9440BRamos Daniel J · Pueblo, COS/N 55240N9440USmith Peter I Trustee · Ocala, FLS/N 15078388N9440XMountain Flyers Inc · Asheville, NCBuilt 1985 · S/N 18268527N9441BSmith Mickey D · Tyler, TXBuilt 1958 · S/N 55241N9441MGuemes Aloft LLC · Portland, ORS/N 18264759N9441TDevil Dusters Inc · Artesia, NMBuilt 1960 · S/N 57241N9441ULewis Paul A · Spring, TXBuilt 1976 · S/N 15078389N9441XMurphy Peter D · Santa Fe, NMBuilt 1961 · S/N 21057741
Back to AD 87-20-03 R2