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.

N90558Hagele Aviation LLC · Hillsboro, ORS/N 17274773N9055CBison Aero LLC · Kalispell, MTBuilt 1978 · S/N R18200382N9055MVincent Flying Service Inc · Kaplan, LABuilt 1970 · S/N 18052155N9056AGreenough Wade E · Kasilof, AKS/N 18815N9056MGlasscock David M · Matthews, NCBuilt 1977 · S/N 21062055N9056TMowbray Carmine Trustee · Polson, MTBuilt 1960 · S/N 52956N9057HAmoroso Ricardo C · Powder Springs, GABuilt 1975 · S/N 17265921N9057MUnderhill James F · Charleston, WVBuilt 1976 · S/N 18264658N9057SMedical Supply X LLC · Coats, NCS/N 21065009N9058TJlp Equipment LLC · Anchorage, AKBuilt 1960 · S/N 52958N9058XSouthern Skies Aviation Inc · Cedar City, UTBuilt 1960 · S/N 18253458N9059AKown William B · Hamilton, ALS/N 18818N9059GElevated Aviation LLC · West Plains, MOBuilt 1971 · S/N 18260599N9059MMortvedt Arthur D Trustee · Manley Hot Springs, AKBuilt 1970 · S/N 18052159N9059TTwt Wings LLC · Mccall, IDBuilt 1960 · S/N 52959N9059XHunt William E Jr · San Jose, CABuilt 1961 · S/N 18253459N905AZN905az LLC · Miami, FLBuilt 1986 · S/N 17276651N905BWMauro William J · Lancaster, CABuilt 1968 · S/N 21059033N905KKRdc Air LLC · Lithia, FLBuilt 1970 · S/N 33701348N905KSZoppe Eduardo · Lakewood Ranch, FLBuilt 1985 · S/N 17276516N905WAMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17269967N9060GWalther Newell A · Wasilla, AKBuilt 1971 · S/N 18260600N9060HJ&S Flying Enterprises LLC · Zanesville, OHBuilt 1975 · S/N 17265922N9060MAshland Jeffrey C · Spirit Lake, IABuilt 1976 · S/N 18264659N9060XLattin Travis W · Beloit, KSBuilt 1960 · S/N 18253460N9061XSmithhart James R · Normandy Park, WABuilt 1961 · S/N 18253461N9062ASale Reported · Wasilla, AKSale reportedBuilt 1949 · S/N 18821N9062MKissee Dale D Trustee · Chugiak, AKBuilt 1970 · S/N 18052162N9063XGregory Larry C Trustee · Farmington, MOBuilt 1961 · S/N 18253463N9064GEvans Brandon Ks · Montgomery, ALBuilt 1971 · S/N 18260604N9064XCherokee Three LLC · Greensboro, NCBuilt 1961 · S/N 18253464N9064ZCarranza Matthew J · Casa Grande, AZBuilt 1956 · S/N 32275N9065MWillecke Donald K · Punta Gorda, FLBuilt 1976 · S/N 18264662N9065TBarker Adam W · Mendota, VAS/N 52965N9066MHarbison Laura L · Redlands, CABuilt 1976 · S/N 18264663N9066RForage Jean Pierre Md · Lakeway, TXBuilt 1978 · S/N R18200660N9066TVertical Investment Strategies LLC · Mesquite, NVBuilt 1960 · S/N 52966N9066XSkyskaters LLC · Portland, ORBuilt 1961 · S/N 18253466N9067THatch Greg J · Billings, MTFirst renewal noticeBuilt 1960 · S/N 52967N9067XN78305 LLC · Kindred, NDBuilt 1961 · S/N 18253467N9068ALucas Terry L · Oakdale, CABuilt 1949 · S/N 18827N9068HGundlach Mark A · Fruitland, WABuilt 1975 · S/N 17265928N9068MShaw Brian · Granada, COS/N 18052168N9068RHrabe Dusten · Chamberlain, SDBuilt 1975 · S/N 18802095TN9068XWeinberg Jerry J · Metairie, LABuilt 1961 · S/N 18253468N9069MGross Marlene K · Clear Lake, IABuilt 1970 · S/N 18052169N9069XKeefer Aviation LLC · Lancaster, OHBuilt 1961 · S/N 18253469N906AZN906az LLC · Miami, FLBuilt 1978 · S/N 15282474N906KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272697N906MDFive Rivers Flight Training LLC · Livermore, CABuilt 1976 · S/N 17268038
Back to AD 87-20-03 R2