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.

N63DWHogg James R · New Albany, OHBuilt 1960 · S/N D-6589N63JLStoneman Thomas K · Friendswood, TXBuilt 1971 · S/N TE-839N63JMBeer Galynn W · Dewitt, MIBuilt 1980 · S/N EA-80N63JNDesert Air Inc · Phoenix, AZBuilt 1997 · S/N EA602N63LFChase 13 LLC · Wilmington, DEBuilt 1958 · S/N D-5666N63MABarlo Management Group LLC · Winona, MSBuilt 1964 · S/N TC-719N63MTGriffith Gary L · Palestine, TXBuilt 1962 · S/N M-97N63PTSkypoint Aviation LLC · Wilmington, DES/N D-7135N63RJDratler Stanley M · Fort Myers, FLBuilt 1974 · S/N TC-1804N63TMartin Sky LLC · Beaufort, SCBuilt 1975 · S/N E-703N63TCRegistered aircraftBuilt 1972 · S/N E-384N63TLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2000 · S/N E-3307N6401HBooskye LLC · Dumas, TXBuilt 1981 · S/N TJ-401N6404DNogle Charles H · Champaign, ILS/N G-124N6407XRobert G Whittel P A · Gainesville, FLS/N EA-295N6408QAftershock Marketing Inc · Henryville, PABuilt 1982 · S/N TJ-408N64098Sottile Joseph Jr Trustee · Chandler, AZBuilt 1978 · S/N D-10128N6409SWas He Slow LLC · Chagrin Falls, OHBuilt 1976 · S/N D-9838N640DBridges Janiece R · Forsyth, MOBuilt 1951 · S/N D-2904N640MCConston Kenneth M · Hopewell Junction, NYBuilt 2001 · S/N EA-682N640QSmythe John J III · Rancho Palos Verde, CABuilt 1959 · S/N D-5926N640SCBest Crane & Equipment Co LLC · Wilmington, DEBuilt 1979 · S/N P488N640TLaughridge Dave · Rugby, NDBuilt 1958 · S/N D-5784N6412XFucaimo LLC · South Pasadena, CAS/N TJ-412N6416NMcdonald Marshall H · Saint Petersburg, FLBuilt 1982 · S/N E-2043N641GWalrabenstein Eric S · Glendale, AZBuilt 1976 · S/N D-9896N641PSSmith Michael J · Napa, CABuilt 1979 · S/N ME-155N641VKomarek Mark C · Stoddard, WIBuilt 1959 · S/N D-6117N64200D&G Baron LLC · Helena, ARBuilt 1982 · S/N TJ-420N6428SWickboldt Michael P · Woodland, CABuilt 1976 · S/N D-9842N642GInguagiato Thomas · Hood River, ORBuilt 1987 · S/N E-2372N642TBambey John J · San Leandro, CABuilt 1958 · S/N D-5466N643DPoole William R · Hilton Head Island, SCBuilt 1951 · S/N D-2908N643QGossett Harold D Jr · Granbury, TXBuilt 1957 · S/N D-5318N643VParis Kyle R · Amarillo, TXBuilt 1959 · S/N D-6261N6444CNichols Christian Travis · Rio Rancho, NMBuilt 1982 · S/N EA-275N6446NB55 LLC · Lawrenceville, GAFirst renewal noticeBuilt 1982 · S/N TC-2454N6449NBaumann Richard A Trustee · Tempe, AZBuilt 1982 · S/N EA-298N644BLGahan Matthew · San Clemente, CABuilt 1989 · S/N EA492N644DBFolkner Thomas E R · Shelley, IDS/N D-7341N644RCBenkovich Thomas · Hammonton, NJBuilt 1956 · S/N D-4616N644TGier Roberta L · Bozeman, MTBuilt 1957 · S/N D-5380N6450DRosen Gary J · Manchester, MAS/N G-67N6453CSale Reported · Miller, SDSale reported, pending cancellationS/N EA-277N6455DFleckenstein David L · Nacogdoches, TXBuilt 1959 · S/N 34-94N6455NHangar 31 Inc · La Jolla, CABuilt 1973 · S/N CE-424N6456CWab Enterprises Inc · Fountain Hills, AZBuilt 1982 · S/N EA-303N645DRiggin Flight Service Inc · Madison, SDBuilt 1951 · S/N D-2910N645TWatercut Services Inc · Kilgore, TXBuilt 1958 · S/N D-5634N645VRegistered aircraftBuilt 1960 · S/N D-6276
Back to AD 99-05-13 R1 WD