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.

N723BBell Bruce B · Lubbock, TXBuilt 1948 · S/N D-1730N723DBRegistered aircraftBuilt 1966 · S/N TC-1019N723JCMckean Sherry · Wildorado, TXFirst renewal noticeBuilt 1977 · S/N E-1202N723MBTerra Air LLC · Flippin, ARBuilt 1972 · S/N TE-856N723SSmaltz David I · Newmanstown, PAS/N M-1384N7241BBingham John Christopher · Lake Lotawana, MOBuilt 1958 · S/N D-5597N72426Becker Emil J III Trustee · Overland Park, KSBuilt 1985 · S/N E-2256N7243ABc Express LLC · Santa Barbara, CAS/N TJ-494N7243CBlalock Jefrey A · Mckinney, TXBuilt 1985 · S/N CE-1066N7243ESlaughter Sean R · Post Falls, IDBuilt 1973 · S/N E421N7243MExcalibur Funding LLC · Thayer, MOBuilt 1986 · S/N E-2326N7243XC&S Manufacturing Corporation · Sturgeon Bay, WIBuilt 1986 · S/N E-2335N7244BRech Jack R · Diamond Bar, CABuilt 1958 · S/N D-5612N7244HLamura Anthony C · Cedar Grove, NJBuilt 1984 · S/N CE-1038N7244LFramalin Leonard · Troy, MIBuilt 1985 · S/N E-2260N7244ZPet Centers Of America Pa · Hickory, NCBuilt 1985 · S/N E-2264N72452B & R Farms · Lake Village, ARBuilt 1985 · S/N CE-1067N72453Ranchers Investments Inc · Graham, TXBuilt 1985 · S/N E-2265N7246AJames Dean Brant · Irvine, CABuilt 1985 · S/N CE-1068N7246ZSilverman Phillip E Trustee · Fullerton, CABuilt 1985 · S/N E-2266N7247HCharter 4 LLC · Clintwood, VABuilt 1985 · S/N E-2294N7248BSweeney James A · Ocala, FLBuilt 1958 · S/N D-5584N7248WDen Eric Air LLC · Clinton Township, MIBuilt 1985 · S/N E-2275N7249BBlack James A · Las Vegas, NVBuilt 1958 · S/N D-5577N724BBSend North · Anchorage, AKBuilt 1998 · S/N E-3151N724BDEdelson David · New York, NYBuilt 1980 · S/N TJ-266N724BHSchwartz Mark Trustee · Shingle Springs, CABuilt 1968 · S/N TE-599N724LWBaggerly Steven C · Sulphur, OKBuilt 2000 · S/N E3327N724MCachorro Cattle Co · Granbury, TXBuilt 1962 · S/N D-7006N724MJSend North · Anchorage, AKBuilt 1990 · S/N E-2567N724PFSmith Randall W · Cumming, GABuilt 1979 · S/N MC-700N724RKChasing Ace LLC · Cresson, TXBuilt 1981 · S/N P-583N724SN724s LLC · Bloomsdale, MOBuilt 1962 · S/N D-7004N72505Henderson Deborah R · Palo Pinto, TXBuilt 1986 · S/N CE-1076N7250BBaird William B · Aurora, ILBuilt 1958 · S/N D-5586N7250REsquenazi Jerry · Senoia, GABuilt 1974 · S/N CE-548N7251RUtay Arthur W · South Windsor, CTBuilt 1974 · S/N CE-549N7251YSchultheis Jon S · Carmel, CABuilt 1985 · S/N E-2277N7252RPeebles Sean Anthony · Conroe, TXBuilt 1974 · S/N E-625N7252TSeaman Kenny J · Edgewood, TXBuilt 1985 · S/N E-2261N7253BWateractive43 LLC · Auburn, CAS/N D-5583N7254EJefferson State Aviation LLC · Aptos, CABuilt 1987 · S/N CE-1103N7254TKing Up LLC · Brookhaven, GABuilt 1985 · S/N CE-1065N7255SWegener Flying Services LLC · Indialantic, FLBuilt 1984 · S/N E-2192N72567Hart Patrick D · Woodbridge, VABuilt 1985 · S/N E-2280N7256ANorthwoods Airlifeline Ltd · Kingsford, MIBuilt 1985 · S/N E-2257N7257BBlack Diamond Real Estate · Roseville, CABuilt 1986 · S/N E-2299N72588Seidel Roland · Azle, TXBuilt 1963 · S/N TD-532N7258ESchreher Jeremy A · Richmond, VABuilt 1986 · S/N EA-455N7259RAmburgey Gregory B Trustee · Rawson, OHBuilt 1974 · S/N E-628
Back to AD 99-05-13 R1 WD