OpenAirDocs.org
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.

N736EVRogerson James H · Chandler, AZBuilt 1977 · S/N R1722477N736EXHolt Aviation LLC · Clear Lake, IABuilt 1977 · S/N R1722479N736FADebold Denise S · Spring, TXS/N R1722482N736FBNimbus 2000 LLC · Farmington, UTS/N R1722483N736FCJrm Wings LLC · Farmington, UTBuilt 1977 · S/N R1722484N736FDKing Brad C · Langley, WABuilt 1977 · S/N R1722485N736FFNorkunas Lisa M · Fontana, CABuilt 1977 · S/N R1722487N736FGJ M Carrigan LLC · Sanibel, FLBuilt 1977 · S/N R1722488N736FJHartwick Kevin D · Crescent City, CABuilt 1977 · S/N R1722490N736FNWilliamson Thomas M · Southport, NCBuilt 1977 · S/N R1722493N736FSRussell Larry B DBA · Union City, TNBuilt 1977 · S/N R1722497N736FTChoice Aviator LLC · Chandler, AZBuilt 1977 · S/N R1722498N736FVDel Rio Advisors LLC · Modesto, CABuilt 1977 · S/N R1722500N736FXKelcy Wyman O · Early, TXBuilt 1977 · S/N R1722502N736FYPhydeaux Aviation Ltd · Spartanburg, SCBuilt 1977 · S/N R1722503N736GAPlane Jane Aviation LLC · Sylvania, GABuilt 1977 · S/N R1722505N736GBSilva Monico · Albuquerque, NMBuilt 1977 · S/N R1722506N736GCSilvers Morris · Burnsville, NCS/N R1722507N736GDPactolus Investments LLC · Blounts Creek, NCS/N R1722508N736GGLedocq Melissa A · Green Bay, WIBuilt 1977 · S/N R1722511N736GHTriple R Flying · Monticello, IABuilt 1977 · S/N R1722512N736GJRyan Transfer Inc · Tilden, NEBuilt 1977 · S/N R1722513N736GKOrten Steven S Md · Dallas, TXBuilt 1977 · S/N R1722514N736GNMorrison Scott W · Kokomo, INS/N R1722517N736GUFaria Farms Inc · Tipton, CABuilt 1977 · S/N R1722523N736GVChristiansen Drilling Inc · Ely, NVBuilt 1977 · S/N R1722524N736GWMartin Stephen E · Pampa, TXBuilt 1977 · S/N R1722525N736GZJust US Air LLC · Bradenton, FLBuilt 1977 · S/N R1722528N736HATurner Daniel A · Paragould, ARBuilt 1977 · S/N R1722529N736HBZero-To-1500 LLC · Tacoma, WABuilt 1977 · S/N R1722530N736HDGuthrie John Alex · San Ramon, CABuilt 1977 · S/N R1722532N736HFStoklosa Michael · Miami, FLBuilt 1978 · S/N R18200730N736HGMcclure Richard A · Victoria, TXBuilt 1977 · S/N R1722535N736HMAir Force Academy Aero Club · Usaf Academy, COBuilt 1977 · S/N R1722540N736HNRegistration Pending · Orange Grove, TXRegistration pendingBuilt 1977 · S/N R1722541N736HSHodgskiss Ben · Choteau, MTBuilt 1977 · S/N R1722545N736HWInvestair LLC · Conway, ARBuilt 1977 · S/N R1722549N736HZBird Chad W · Santa Ana, CABuilt 1977 · S/N R1722552N736JESylvan Air Associates LLC · Lapeer, MIBuilt 1977 · S/N R1722557N736JFHartsuyker David L · Jackson, CABuilt 1977 · S/N R1722558N736JHLloyd Stephen C · Erie, COBuilt 1977 · S/N R1722560N736JKMcfeaters Ryan C · Madisonville, TNBuilt 1977 · S/N R1722562N736JQRaven Limited · Seattle, WABuilt 1977 · S/N R1722567N736JRMckibben Claude · Rochelle, ILBuilt 1977 · S/N R1722568N736JTRose Chris W · Rochester, NYS/N R1722570N736JVRegistered aircraftBuilt 1977 · S/N R1722572N736JWHutcherson David R · Gretna, VABuilt 1977 · S/N R1722573N736JYBorreson Anthony · Mariposa, CABuilt 1977 · S/N R1722575N736KCGreen Robert W · Santa Barbara, CABuilt 1977 · S/N R1722579N736KDAmts LLC · Pleasanton, CABuilt 1977 · S/N R1722580
Back to AD 87-20-03 R2