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.

N9813BTsiper Evgueni · Eagan, MNBuilt 1982 · S/N 172RG1047N9813ER&L Enterprise Group LLC · Wilmington, DEBuilt 1975 · S/N 18263919N9813HDowney Corp · Cornwall, VTS/N 18268042N9813LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276616N9813THenley Enterprises Inc · Mangonia Park, FLBuilt 1960 · S/N 47613N9813VArf Corporation · Brooklyn, NYBuilt 1974 · S/N 17264512N9814GNoble Jeremy · Stanwood, WABuilt 1977 · S/N U20603831N9814TWickizer Stephen W · Knoxville, TNBuilt 1960 · S/N 47614N9815AReese Steven A · Shoreline, WABuilt 1950 · S/N 7494N9815GKenmore Air Harbor LLC · Kenmore, WABuilt 1971 · S/N 17259715N9815HAnderson Joseph Richard · Lewiston, IDBuilt 1981 · S/N 18268044N9815LWestosha Flying Club Inc · Kenosha, WIBuilt 1986 · S/N 17276618N9815ZSilver Creek Aviation Services · Fort Worth, TXBuilt 1982 · S/N U20606678N9816EArizona Air Salvage · Phoenix, AZBuilt 1985 · S/N 18268450N9816GRicker Harry K · Turner, MEBuilt 1971 · S/N 17259716N9817GLester Matthew J · Gouldsboro, MEBuilt 1971 · S/N 17259717N9817HBurcham Timothy Scott · Encinitas, CABuilt 1981 · S/N 18268046N9817JDonahue Patrick J · Carriere, MSBuilt 1975 · S/N A1500626N98182Bena Christopher D Trustee · Wasilla, AKBuilt 1967 · S/N 18258531N98186Loyer Jeffrey W · Olympia, WAS/N 17276265N98188Usda Forest Service Fepp · Columbia, SCS/N R1720077N98189Kashmere Apartments LLC · Missouri City, TXS/N R172-0244N9818GGough Gregory · Emmett, IDBuilt 1971 · S/N 17259718N9818HFowler Raymond E · Smyrna, GABuilt 1981 · S/N 18268047N9818XPlath James F · Davenport, NDBuilt 1961 · S/N 1850018N9819HStanley Aero Club Gastonia Inc · Belmont, NCBuilt 1981 · S/N 18268048N9819JFranco Louise A · El Cerrito, CABuilt 1975 · S/N A1500628N981AKState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606248N981MARed Rose Flight Tours LLC · Lancaster, PABuilt 1978 · S/N 17271239N981RDSunrise Adventures LLC · Stillwater, MNBuilt 1981 · S/N U20605872N981SCCarter Brooks LLC · Kalispell, MTBuilt 1963 · S/N 18051339N981WBFlying Fortress Of Swfl LLC · Fort Myers, FLS/N U20606221N981WMFlying Fortress Of Swfl LLC · Fort Myers, FLS/N 21059911N98207Perkins Robert T · Anchorage, AKBuilt 1977 · S/N 18052832N9820HSeghieri Richard T · Santa Rosa, CABuilt 1981 · S/N 18268049N9820JBenair LLC · Bonita Springs, FLBuilt 1975 · S/N A1500629N9820TSamson Robert C · Waterford, WIBuilt 1960 · S/N 47620N98219White Jeffrey M · Carlsbad, CABuilt 1984 · S/N 17276266N9821CN5965t LLC · Lehigh Acres, FLFirst renewal noticeBuilt 1969 · S/N 18259988N9821ERegistered aircraftBuilt 1975 · S/N 18263921N9821GGrubelich Mark C · Edgewood, NMBuilt 1971 · S/N 17259721N9821HDowning Darrell W · Drakesville, IABuilt 1981 · S/N 18268050N9822ESample John A · Gonzales, TXBuilt 1976 · S/N 18263922N9822HPetsche Tim E · Meridian, IDBuilt 1981 · S/N 18268051N9822JSiskiyou Pacific Inc · Central Point, ORBuilt 1975 · S/N A1500631N9822VJohnson Mark W · Valrico, FLBuilt 1974 · S/N 17264515N9822XHultquist Daniel D · Anchorage, AKBuilt 1961 · S/N 185-0022N9823ADuke Kay L · Darrouzett, TXBuilt 1951 · S/N 7502N9823LSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1986 · S/N 17276623N9823VSundance Aviation Inc · Moriarty, NMBuilt 1966 · S/N 188-0073
Back to AD 87-20-03 R2