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.

N362TBarnett Blake C · Boynton Beach, FLBuilt 1977 · S/N D-10025N362ZKinder Jeffrey · Richland, WABuilt 1960 · S/N D-6522N3630QStar Aviation LLC · Mauston, WIBuilt 1967 · S/N MA-225N3632APauly Adam · Macomb, MIBuilt 1969 · S/N D-9081N3635BPwc Aviation · Pine River, MNBuilt 1954 · S/N CH-79N3635QFantini Real Estate LLC · Louisville, KYBuilt 1967 · S/N MB-246N36363Klein John · Woodland, CABuilt 1975 · S/N D-9748N3636AScull Adam C · Hockessin, DEBuilt 1978 · S/N E-1399N3636TFortier Stanley · Chico, CAS/N EA-18N3638QWinder Keven S · Castle Rock, COBuilt 1967 · S/N MB-251N363BShoal Properties LLC · Bokeelia, FLBuilt 1957 · S/N D-5087N363BCBig Cha Inc · Wilmington, DES/N D-9763N363KBTriple F LLC · Dixon, ILBuilt 1996 · S/N E-3000N363MBCohen Greg · Gaithersburg, MDBuilt 1997 · S/N E-3143N363T1800sky LLC · Henderson, KYBuilt 1963 · S/N TC-416N363ZN363z Flyers LLC · Lenexa, KSBuilt 1960 · S/N D-6526N3640QBenville Pete E Jr · Boonville, CABuilt 1967 · S/N MB-253N3642QPorte Elvis · Miami, FLS/N MB-262N3648QRegistration Pending · Graham, WARegistration pendingBuilt 1967 · S/N MA-233N3649QSteinberg Stephen M · Happy Valley, ORBuilt 1967 · S/N MA-234N364ACWalker Geri G · Carrollton, GABuilt 1998 · S/N E-3148N364BBSocio Aviation Services LLC · Benton, KYBuilt 1999 · S/N E-3240N364BFFlying B Partners LLC · Wichita, KSBuilt 1977 · S/N E-1166N364BGBehrens Julie A · Crested Butte, COS/N E-3559N364DBHirsch Benjamin M · Orange Park, FLBuilt 1995 · S/N E-2963N364DDJd Bonanza LLC · Mesa, AZBuilt 1996 · S/N E3056N364DFBlackley Nathan · Eugene, ORBuilt 1997 · S/N E-3091N364ELFiorini Randy · Turlock, CABuilt 1988 · S/N CE-1268N364GGTddc Ventures LLC · Dublin, CABuilt 1990 · S/N EA-501N364GLLeep Enterprises LLC · Mishawaka, INBuilt 1976 · S/N TC-1983N364HPZadeh Alidad Trustee · El Centro, CABuilt 1973 · S/N E-402N364JBBlazie Marketing Services Inc · Street, MDBuilt 1997 · S/N E-3079N364PJ L Garred Sr Mdpc · Whiting, IABuilt 1995 · S/N EA-578N364SCTfs Inc · Chelsea, ALBuilt 2001 · S/N E-3374N364SSLampert David M · Atherton, CABuilt 1992 · S/N EA-542N364TJohnsons Ag-Air Inc · Tyler, MNBuilt 1962 · S/N D-7045N364TWVo Thien T · Amarillo, TXBuilt 1985 · S/N EA-449N364VKPetts Adam · Waukee, IABuilt 1981 · S/N E-1973N364WPPorter Flying Service · Durham, CAS/N E-1914N3650AMcclain Aviation LLC · Newark, DEBuilt 1969 · S/N D-9077N3652QNolen David S · Wimberley, TXBuilt 1967 · S/N MA-239N3653AKlemenhagen David · Wasilla, AKBuilt 1969 · S/N TC-1309N3653BPlacebo Air LLC · Ridgecrest, CABuilt 1954 · S/N CH-128N3653QFlying Naked Muskteers LLC · Palm City, FLBuilt 1967 · S/N MA-240N36565Maxwell James B · Lewiston, IDBuilt 1968 · S/N TC-1142N3657QFaith Builders Family Church Inc · Rogers, ARBuilt 1968 · S/N M-1136N3658QFrey Andrew F · Kerrville, TXBuilt 1967 · S/N M-1042N365ACEvalidate LLC · Birmingham, MIBuilt 1988 · S/N EA-479N365BMiles Barrington K · Austin, TXBuilt 1957 · S/N D-4995N365HStavair LLC · Gulf Breeze, FLBuilt 1965 · S/N TC-843
Back to AD 99-05-13 R1 WD