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.

N24618Borges Joe A · Highland, CAFirst renewal noticeBuilt 1972 · S/N MB-557N24625Mason Ron · Tallahassee, FLBuilt 1972 · S/N MC-140N24629Hurd Jeffrey R · Gilbert, AZS/N M-1458N24631San Jose Mixer Inc · Gilroy, CABuilt 1973 · S/N M-1459N24640Olive Aviation LLC · Anchorage, AKBuilt 1973 · S/N M-1461N24645Kangas Matthew W · Covington, WABuilt 1973 · S/N MB-564N24646Kosko Stanley G · Seattle, WABuilt 1973 · S/N MB-561N24652Graber Howard J · Montgomery, INBuilt 1973 · S/N M-1430N24653Phillips Alan K · Junction City, ORBuilt 1973 · S/N MB-570N24660Arey Dale W · Laramie, WYBuilt 1973 · S/N MB-565N24662Dumay Chad · O Fallon, MOBuilt 1973 · S/N MC-139N24663Stuber Paul A · Kansas City, MOS/N M-1425N24665Axiom Development & Consulting LLC · Atlanta, GAS/N MC-147N24672Gurgainous Larry K · Fredericksburg, VABuilt 1973 · S/N MC-154N24676Goren Matthew B · Wilmette, ILBuilt 1972 · S/N M-1414N24679No Limits Aviation Inc · Hayden, IDBuilt 1973 · S/N MB-576N24693Anderson Mark D · Eureka Springs, ARBuilt 1973 · S/N M-1443N24696Lucas Charles W · Ladson, SCBuilt 1973 · S/N M-1422N246ALAiror LLC · Lees Summit, MOBuilt 1978 · S/N E-1412N246DYWilson Ralph W Trustee · Mentor, OHBuilt 1996 · S/N E-3065N246EEBaldwin Alexander L · Saint Charles, MOS/N D-6797N246WBToavs Brent J · Wolf Point, MTBuilt 1969 · S/N D-8951N246WF2 4 6 Whiskey Foxtrot LLC · Knoxville, TNBuilt 1973 · S/N M-1427N2472Vivid Aviation LLC · Las Vegas, NVBuilt 1976 · S/N E-906N2472YAndrews Kevin M · Riverside, CABuilt 1970 · S/N E-254N247AAN247aa LLC · Benton, KSBuilt 1959 · S/N D-6034N247BAArizona Wings LLC · Cave Creek, AZBuilt 1960 · S/N D-6391N247CGParsons John C · Augusta, KSS/N CH65N247GNTommy Hanka Farms LLC · Mission, TXBuilt 1968 · S/N TC-1119N247KTFly Kt LLC · Coconut Creek, FLBuilt 1977 · S/N MC-497N248G E Flight Services LLC · Clarksdale, MSBuilt 2001 · S/N EA-678N248DDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1966 · S/N TE-171N248EPemberton Addison J · Spokane, WABuilt 1944 · S/N 6871N248JBRiverode Sales Inc · Pontiac, ILBuilt 1978 · S/N TC-2124N248MHatton Wesley · Murrieta, CABuilt 1964 · S/N TC-558N248RPPatterson Robert F · Buckley, WABuilt 1958 · S/N FM84-1N249ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N CJ132N249BB42m Aviation LLC · Shady Shores, TXBuilt 1979 · S/N D-10318N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249N249EABertsch Paul J · Houston, TXBuilt 1962 · S/N D-7051N249MVAmble Tod M · Bozeman, MTBuilt 1979 · S/N CE-884N249TJF Korbel & Bros · Guerneville, CABuilt 1966 · S/N TE-249N249WHWhiskey Hotel LLC · O Fallon, MOBuilt 1978 · S/N CJ-147N249WLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N CJ-134N24AAGentry Robert L · Tyler, TXFirst renewal noticeBuilt 1955 · S/N D-4285N24AGAegis Air LLC · Columbia City, INBuilt 1979 · S/N D-10293N24AKLund Kristoffer B · Encinitas, CABuilt 1968 · S/N TC-1150N24ASRegistered aircraftBuilt 1985 · S/N E-2259N24BEMystic Knights Of The Air Lodge Inc · Canton, MSBuilt 1979 · S/N E-1540N24BFWright Aviation Inc · Pikeville, KYBuilt 1980 · S/N E1736
Back to AD 99-05-13 R1 WD