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.

N65BEStarwood Air LLC · Missoula, MTBuilt 1994 · S/N E-2837N65BWBuzzard Max · Tulsa, OKS/N D-8294N65CSChallans Robert F · Hesston, KSS/N LC-82N65JEVan Wadle Aviation LLC · Blairsville, GABuilt 1978 · S/N E-1231N65JMGjf Enterprises Inc · Port Orange, FLBuilt 1974 · S/N TE-991N65LVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N D-8238N65MJPlane Fun Inc Tr Trustee · Snellville, GABuilt 1985 · S/N TJ-487N65QTvs LLC · Oak Park, ILBuilt 1974 · S/N CE-493N65QAGulf States Air Inc · Bossier City, LAS/N LC-165N65SBJarrett Airspray Inc · Jamestown, NDBuilt 1965 · S/N D-7905N65SH65 Sierra Hotel LLC · Wilmington, DEBuilt 1970 · S/N CJ-28N65TCCloud 8 LLC · West Hartford, CTBuilt 1987 · S/N E-2385N65VBCollins Scott W · Upland, CABuilt 1965 · S/N D-7821N65WROneill Patrick John · Red Wing, MNS/N TC-923N65YLippman Thomas N Trustee · Brisbane, CABuilt 1977 · S/N D-10080N6600CHulen Christopher A · Conroe, TXBuilt 1982 · S/N CE-967N6600LBonanza Partners LLC · Newton Centre, MABuilt 1977 · S/N E-1074N6601NMcfarland Andrew J · Camarillo, CABuilt 1983 · S/N CE-1015N6602RFagundes Farms · Hanford, CABuilt 1974 · S/N MB-734N6605XCifelli Michael A · Bay Shore, NYBuilt 1983 · S/N CE-1016N660BConlin Michael T · Pawleys Island, SCBuilt 1948 · S/N D-1661N660R660 Romeo LLC · Tulsa, OKBuilt 1968 · S/N D-8826N660VSky Guy LLC · Frankenmuth, MIBuilt 1960 · S/N D-6415N6611ESpirit Of Faith Family Church · Cedar Rapids, IAS/N EA-347N66126Maine Instrument Flight · Augusta, MEBuilt 1983 · S/N M-2382N6613AAustin Bill DBA · Sparta, TNBuilt 1983 · S/N E-2070N6613RPollazzi Steven N · New Hope, PABuilt 1974 · S/N MC-312N6616RVanover Kevin · Whitesburg, KYS/N MB-736N661BYork Robert A · Dillsburg, PABuilt 1947 · S/N D-1662N661BWTailwinds Services And Commodities Inc · Brandon, MSBuilt 1961 · S/N D-6661N661DAHalladay Roy · Erie, COBuilt 1964 · S/N TC-807N661KEBio-Wings LLC · Blue Mountain, MSBuilt 2005 · S/N E-3618N661KQDaybreak Aviation LLC · Wellington, ALS/N TC-2293N661SBLusby Robert G Jr · Knoxville, TNBuilt 1966 · S/N D-8233N662Whitt Sana F III · East Quogue, NYS/N BG-302N6621RRasmussen Paul A · Lakewood, CABuilt 1974 · S/N M-1606N6621SOverbey Michael C · Watkinsville, GABuilt 1976 · S/N D-9845N6623Szostak Edward M · San Diego, CABuilt 1946 · S/N A-295N6624BAdler Inc · Wilmington, DEBuilt 1984 · S/N CE-1034N66251T Air LLC · Bonita Springs, FLBuilt 1979 · S/N M-2178N6625DFox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-203N6625RBeech South LLC · Kalispell, MTBuilt 1982 · S/N D-10395N66265Russo James F · Hilton Head Island, SCBuilt 1979 · S/N ME-207N6626DDrozs Allen P · Decatur, ILBuilt 1979 · S/N M-2179N66272Fox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-216N6627XIsiah 4031 LLC · Quakertown, PABuilt 1979 · S/N ME-215N6628DSummer Air LLC · Greenville, SCBuilt 1979 · S/N MC-672N6628EPhillips Alan K · Junction City, ORBuilt 1979 · S/N M-2181N6628JSiusta Donald W · Bryceville, FLS/N M-2182N6628RD & K Aero · Elkhart, INBuilt 1974 · S/N M-1607
Back to AD 99-05-13 R1 WD