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.

N97159Quetzal Aviation Corp · Washington, DCBuilt 1979 · S/N 18266999N9715AGarry L Lewis · Livingston, LABuilt 1949 · S/N 19176N9715GMonfore Mark A · Wasilla, AKS/N 18052215N97160Foster Mark C Trustee · Carson City, NVBuilt 1979 · S/N 18267000N97163Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276161N9716BSelkirk Associates Inc · Wilmington, DEBuilt 1957 · S/N 50014N9716XLowe Joshua T · Mount Baldy, CAS/N 21058016N97170Connor Catherine E · Morgantown, WVBuilt 1979 · S/N 18267002N97172C P Aviation · Santa Paula, CABuilt 1984 · S/N 17276162N97178Meador Rita R · Eldorado, TXS/N 18267006N9717BCeruto Jorge · Auburndale, FLBuilt 1981 · S/N 172RG0987N9717GBurley Mark A · North Pole, AKBuilt 1971 · S/N 18052217N9717HBullock Linda A · Shawnee, KSFirst renewal noticeBuilt 1975 · S/N 17266331N9717QRosenberger Gregg J · Keller, TXBuilt 1975 · S/N 17265786N9717VTco Inc · Stanley, NDBuilt 1974 · S/N 17264484N9717XEichner David K · Portland, ORBuilt 1962 · S/N 21058017N9718GCain Curtis S · Reno, NVBuilt 1971 · S/N 18052218N9718HDyer Stacey T · Jensen Beach, FLS/N 17266332N9718XLooney Jeffrey J · New Boston, TXBuilt 1962 · S/N 21058018N97190Hickman Donald E II Trustee · Medford, ORBuilt 1979 · S/N 18267009N97192Atlantis Construction Inc · Friday Harbor, WABuilt 1979 · S/N 18267010N97196N2893e LLC · Reno, NVBuilt 1979 · S/N 18267011N97199Perry Martin Dale · Denton, TXBuilt 1979 · S/N 18267012N9719VCumbie Curtis F · Fayetteville, ARBuilt 1974 · S/N 17264485N971AAHobgood David · Bartow, FLBuilt 1966 · S/N 15065572N971BBColon Hector L · Gainesville, GABuilt 1974 · S/N 18263473N971FMFreeway Airport Inc · Mitchellville, MDBuilt 1977 · S/N 15281185N971RWSutherland James P · Wausau, WIS/N 18267004N97200Aragon Cecilia · Sequim, WABuilt 1979 · S/N 18267013N9720GZarones Erik R · Paris, TXBuilt 1971 · S/N 18052220N9720MIliamna Air Taxi Inc · Iliamna, AKBuilt 1981 · S/N 20700720N9720NNash Clay S · Irving, TXS/N 57036N9720RPca Tail One LLC · Wilmington, DEBuilt 1968 · S/N 18258836N9720VBoobas John P · Nicholson, GABuilt 1974 · S/N 17264486N9720XHogue Richard L · Dos Palos, CABuilt 1962 · S/N 21058020N97211G & G 24 LLC · Clancy, MTS/N 18267015N97218Mcgraw Thomas M II · Prescott, AZS/N 18267018N9721GFahrenbruck George · Anchorage, AKBuilt 1971 · S/N 18052221N9721HFoster Gary P · Anchorage, AKBuilt 1975 · S/N 17266334N9721ZRwr Inc · Wasilla, AKBuilt 1982 · S/N U20606625N97220Summit Crest Capital LLC · Palos Heights, ILS/N 18267020N97221Smith Brian A · Big Pine Key, FLBuilt 1979 · S/N 18267021N9722HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266335N9722TFoust Richard W · Minneapolis, KSBuilt 1960 · S/N 47522N9722VTck Services LLC · Millington, MIBuilt 1974 · S/N 17264488N9722XEddy David A · Gilroy, CABuilt 1962 · S/N 21058022N97231Pacific Rim Aviation LLC · Corvallis, ORBuilt 1979 · S/N 18267025N97233Frahm Lon R · Colby, KSBuilt 1979 · S/N 18267026N97237Headley Mark E · Akron, OHBuilt 1979 · S/N 18267028N97238Sanctuary Wings LLC · Norfolk, VAS/N 18267029
Back to AD 87-20-03 R2