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.

N1886W86 Whiskey Corporation · Vineland, NJBuilt 1973 · S/N E-441N18874Registration Pending · Pantego, NCRegistration pendingBuilt 1977 · S/N MC-518N1887LEllin Roger E Jr · Naples, FLBuilt 1976 · S/N P-388N18887Clifford Royce Ellen · Leucadia, CABuilt 1977 · S/N MC-519N18888Symosko Stephen · Oakdale, PABuilt 1977 · S/N MB-858N18895Jmetic Consulting LLC · Springs, TXBuilt 1977 · S/N M-1963N1889DKish James D · Centennial, COBuilt 1952 · S/N D-3161N188BHJetspeed Solutions LLC · Middletown, DEBuilt 1980 · S/N P-526N188BSSmith Brenda S · Livingston, TXBuilt 1977 · S/N MB-873N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189N188RJWilliams Debbie C · Riverside, CABuilt 1963 · S/N D-7205N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67N188YMbaa Holding LLC · Myrtle Beach, SCBuilt 1964 · S/N TC-790N18909Thomas William Tyler · Athens, TNBuilt 1977 · S/N MC-524N1890DBrott Edwin T · Cincinnati, OHBuilt 1952 · S/N D-3173N18918Edc Aviation LLC · Middletown, RIBuilt 1977 · S/N M-1964N1891DDale Richard C · La Vernia, TXS/N D-3163N1891WSchwartz Eric · Timnath, COBuilt 1973 · S/N E-440N18920N18920 LLC · North Canton, OHBuilt 1977 · S/N M-1967N18924Swanson Jackson Van Dorn · Gustavus, AKBuilt 1977 · S/N M-1969N18928Kokkinos Antonios H · Naples, FLBuilt 1977 · S/N M-1966N18929Vector Aviation LLC · Mentor, OHBuilt 1978 · S/N ME-6N1892DLong Jory J · Lake Ozark, MOBuilt 1952 · S/N D-3164N1892LMcnair Craig · Dayton, TXBuilt 1976 · S/N D-9897N18930Trustgroup Aircraft Hangar Sales LLC · Metairie, LABuilt 1977 · S/N MC-527N18932Weber Brandon P · Otsego, MIBuilt 1977 · S/N MB-863N18934Gray Van D · Woodway, TXBuilt 1977 · S/N MC-530N18938Hangar 5 LLC · Williamsburg, VABuilt 1977 · S/N MC-531N1893LHarlan Blake · Trinity Center, CABuilt 1976 · S/N E-863N18940Mella Aviation LLC · Tucson, AZBuilt 1977 · S/N MC-532N18941N18941 LLC · Boynton Beach, FLBuilt 1978 · S/N ME-8N18947Federer Joe E · Crane Hill, ALBuilt 1977 · S/N MB-864N18948Page Don S · Norwood, NCBuilt 1977 · S/N M-1978N1894DAiken Wayne B Jr · Greenville, SCBuilt 1952 · S/N D-3166N18950Osgood James G · Columbia, MOBuilt 1977 · S/N MC-535N18951Evans Lynn · Vici, OKBuilt 1977 · S/N MC-536N18956Hanig Kraig K · Merrill, WIBuilt 1977 · S/N MB-867N18959Rushton Damion · Ellenwood, GABuilt 1977 · S/N MC-539N18962De Plane LLC · Merrill, WIBuilt 1977 · S/N M-1982N18963Ross James R · Nampa, IDBuilt 1977 · S/N M-1984N18966Big Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-869N18968Budde Michael D · Claremore, OKBuilt 1978 · S/N M-1986N1896DBrabender Michael R · Montevideo, MNBuilt 1952 · S/N D-3168N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16N18970Wheatley Consulting LLC · Picayune, MSBuilt 1977 · S/N M-1988N18972Kroll Kenneth M · Counce, TNBuilt 1977 · S/N MB-868N18974Carbon County Oncology Management Inc · Auburn, PABuilt 1977 · S/N MC-542N18977Taylor Michael D · Fountain Inn, SCBuilt 1977 · S/N M-1990N1897EThompson Loren Charles · Arlington, VABuilt 1966 · S/N D-8313N1897LHrt Aviation LLC · Southlake, TXBuilt 1976 · S/N TC-1971
Back to AD 99-05-13 R1 WD