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.

N477WCAllison Medical Solutions LLC · Lumberton, MSBuilt 1977 · S/N E-1065N4780JItzchak Arzt · Sarasota, FLBuilt 1967 · S/N MB-228N4781JWyatt Steven Joseph · Caddo Mills, TXBuilt 1967 · S/N MB-231N4784JSale Reported · Crystal, MNSale reportedBuilt 1967 · S/N MB-220N4784MTigress IV LLC · California, MDBuilt 1978 · S/N TC-2145N4787Vasiloff Lennin N Trustee · Marshallville, OHBuilt 1955 · S/N D-4063N4789JChenault Mitchell Ray · Renton, WABuilt 1967 · S/N MA-209N478SCPetroblend Corp · Mason City, IABuilt 1978 · S/N TC-2190N478TFoster Theresa A · Scurry, TXBuilt 1964 · S/N D-7649N4793JSheco Inc · Aloha, ORBuilt 1967 · S/N MA-199N4794MSky Inc · Council Bluffs, IABuilt 1978 · S/N TC-2142N4796MN4796m LLC · Norridge, ILBuilt 1978 · S/N D-10133N4797JMalnar George A · Tickfaw, LAS/N M-1029N4797MRegistration Pending · Satellite Beach, FLRegistration pendingBuilt 1978 · S/N TC-2146N4799JCampbell Cliff H · Coleman, TXBuilt 1967 · S/N M-1031N479JPHogancamp John M · Lebanon, TNBuilt 1976 · S/N E-801N479KSHaaverson Enterprises Inc · Livermore, CABuilt 1993 · S/N E-2811N47BMDuke Aircraft LLC · Philipsburg, MTBuilt 1976 · S/N P-408N47DB & B Aviation LLC · Evansville, INS/N 289N47GLaunder Brian L · Tulsa, OKBuilt 1957 · S/N BA-289N47JBBean Jackson A · Quinlan, TXBuilt 1998 · S/N E3207N47JTM & M Investments Of Jonesboro LLC · Jonesboro, ARBuilt 1973 · S/N D-9432N47KABroom John F · Sherman, TXBuilt 1974 · S/N E-530N47RTBas Part Sales LLC · Greeley, COBuilt 1997 · S/N E-3142N47TGTan Industries LLC · Wilmington, DEBuilt 1980 · S/N TC-2343N47TJJ & S Aero LLC · Port Washington, NYBuilt 1988 · S/N CE1288N47USTurner Aero LLC · Amelia Island, FLBuilt 1980 · S/N P-543N47WTDoucet Lucius J III · Baton Rouge, LABuilt 1966 · S/N D-8217N480Robins Jack S · Saint Charles, IDBuilt 1943 · S/N 4810N4806JHall Thomas K DBA · Jupiter, FLBuilt 1966 · S/N D-8353N4808JJm Beech V LLC · Winchester, TNBuilt 1966 · S/N D-8324N4809JBenner David G · Prescott, AZBuilt 1966 · S/N D-8321N480ASArizona Air Salvage · Phoenix, AZFirst renewal noticeBuilt 1949 · S/N D-2124N480HKorwel Tomasz W · Cedar Rapids, IABuilt 1967 · S/N D-8569N480JKAugust-Marie Inc · Wilmington, DEBuilt 1997 · S/N E3103N480RBMace William L · Queen Creek, AZS/N D-3237N4810JMiller Wesley J · Silt, COS/N D-8331N4811CPowers Chris · Houston, TXBuilt 1964 · S/N TC-760N4813MCouch Walter J · Patterson, LABuilt 1978 · S/N E-1265N4818FCragg Philip A · Point Roberts, WABuilt 1981 · S/N WA311N481SAerogracia LLC · Heritage Ranch, CABuilt 1970 · S/N D-9094N4823JHaunstein Manfred · Weirsdale, FLBuilt 1966 · S/N D-8337N4828MHodges William T · Andersonville, GABuilt 1978 · S/N E-1269N4831JSiewert Michael H · Columbus, OHBuilt 1966 · S/N D-8335N4831MBoty Aero LLC · Madison, ALBuilt 1978 · S/N E-1273N4835ZCombat Air Museum Inc · Topeka, KSBuilt 1959 · S/N LH185N4839JFlying For Fun LLC · Sunnyvale, TXBuilt 1966 · S/N D-8340N48401Yellow Peril Aero LLC · Richmond, TXS/N 151N48458Peterson Timothy R · Monument, COBuilt 1971 · S/N D-9291N4847JLittle River Corp · Anchorage, AKBuilt 1966 · S/N D-8346
Back to AD 99-05-13 R1 WD