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.

N2361LUnderwood Richard R · Armuchee, GABuilt 1963 · S/N M-190N2361WGaffney Richard J · Richmond Hill, GABuilt 1966 · S/N M-958N2361ZBoyles Michael K · Waynesboro, MSBuilt 1962 · S/N M-73N23620Erickson Brian C · Pahrump, NVBuilt 1977 · S/N E-1165N23621Excellance Inc · Madison, ALBuilt 1977 · S/N E-1192N2362LWatkins William V · Porter, OKBuilt 1963 · S/N M-176N2362QStiers Randell E · Bunker Hill, INBuilt 1963 · S/N M-435N2362ZFlowers Jesse S · Moscow, IDBuilt 1962 · S/N M-76N23639Teleprint Inc · Rydal, PABuilt 1978 · S/N E-1293N2363ZBlack Thomas L · Springtown, TXBuilt 1962 · S/N M-77N23642Samson Motors Inc · Redmond, ORBuilt 1977 · S/N CE-759N2364JSwenson Roger A · Pahrump, NVBuilt 1963 · S/N M-322N2365LPrue Paul E · Golden, COBuilt 1963 · S/N M-201N2365QGonzalez Lazaro · Springfield, NJS/N M-439N2366JPhillips Michael L · Mays Landing, NJS/N M-324N2366ZAerotyne International LLC · Prattville, ALBuilt 1962 · S/N M-87N23674Siebenhaar Harold J · Los Altos, CAS/N D-10146N2367PCrowley Steven J · Burlington, IABuilt 1981 · S/N TC-2367N23682Next Century Aviation Oregon LLC · Sausalito, CABuilt 1978 · S/N E-1205N23685Clements Dennis · Chapel Hill, NCBuilt 1978 · S/N D-10099N2368QWagner Steve · Prescott, AZBuilt 1963 · S/N M-448N2368ZJpk Aviation LLC · Bowling Green, KYBuilt 1962 · S/N M-89N2369JSchemenauer Phillip · Bristol, INFirst renewal noticeBuilt 1963 · S/N M-327N236AWFischer Michael N · Manito, ILS/N M-946N236BEMcgill Benjamin D · Larchmont, NYBuilt 1981 · S/N E-1825N236CHGta Air Inc · Addison, TXBuilt 1973 · S/N E-502N236HPProctor John M · Spotsylvania, VABuilt 1987 · S/N E2399N236JEGunnels Farms Inc · Amarillo, TXS/N TC-2092N236JPLauderdale Thomas J · Bates City, MOBuilt 1970 · S/N E-211N236MMFunkhouser Robert Scott · The Woodlands, TXBuilt 2003 · S/N E-3514N236RMConrad Harold M · Sugar Grove, ILBuilt 1979 · S/N EA-43N236SRb Aviation Enterprise LLC · Palm City, FLBuilt 2004 · S/N E3555N236TCCka Investments LLC · Fernandina Beach, FLBuilt 1979 · S/N EA-23N236WBt1 Air LLC · Grover Beach, CABuilt 2002 · S/N E-3432N2370QBrandt James R · Caro, MIBuilt 1963 · S/N M-443N23714Dyk Aviation LLC · Williston, NDBuilt 1978 · S/N E-1206N23717Advanced Helicopter Services · Woodland, CABuilt 1978 · S/N E-1208N2371WSpaich Brad G · Mcpherson, KSBuilt 1966 · S/N MB-9N23723Kleck Wil · Victoria, TXBuilt 1978 · S/N D-10100N23724Zhang Harvest Land · Moraga, CABuilt 1978 · S/N E-1211N2372JSea Serpent Tours Inc · Saint Augustine, FLS/N M-336N2372QBlack Stephen L · Winterset, IABuilt 1963 · S/N M-445N2372WHulme Aviation LLC · Gilbert, AZBuilt 1966 · S/N MB-10N2372ZMills Zachary J M · Belfair, WABuilt 1962 · S/N M-75N2373WFayettenam Aero LLC · Laurinburg, NCBuilt 1966 · S/N MA-3N2374ZSale Reported · Fort Worth, TXSale reported, canceledBuilt 1962 · S/N M-98N23752Talton David S · Tupelo, MSBuilt 1978 · S/N E-1215N23753Lifestyle Aviation LLC · Dallas, TXBuilt 1978 · S/N CE-762N23757Walinchus Robert E · Pooler, GAS/N CE-731N2375LEdgren Alan J · Punta Gorda, FLBuilt 1963 · S/N M-223
Back to AD 99-05-13 R1 WD