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.

N207WTHenson Alan · Houston, TXBuilt 2000 · S/N E-3308N207ZCBuha Holdings LLC · Paris, TXS/N E-3360N2080DSoller Nicholas · Plainsboro, NJBuilt 1953 · S/N D-3431N2080LSparks Halli · Burdett, NYBuilt 1976 · S/N D-9902N2080SRobinson Earl J · Cotuit, MABuilt 1966 · S/N D-8357N2081DSharon Enterprises LLC · Peralta, NMBuilt 1953 · S/N D-3492N2081WN5724v LLC · Kalispell, MTBuilt 1965 · S/N D-8007N2082LChronicle Aerospace Inc · Wilmington, DEBuilt 1976 · S/N TK-20N2082WRegistered aircraftBuilt 1965 · S/N D-8008N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904N2084WBurkett James Austin III · New Port Richey, FLBuilt 1965 · S/N D-8009N2085LFly More Drive Less LLC · Hot Springs, ARBuilt 1976 · S/N D-9908N2086LMortensen Daniel R Trustee · Newhall, CABuilt 1976 · S/N CE-658N2086WSanders Flight Training Center LLC · Jasper, ALS/N TD-644N2087L30 West Pilots LLC · Dover, DEBuilt 1976 · S/N TC-2007N2088CBeech K Holdings LLC · Sheridan, WYBuilt 1959 · S/N D-6044N20896Mccullar Miles Glenn · Hagerman, NMBuilt 1977 · S/N E-1163N2089WBaron 2089w LLC · Jupiter, FLBuilt 1966 · S/N TE-60N208MLAngelo Sorce Md Pllc · Dandridge, TNBuilt 1962 · S/N LF-34N208QPetersen Robert Trustee · Harrodsburg, KYBuilt 1965 · S/N TC-898N208TMustang Sally LLC · Bullhead City, AZFirst renewal noticeBuilt 1974 · S/N E-572N2090LBarnes Seth M · Hot Springs, ARS/N D-10074N2091LLippert John C · Danville, VABuilt 1976 · S/N E-967N2092WEarthcirc08 LLC · Chagrin Falls, OHBuilt 1966 · S/N D-8044N2093WKliewer Silas M · Ulm, MTBuilt 1966 · S/N D-8039N2097DDandekar Shree Ajit · Cedar Park, TXBuilt 1953 · S/N D-3442N20ACOwen Ray L · Los Gatos, CABuilt 1972 · S/N D9371N20CGHyco Industrial Ltd · Houston, TXBuilt 1979 · S/N P-495N20CSChandan Dreamworks Inc · Wilmington, DES/N E-3601N20DJBeach Bum Airways LLC · Saint Petersburg, FLBuilt 1966 · S/N TE-191N20FLowden Howard J · Rome, GABuilt 1965 · S/N TD-623N20GDCoffey James R · Evergreen, COBuilt 1957 · S/N D-5116N20HMMullett Peter C · Carbondale, COBuilt 1975 · S/N E-750N20JWRocky Mountain Triangle LLC · Castle Rock, COBuilt 1962 · S/N TC-258N20MLong David M · Schaumburg, ILBuilt 1983 · S/N BG-204N20RLRose Timothy A · Hickory, MSBuilt 1972 · S/N D-9411N20TYSuziki Shoji · San Jose, CABuilt 1962 · S/N TC-254N20XLTwin Bat Plane LLC · Tupelo, MSS/N P-566N2100DL A M Capital Management LLC · Sheridan, WYBuilt 1978 · S/N ME-41N2100EKovach David A Md · Greenwood, INBuilt 1971 · S/N E-290N21011Lucy Donald Edwin III · Newbury Park, CABuilt 1957 · S/N BA-292N2101WUtset Anthony · Okeechobee, FLBuilt 1973 · S/N M-1471N2102DLong Kenneth C · Inverness, FLBuilt 1953 · S/N D-3447N2103LMcgregor Steve · Oil City, PABuilt 1977 · S/N TC-2023N2103WGoold Michael D · Fort Worth, TXBuilt 1973 · S/N M-1450N2104WMorgan Austin T · Henderson, NVBuilt 1973 · S/N M-1444N2105DCherwink David · Aledo, TXBuilt 1953 · S/N D-3450N2105LBishop William E · Fredericksburg, TXBuilt 1976 · S/N D-9912N2105WNenow William R · Tulare, CABuilt 1973 · S/N M-1433N2106DNewton Harold D Jr · Albuquerque, NMBuilt 1953 · S/N D-3451
Back to AD 99-05-13 R1 WD