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.

N301PLCutbirth David B · Monahans, TXBuilt 1966 · S/N P206-0334N301RS2f Trade LLC · Collinsville, TXS/N 21062473N301WBBreum Sean M · Stanwood, WAS/N 25343N3020UKelly Ho-Montoya Insurance Group LLC · Wichita Falls, TXBuilt 1963 · S/N 17250620N3020XLima 2 Aviation Of Mississippi LLC · Bogue Chitto, MSBuilt 1966 · S/N 15064420N3020YJ & T Sullivan Farms Gp · Macon, TNBuilt 1962 · S/N 18254020N30218Mckillip Kirby G · Kemah, TXBuilt 1968 · S/N 17701127N3021BChase 13 LLC · Wilmington, DES/N 7904N3021EAircraft Solutions LLC · Spokane, WABuilt 1978 · S/N 17271405N3021FRegistered aircraftBuilt 1966 · S/N 18257121N3021JDuffy William B · Denton, TXBuilt 1965 · S/N 15061121N3021QPicco Anthony · Sykesville, MDBuilt 1967 · S/N 18258021N3021SCollett Danny W · Stewart, TNBuilt 1967 · S/N 15066921N3021XMay'S Welding Service Inc · Cotulla, TXS/N 15064421N3021YBrancao Bryan A · Norco, CABuilt 1962 · S/N 18254021N30225Hall Curtis B · Shepherdsville, KYBuilt 1968 · S/N 17701131N3022AReese Brandon A · Bend, ORBuilt 1953 · S/N 25666N3022EBoulais Aaron · Upland, CABuilt 1982 · S/N 18268227N3022SMcnulty Bobby J · Luling, LABuilt 1967 · S/N 15066922N3022VRetroair Restoration LLC · Big Lake, AKBuilt 1974 · S/N 15076354N3022XCintim LLC · Carrabelle, FLS/N 15064422N30231Pankratz Paul J · Lakeville, MNBuilt 1968 · S/N 17701136N30235Booher Harold D · Manchester, MOBuilt 1968 · S/N 17701139N30238Nunley Dwight · Hawkins, TXBuilt 1968 · S/N 17701142N30239Jones Gary E · Orange, CABuilt 1968 · S/N 17701143N3023APhillips Danny W · Jefferson, TXBuilt 1953 · S/N 25667N3023BWelch Thomas R · Modesto, CABuilt 1952 · S/N 7906N3023FJones Clinton D · Santa Rosa Beach, FLBuilt 1966 · S/N 18257123N3023SSynnes Dale C · Santa Paula, CABuilt 1967 · S/N 15066923N3023YMorgan Lee Blanchard · Albuquerque, NMFirst renewal noticeS/N 18254023N3024FSutton Aircraft Salvage LLC · Palmer, AKBuilt 1966 · S/N 18257124N3024XDavis James M · Tuscaloosa, ALBuilt 1966 · S/N 15064424N3024YTemple Curtis Lee · Porcupine, SDBuilt 1962 · S/N 18254024N30250O'Connor Sean J · Newburyport, MABuilt 1968 · S/N 17701150N3025FWarner Daniel M · Fremont, OHBuilt 1966 · S/N 18257125N3025SHummer Bryant C · Garden Plain, KSBuilt 1967 · S/N 15066925N3025UEddy Bruce A · Winfield, ALBuilt 1963 · S/N 17250625N30268Rudd Terry R · Clarkston, WABuilt 1973 · S/N 21059903N3026APowell Alvin L · Caldwell, IDS/N 25670N3026BMacario T Michael · Townsend, DEBuilt 1952 · S/N 7909N3026FMock1 LLC · Abingdon, VABuilt 1966 · S/N 18257126N3026JRoberts James D Trustee · Omaha, NEBuilt 1965 · S/N 15061126N3026QSuper D Group LLC · Hanoverton, OHBuilt 1967 · S/N 18258026N3026SSolewin Kimberly M · Christoval, TXBuilt 1967 · S/N 15066926N3026VNew Mexico Flying Eagle Inc DBA · Tucson, AZS/N 15076355N3026YEpss LLC · Tavernier, FLBuilt 1962 · S/N 18254026N30275Tomlinson Douglas F · Waunakee, WIBuilt 1968 · S/N 17701167N30278Barron Joseph M · Des Moines, IABuilt 1975 · S/N 17264133N3027BLacey William F · Parker, COBuilt 1952 · S/N 7910N3027FSale Reported · Watford City, NDSale reported, pending cancellationBuilt 1966 · S/N 18257127
Back to AD 87-20-03 R2