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.

N21KKLife'S A Beech LLC · Gulf Breeze, FLBuilt 1979 · S/N E-1563N21KMEmbrey Gary L · Georgetown, OHBuilt 1974 · S/N M-1510N21NPRossi Michael · Ronan, MTBuilt 1978 · S/N TK-77N21RCChristopherson Robert J · Provo, UTBuilt 1951 · S/N D-2789N21RW1rw LLC · Mont Vernon, NHBuilt 1967 · S/N TE-360N21SHFlight Less LLC · Helena, MTBuilt 1986 · S/N D-8423N21VMHazard John A · Vero Beach, FLBuilt 1980 · S/N TC-2301N21VRJb Aviation LLC · Baton Rouge, LABuilt 1989 · S/N E-2468N21WPAir Dryden LLC · Dothan, ALBuilt 1972 · S/N E-336N2201LHorizon Enterprises Vne LLC · Aurora, COBuilt 1976 · S/N D-9938N2201UChrisara Investments LLC · Carson City, NVBuilt 1997 · S/N EA-601N2203LForni Robert · Spring Grove, ILBuilt 1976 · S/N CE-669N2205LAerocare LLC · Oak Ridge, TNBuilt 1976 · S/N TE-1083N2207LHautman John M · Oxnard, CABuilt 1976 · S/N E-915N22097Crestair Air LLC · Dover, DEBuilt 1977 · S/N E-1169N22099Falwell James C · Beaufort, NCBuilt 1978 · S/N CE-749N2209LOrth Duane C · San Antonio, TXBuilt 1976 · S/N D-9940N220AAerospace Aviation Services Inc Trustee · Wilmington, DEBuilt 1965 · S/N TC-866N220BXDangberg Dennis · Wayne, NEBuilt 1972 · S/N TC-1462N220DKey Larry Wallace II · Early, TXBuilt 1958 · S/N D-5642N220DSChagrin Valley Biplanes LLC · Chagrin Falls, OHBuilt 1960 · S/N DH-271N220GBryant Tyrone L · Bigfork, MTS/N D-6657N220MWLampert Aviation LLC · Phoenix, AZBuilt 1977 · S/N E-1063N220RPDanzig Peter B · Menlo Park, CABuilt 1988 · S/N E-2438N220VStartz John D · Dallas, TXBuilt 1969 · S/N TC-1235N220WRExecutive Services Inc · Columbus, MSBuilt 1994 · S/N E-2909N2210LStefanov Mark · Georgetown, TXBuilt 1976 · S/N MC-441N2211LKemp John · Lees Summit, MOS/N M-1882N2212LVorel Jeffrey A · Longboat Key, FLBuilt 1976 · S/N MC-442N2215LCasey James Kelton · Galveston, TXBuilt 1977 · S/N M-1868N2217YLehmer Kenneth D Trustee · Pls Vrds Est, CABuilt 1959 · S/N D-6056N2218LEldib Ramsey C · Malibu, CAS/N MB-817N2219LVasiliou Adamos C · Burtonsville, MDBuilt 1976 · S/N M-1880N2219MDubya Aviation LLC · Broken Arrow, OKBuilt 1998 · S/N E3149N221ABFlying Banana LLC · Onsted, MIS/N D-9064N221BDMerrell Jacob Everette · Pace, FLBuilt 1958 · S/N D-5748N221DCAmob1 LLC · Baton Rouge, LABuilt 1980 · S/N E-1689N221HRRota Aviation Consulting LLC · Sutton, AKBuilt 1967 · S/N TG-48N221MRGaluk Douglas P · Wisconsin Rapids, WIS/N E-1576N221NPohl Ronald O · Englewood, COBuilt 1981 · S/N E-1892N221RFFunk Robert D · Tyler, TXBuilt 1964 · S/N D-7307N221TLLogan Thomas D · Incline Village, NVBuilt 1964 · S/N D-7652N221VRSperling Arnold L · Lincoln, MAS/N CE-1105N221WSChaz LLC · Wilmington, DEBuilt 1976 · S/N CE-642N2220LLegitimate Business LLC · Las Vegas, NVS/N MC-445N2224LMeckel Raymond T · Rockport, TXBuilt 1976 · S/N M-1875N2225LBratcher Randy L · Saint Charles, MOBuilt 1977 · S/N MC-449N2226LSlyngstad Todd · San Jose, CABuilt 1999 · S/N EA-640N222ABStanderfer William E · Fort Collins, COBuilt 1973 · S/N TC-1527N222ACMti Holdings Inc · Birmingham, ALBuilt 1977 · S/N E-1125
Back to AD 99-05-13 R1 WD