OpenAirDocs.org
AD 87-20-03 R2

Registered aircraft · 54,017

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.

N4449RMorrow David · Maynardville, TNBuilt 1978 · S/N R18200602N4449XBurns William R · Greensboro, GABuilt 1962 · S/N 18254138N444AASipola Don H · Virginia, MNBuilt 1973 · S/N 18261920N444APSmith Robert S · Orlando, FLBuilt 1975 · S/N 177RG0787N444BSSiemens Christopher L · Seminole, TXBuilt 1978 · S/N 21062823N444CLK G L Aviation Inc · Villisca, IABuilt 1975 · S/N 21060910N444EEVaughn Stewart C · West Jordan, UTBuilt 1974 · S/N 17263906N444FRegistration Pending · Auburn, CARegistration pendingBuilt 1977 · S/N 21061686N444FLAeroflyin Corp · Miramar, FLS/N 17268861N444GENeverland LLC · Emerson, IABuilt 1978 · S/N 18266675N444GMTwo W Aviation LLC · Casper, WYBuilt 1976 · S/N 182-65005N444GSWhitten Andrew J · Astoria, ORBuilt 1975 · S/N 15077446N444JGGrimmonpre Mark D · Fort Walton Beach, FLBuilt 1968 · S/N 17257013N444LLWolfson Alan B · Loveland, OHBuilt 1962 · S/N 18254063N444PJWagner Aviation LLC · Laura, OHBuilt 1974 · S/N 21060433N444PPCoyne Greg · Hondo, TXBuilt 1969 · S/N 17258278N444REJenson Greg Ray · Pueblo, COS/N 55174N444RWBackus Gary Carl · Chesapeake, VABuilt 1979 · S/N 21063465N444TF4tf LLC · Missoula, MTBuilt 1959 · S/N 46907N444TJWerner Michael H · Edmond, OKBuilt 1979 · S/N 17272953N444TR444 Tr Inc · Van Alstyne, TXBuilt 1967 · S/N 15067661N444XPEiron Nadav · Portola Valley, CABuilt 1969 · S/N 18052051N444YZBlue Aero Group LLC · Blairstown, NJBuilt 1965 · S/N 17253119N4450BRiverview Farm · Starbuck, MNBuilt 1955 · S/N 26794N4450CC & C Auto Sales LLC · Atlanta, MOBuilt 1960 · S/N 56553N4450LSouth Side Corp · Cody, NEBuilt 1966 · S/N 17254545N4450UGrove Keven W · Ankeny, IABuilt 1964 · S/N 15060450N4452LVenhuizen Todd M · Queen Creek, AZBuilt 1966 · S/N 17254547N4452RZitting Fredrick J · Colorado City, AZS/N 17263194N4452UDiehl Annette L · Pasco, WABuilt 1964 · S/N 15060452N4453BBussolari Steven R · Evanston, ILBuilt 1955 · S/N 26797N4453CKesinger Steven W · Fremont, CABuilt 1953 · S/N 16038N4453LByers Keith W · Ruffs Dale, PABuilt 1966 · S/N 17254548N4453QKeene Greggory L · Abbeville, GABuilt 1971 · S/N 18800853N4453RJackson Robin D · Harlan, IABuilt 1974 · S/N 17263195N4453URedcardinalaviation LLC · Chantilly, VAS/N 15060453N4454BHudson Kent O · Anchorage, AKBuilt 1955 · S/N 26798N4454RDekle Drew · Athens, GAS/N 17263196N4455CJohnson Kyle A · Cheshire, CTBuilt 1952 · S/N 7965N4455LLeiser Harry W · Rome, PABuilt 1966 · S/N 17254550N4455QHaring Clay DBA · Lincoln, KSBuilt 1971 · S/N 18800855N4456RTruskey David R · Dauphin, PABuilt 1974 · S/N 17263198N4457BCelestina Harold C · Ester, AKBuilt 1956 · S/N 26801N4458CMarken Jeffrey R · Baker, FLBuilt 1953 · S/N 16043N4459CHankins Shannon G · Tulsa, OKBuilt 1953 · S/N 16044N445DCWith Wings As Eagles Aviation LLC · Middletown, DEBuilt 1975 · S/N 18263690N445RDensmore John L · Conway, WABuilt 1974 · S/N 17262596N4460LRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1966 · S/N 17254555N4460URegistration Pending · Lake Saint Louis, MORegistration pending, canceledBuilt 1964 · S/N 15060460N4461LMerdan Curtis D · Shady Shores, TXBuilt 1966 · S/N 17254556
Back to AD 87-20-03 R2