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.

N76MKMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N ME186N76NB12 Parsecs LLC · Manhattan, KSBuilt 1975 · S/N E-791N76NCDonald K Ashley · Bradenton, FLBuilt 1976 · S/N M-1787N76NKNaples Jet Management LLC · Naples, FLS/N ME-334N76NNSale Reported · Middletown, OHSale reported, canceledBuilt 1979 · S/N ME-158N76NSSmith Kurt W · Henderson, NVBuilt 1957 · S/N D-5065N76PTMcmurtrey Michael · Farmington, MNBuilt 1974 · S/N MC228N76RTEmax LLC · Perry, GABuilt 1970 · S/N LB-27N76SBAdams Simmie A · Bealeton, VABuilt 1975 · S/N M-1776N76VAHartzell Propeller Emp Flg Club · Piqua, OHBuilt 1976 · S/N M-1786N7707Warner Jon A · Santa Barbara, CABuilt 1950 · S/N D-2535N770BCacic Aviation Inc · Montello, WIS/N D-1778N770MPPerrin Michael G · Howell, MIBuilt 1977 · S/N CE-713N770PMachin Susan M Trustee · Newport Coast, CABuilt 1975 · S/N E-749N770THoyer Kyle E · Manassas, VABuilt 1972 · S/N D-9396N77100Nodine John · Leicester, NCBuilt 1980 · S/N TE-1184N7712RJerry T And Beverly H Davis Family Lp · Monticello, ARFirst renewal noticeBuilt 1968 · S/N TC-1167N7713RWaggoner Mark B · Fort Worth, TXBuilt 1968 · S/N D-8871N7714RPowell Kenneth Wayne · Ann Arbor, MIBuilt 1969 · S/N D-8956N7715BHinton Steven J · Chino, CABuilt 1968 · S/N TE-540N7715RJames S Adcock III Pa · Fuquay-Varina, NCBuilt 1968 · S/N TC-1165N771BB406 Mountain Air LLC · Bigfork, MTS/N EA619N771HEN771he LLC · Hillsborough, NJBuilt 1986 · S/N E-2325N771MAgs Leasing Services LLC · Shoreview, MNBuilt 1971 · S/N E-293N771MBMathis Alan L · Moultrie, GAS/N M-1851N771RBBogin Robert M · Los Angeles, CABuilt 1964 · S/N D-7737N771TFudge Justin · Karnes City, TXBuilt 1972 · S/N D-9415N771WNJordan Hugh Lowe Jr · Centre, ALBuilt 1965 · S/N TC-883N771YJenney Robert M · Wakefield, MABuilt 1977 · S/N MB-862N7724MFallonair Inc · Huntington, NYBuilt 1985 · S/N E2222N7725RLynn Cain LLC · Augusta, ARBuilt 1968 · S/N TE-644N772BCox Bryan L · Greensboro, NCS/N D-1782N772DMihealsick John C · Spring, TXBuilt 1951 · S/N D-3042N772DBAtb Aviation LLC · Wilmington, DEBuilt 2000 · S/N E-3314N772DDN36be LLC · Wilmington, DEBuilt 1993 · S/N E-2775N772MCayle Jonathan · Rochester, MIBuilt 1979 · S/N EA-14N772MDMary Rabbit LLC · Saratoga, CABuilt 1997 · S/N EA-605N772RMaverick Bills LLC · Wilmington, DEBuilt 1980 · S/N CE-912N7731RWilliams Metal And Machinery LLC · Irvington, ALBuilt 1968 · S/N TE-645N7732RAluzion LLC · Madison, ALBuilt 1968 · S/N CJ-7N7733ADvb Enterprises Inc · Colcord, OKBuilt 1988 · S/N CE-1261N7735RJavelin Banana LLC · Erda, UTBuilt 1968 · S/N CJ-8N7737RPassmore Jay A · Birchwood, TNBuilt 1968 · S/N D-8876N7738RKing Robert B · Sheridan, WYBuilt 1968 · S/N TC-1175N773AGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1960 · S/N HH-130N773MSWild Blue Yonder LLC · Lees Summit, MOBuilt 1973 · S/N CE-472N7740RRegistered aircraftBuilt 1968 · S/N D-8877N7741R41 Romeo LLC · Eatonton, GABuilt 1968 · S/N CJ-10N7747BBrawner Robert M · San Leon, TXBuilt 1959 · S/N D-6181N774BDDavis III Robert F · Longview, TXBuilt 1981 · S/N E-1868
Back to AD 99-05-13 R1 WD