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.

N1998LAyala Gerardo · San Antonio, TXBuilt 1976 · S/N M-1854N1999JBeech Boys LLC · Peachtree City, GABuilt 1967 · S/N TE-344N199AAHeide Charles H · Kenosha, WIFirst renewal noticeBuilt 1958 · S/N D-5781N199KMOrloff Kenneth Lee Trustee · Groveland, CABuilt 1979 · S/N D-10243N199PBSkyflite LLC · Hillsboro, ORS/N TJ-137N199RPId Corporation · Shepherd, MTS/N EA-344N19ABYong Andrew · Newnan, GABuilt 1964 · S/N D-7701N19BLEthereal Wings LLC · Tucson, AZS/N P-267N19BMRicks Aviation Inc · Wilmington, DEBuilt 1957 · S/N D-5259N19CAPoulton Bruce A · Fremont, CABuilt 1994 · S/N E-2877N19ESRegistered aircraftBuilt 1980 · S/N TJ-296N19FSCole Properties LLC · Foley, ALBuilt 1983 · S/N TJ-441N19KYChi Yang · Lafayette, COS/N TE-1073N19LLDsr-Cherokee 180 LLC · Dallas, TXBuilt 1970 · S/N E-224N19MAAvco Security Systems Inc · Jupiter, FLBuilt 1966 · S/N D-8173N19MNShields Charles F · Gilberts, ILBuilt 1978 · S/N E-1347N19MTDaviation Inc · Willoughby, OHBuilt 1976 · S/N E798N19NHLaquadra Gregory John · North Liberty, IABuilt 1975 · S/N MB-740N19NTHall Karl A · Colorado Springs, COBuilt 1974 · S/N MB-710N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44N19REEtcheverry Ray L · Bakersfield, CABuilt 1970 · S/N CE-299N19RFLynn Air Flying Club Inc · Woodinville, WABuilt 1974 · S/N E-627N19SASierra Aviation LLC · Hendersonville, TNBuilt 1980 · S/N E-1795N19SLMifflin Enterprises LLC · Mansfield, OHBuilt 1976 · S/N D-9848N19UBas Part Sales LLC · Greeley, COBuilt 1979 · S/N ME-294N19VChoi Mark · Allentown, PABuilt 1977 · S/N E-1107N19WWood Alton K · Bee Spring, KYS/N D-3734N19WCV35a LLC · Beacon, NYBuilt 1969 · S/N D-8998N1AVLeader Nicholas A · Billings, MTBuilt 1962 · S/N TC-366N1AWKoedam Robert E · Saint Louis, MOBuilt 1960 · S/N D-6617N1BDFloyds Aero Inc · Amarillo, TXS/N G-91N1BFRussell Kellum LLC · Saratoga, CABuilt 1973 · S/N TE-961N1BWMbs Ventures Inc · Wilmington, DEBuilt 1977 · S/N D-9963N1CNNothing By Chance LLC · Jackson, WYBuilt 1967 · S/N TE-313N1DJOwyhee Air LLC · Murphy, IDBuilt 1987 · S/N CE-1116N1DNWarren Howard E · Cookeville, TNBuilt 1949 · S/N D-1967N1DUPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1960 · S/N DH-262N1EVGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1979 · S/N E-1463N1FXTl Consulting LLC · Cadiz, KYBuilt 1963 · S/N TC-406N1HBRye-Corp LLC · Lenoir City, TNBuilt 1968 · S/N TC-1069N1KYCatherines Aviation Services LLC · Sewanee, TNBuilt 1968 · S/N CJ-3N1LJN1lj LLC · Edgewood, WABuilt 1950 · S/N D-2537N1LXDix Justin T · South Boston, VABuilt 1973 · S/N E-419N1NMShaffer Thomas F DBA · Somerset, PAS/N D-5211N1NXBirchwood Farms Inc · Hope Mills, NCBuilt 1962 · S/N TD-536N1PHRegistered aircraftBuilt 1983 · S/N CE-1018N1PVMuzny Gregory · Magnolia, TXS/N D-3028N1PZRegistered aircraftBuilt 1972 · S/N TE-890N1QGLos Arboles Management Company LLC · Moriarty, NMBuilt 1966 · S/N D-8328N1RTFrost Darrell G · Atlanta, TXBuilt 1966 · S/N TE-185
Back to AD 99-05-13 R1 WD