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.

N64609Sr Aviation LLC · Pocola, OKBuilt 1982 · S/N E-2055N6464APerry Scott · Flower Mound, TXBuilt 1982 · S/N EA-330N6465GD Luckie LLC · Kalispell, MTBuilt 1982 · S/N EA-305N6467NDa Vinci Aero LLC · Lake Ozark, MOBuilt 1982 · S/N EA-310N6467XScottfree Aviation LLC · West Palm Beach, FLBuilt 1982 · S/N E-2056N646QPatrick Robert T · Dothan, ALBuilt 1959 · S/N D-5841N646TTango Charlie LLC · San Leon, TXBuilt 1974 · S/N TE-981N6476ZVorlop Robert W · Delray Beach, FLBuilt 1982 · S/N EA-311N64793N64793 LLC · Naples, FLBuilt 1982 · S/N E-2057N647DKSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1967 · S/N D-8583N647VSparkman Joan F · Murrieta, CABuilt 1960 · S/N D-6280N64840Carter Thomas E · Ocala, FLBuilt 1982 · S/N MC-781N6484L6484l LLC · Denver, COBuilt 1982 · S/N EA-313N6486NTennessee Aviation Co LLC · Knoxville, TNBuilt 1982 · S/N CE-1007N648DAmberican Aviation Inc · Grand Forks, NDBuilt 1951 · S/N D-2977N648DCSomerset Regional Water Resources · Friedens, PAS/N LD-351N648JRStreamline Aviation LLC · Henderson, NVBuilt 1977 · S/N E-1070N648QWarfield Wilbur L · Chambersburg, PABuilt 1959 · S/N D-5879N648VKuitems Philip P · Mt Juliet, TNBuilt 1960 · S/N TD-340N6496NFisher Ranch Corporation · Blythe, CABuilt 1982 · S/N EA-314N6499CLux David J · Lamoure, NDBuilt 1956 · S/N D-2911N649BSpirit Engineering Inc · Grand Junction, COBuilt 1948 · S/N A-454N649LCSmith Aviation LLC · Sitka, AKBuilt 1980 · S/N TJ-304N64AHFlying Machines LLC · Grand Ledge, MIBuilt 1982 · S/N P-594N64BTSunflower Enterprises Inc · Dubuque, IAS/N CE-1152N64BWSkyjams Holdings LLC · Las Vegas, NVBuilt 1975 · S/N E-656N64CGRobinson James D · Spearfish, SDBuilt 1964 · S/N D-7674N64EJLws Flight Service LLC · Lewiston, IDBuilt 1974 · S/N P-288N64ELPridemore Michael R · Newport, MIBuilt 1969 · S/N M-1183N64JWWeaver Joseph Daniel Trustee · Flower Mound, TXBuilt 1957 · S/N D-5014N64KCWise Joe · Kilgore, TXS/N TC106N64PFW & L Consultants Inc · Dunn, NCS/N E-3452N64PHConklin Diana J · Kirksville, MOBuilt 1964 · S/N D-7496N64PKTom Eaton Consulting LLC · West Sacramento, CABuilt 1964 · S/N D-7526N64RESanocki Erika D · Phoenix, AZBuilt 1964 · S/N D-7670N64RPCoe Administrators LLC · Oshkosh, WIBuilt 1978 · S/N TJ-169N64VTBonanza Aviation LLC · San Antonio, TXBuilt 1964 · S/N D-7640N64ZLewis Timothy W · Thousand Palms, CABuilt 1976 · S/N E-918N6500Standard Equipment Leasing And Sales LLC · Wilmington, DEBuilt 1967 · S/N TE-500N6501RAbove Earth Aerospace LLC · Friendswood, TXBuilt 1974 · S/N M-1537N6502RSmith Duane · Felt, OKBuilt 1974 · S/N MC-259N6504RJohn M Peters · Damascus, MDBuilt 1974 · S/N MB-716N6507RJoachim Peter · Grafton, WIBuilt 1974 · S/N MB-724N6507VBrown Steven K · Tucson, AZBuilt 1982 · S/N EA-309N6508RSterling Creek LLC · Brookings, SDBuilt 1974 · S/N M-1583N6508VBest John K · Cave Creek, AZBuilt 1982 · S/N CE-1008N6509RHolzhauer Aviation Corp · Middletown, DEBuilt 1974 · S/N M-1584N650BAsher Mitchell · Senoia, GABuilt 1957 · S/N D-5100N650PVSokolowski Paul W · Bedford, PABuilt 1967 · S/N TE-427N650QSniezek Daniel E · Phoenix, AZBuilt 1958 · S/N D-5796
Back to AD 99-05-13 R1 WD