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.

N1998ZMilhous Richard J · Aguila, AZS/N 15059798N19992United Manufacturing Inc · Holland, MIBuilt 1972 · S/N 17260917N19996Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260919N19997Neel Aviation LLC · Lakeland, FLBuilt 1972 · S/N 17260920N1999CArnzen Shawn P · Anchorage, AKBuilt 1953 · S/N 26039N1999MSoltis Andrew · Salem, OHFirst renewal noticeBuilt 1976 · S/N 18264528N1999QGentry Harry J · Canton, OHBuilt 1973 · S/N 177RG0399N1999UKarr Brandon · Everett, WABuilt 1970 · S/N 18501768N1999XThompson Justin · Duncan Falls, OHBuilt 1965 · S/N 18256099N199ARBarr Air Patrol LLC · Mesquite, TXBuilt 1981 · S/N 17274778N199GFogelson Robert A · Benton City, WABuilt 1959 · S/N 52233N199LPAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 17264143N199MCFly N199mc LLC · Nevada City, CABuilt 1977 · S/N 17268570N199NLees Larry J · Pryor, OKBuilt 1986 · S/N 18268548N199PDCity Of Sacramento · Sacramento, CABuilt 1979 · S/N R1723127N199RFBravo Charlie Global LLC · Kalispell, MTBuilt 1979 · S/N 18266816N199RNWestern Flying Club Inc · Burlington, NCBuilt 1977 · S/N 18266079N199TKDangel LLC · Hailey, IDBuilt 1979 · S/N P21000313N199YCKruse Adam L · Weiser, IDBuilt 1976 · S/N 18258424N19AJBayshore Aircraft LLC · Miami, FLBuilt 1979 · S/N 18267286N19DEchelon Right LLC · Nicholasville, KYBuilt 1980 · S/N 18504097N19ECSerra Decca Company LLC · Seattle, WABuilt 1967 · S/N 185-1306N19EZAir Mobile Ministries · Sneedville, TNBuilt 1970 · S/N 33701315N19FABrown Brian T · Wilton, CABuilt 1961 · S/N 18253809N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668N19GCarlton Steve W · Lewiston, IDBuilt 1963 · S/N 18254596N19GCKobaly Jason D · Yucca Valley, CABuilt 1972 · S/N 18261280N19HRJernigan Michael G · Toledo, ORBuilt 1966 · S/N 17255607N19JGImmeyer Daniel O · Redmond, WABuilt 1958 · S/N 55131N19JKA P Air LLC · Wilmington, NCBuilt 1973 · S/N 17701867N19JRKyle Agne · Greensboro, NCBuilt 1973 · S/N 177RG-0314N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705N19LVLeon Ruben D · Oviedo, FLBuilt 1972 · S/N P3370012N19MJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N U20605372N19MUGarrett Jack H · Grandview, TXS/N 177RG0099N19NJN19nj LLC · Manassas, VABuilt 1985 · S/N 17276343N19PLively Gregory · Corinth, TXBuilt 1969 · S/N 337-1091N19PFTac'S Enterprise LLC · Ballston Lake, NYBuilt 1972 · S/N 17701711N19SBMcginnis Randall E · Redding, CABuilt 1972 · S/N P3370018N19TAFun Flyers LLC · Salem, ORBuilt 1973 · S/N 17701912N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629N19TWDougherty Peter I · Orchard Park, NYBuilt 1953 · S/N 30119N19WBPacific Wildfire Enterprises LLC · Wilmington, DES/N P21000761N19WSHolcomb Nicholas A · Yakutat, AKS/N 29689N19ZBBruton Kevin L · Roseburg, ORBuilt 1959 · S/N 55732N1AXEdgerton Agency Inc · Galena, OHBuilt 1960 · S/N 47418N1BPPatton Ministries · Grand Rapids, MNBuilt 1961 · S/N 18253260N1CTTre Aviation Corp · Queen Creek, AZBuilt 1972 · S/N P3370001N1CZWarden Richard L · Canby, ORBuilt 1950 · S/N 7481N1DZXtreme Flying Services LLC · Gansevoort, NYBuilt 1961 · S/N 18253742
Back to AD 87-20-03 R2