OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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.

N805JCBig Sky Baron Lc · Missoula, MTBuilt 1980 · S/N TJ-253N805NHT-Bone Truck Stop Inc · Columbus, NEBuilt 1992 · S/N E-2699N80608E&L Enterprises · Chinook, MTBuilt 1963 · S/N D-7176N8062RMills River Publishing Co · Rushville, INBuilt 1970 · S/N M-1300N8064MTeam Financial Inc · Birmingham, ALBuilt 1992 · S/N CE-1674N8064NSierra Hotel Aviation LLC · Spartanburg, SCBuilt 1990 · S/N E-2578N8064RN8064r LLC · Kalispell, MTBuilt 1970 · S/N MB-492N8064UCommercial Flight Services Inc · West Chester, PABuilt 1992 · S/N CE-1673N8067UPalmer Eric E · Tucson, AZBuilt 1992 · S/N EA-536N8068USan Diego Flight Corp · San Diego, CABuilt 1992 · S/N E-2725N8069GR B Hanson Equipment LLC · Clancy, MTBuilt 1992 · S/N CE-1677N8069RDouble R Farm Inc · Clayton, NMBuilt 1969 · S/N D-9019N8069UV115 Aviation LLC · Mount Juliet, TNBuilt 1992 · S/N E-2727N806NHWes Electric LLC · Lafayette, LABuilt 1992 · S/N E-2702N806RAndrews Seth K · Tampa, FLBuilt 1959 · S/N D-6083N806TPickering Jeff C · Paris, TXBuilt 1973 · S/N E-423N80722Benzinger Fay A · Bethesda, MDS/N CE-295N8072DLong Jill A · Apo, AES/N E-2728N8073HFrye Lloyd H · Zachary, LAS/N CE-1682N8073WKilo Mike LLC · Nancy, KYBuilt 1992 · S/N E-2730N8074RHilde Chadwick Q · Statesboro, GABuilt 1969 · S/N D-8982N8077MKriessler Scott C · Port Clinton, OHBuilt 1990 · S/N E-2565N8077XTudor George J · Mecca, CABuilt 1990 · S/N E-2534N8079ZParker Larry E Jr · Lumber Bridge, NCBuilt 1992 · S/N EA-538N807DJGreat West Produce Co Inc · Commerce, CABuilt 2001 · S/N E-3371N807LWLocke Jeffrey · The Plains, VABuilt 1978 · S/N CE-807N807NHJohnson Gregory D · Elkhart, IAS/N E-2704N807RHenricks Alen · Watertown, SDBuilt 1959 · S/N D-6084N807TKelly Michael J · Overgaard, AZBuilt 1964 · S/N D-7691N807WHDulin Thad L · Midland, TXBuilt 1969 · S/N TC-1250N8080NStratz Gregory A · Port Orange, FLBuilt 1992 · S/N CE-1688N8080PPiper Llp · Decatur, ALBuilt 1992 · S/N E-2736N8080RKubit John · Edgewood, TXS/N D-8993N8081RCook Marvin R · Portales, NMBuilt 1969 · S/N D-8994N8083FTindall Haul And Erect Corp · Spartanburg, SCBuilt 1993 · S/N E-2771N8083RR And P Air LLC · Cimarron, KSBuilt 1992 · S/N CE-1689N8085NRandall Daniel Ronald · Minneapolis, MNS/N E-2740N8085RMcgilvray Jeremme Allen · Carson City, NVBuilt 1969 · S/N TC-1246N8087RCavanaugh Robert K · Valparaiso, INBuilt 1992 · S/N E-2738N8088JPhillips Robert Carroll III · Waxhaw, NCBuilt 1990 · S/N E-2502N8088RFree Philip O · Collierville, TNBuilt 1969 · S/N TC-1252N808CWHeritage Custom Construction Inc · Stone Harbor, NJS/N P-456N808DJAeroquest LLC DBA · Olive Branch, MSBuilt 1982 · S/N ME-391N808GRRoth Geoffrey Hh Trustee · Sedona, AZBuilt 1963 · S/N D-7214N808LCHulsey Michael · Prescott, AZBuilt 1980 · S/N TJ-319N808NHAkers Gary L · Eden, NCS/N E-2817N808TSGross Andrew · Mooresville, NCBuilt 1968 · S/N CJ-1N808WRAlta Aviation LLC · Baileys Harbor, WIBuilt 2004 · S/N E-3570N8091TTranski Tyler · Del Mar, CABuilt 1992 · S/N CE-1655N8093RBrand David E · Touchet, WABuilt 1969 · S/N D-8996
Back to AD 99-05-13 R1 WD