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.

N9463QCcf Ventures Inc · Bangor, MEBuilt 1972 · S/N D-9324N9465QMaydew Aircraft LLC · Dallas, TXBuilt 1972 · S/N D-9325N9466HGiles Forrest D · Springtown, TXBuilt 1944 · S/N 6688N9467SV35 LLC · Portland, ORBuilt 1966 · S/N D-8054N9468QSunrise Aviation Inc · Wrangell, AKBuilt 1972 · S/N E-314N946BWhiteside William E · Talmage, CABuilt 1961 · S/N TD-478N946HRPalm Beach Motorsports Transportation Division LLC · Helena, MTS/N P-551N9470HDeer Creek Dusters Inc · Rolling Fork, MSBuilt 1943 · S/N 6670N9470QCullison James B Trustee · Canby, ORBuilt 1972 · S/N D-9327N9471YGeide Orrin E · Hartford, SDBuilt 1961 · S/N D-6648N9472YCoombs Max · Boynton Beach, FLBuilt 1961 · S/N D-6654N9473QStephens Milton D · Birmingham, ALBuilt 1972 · S/N E-315N9474YMeadowlake Airpark LLC · Lenoir City, TNBuilt 1961 · S/N D-6658N9478QWwpc Aviation LLC · Stanley, VABuilt 1972 · S/N TC1431N9478SRocket Pjr LLC · Helena, MTBuilt 1966 · S/N D-8057N9479YLynch Francis X · Dumont, NJBuilt 1961 · S/N D-6652N947GBGreat Lakes Aircraft Inc · Fort Myers, FLBuilt 1975 · S/N P-365N947MTSchweiss Travis · Casper, WYBuilt 1957 · S/N D-4915N947TTobler Patrick M · Wake Forest, NCBuilt 1971 · S/N D-9270N9480QCrockett Richard S · St George, UTBuilt 1972 · S/N CE-370N9481QSterengin Pllc · Cottonwood, AZS/N CE-371N9481YMccoy Group Inc · Portland, ORBuilt 1961 · S/N D-6660N9482QSoberg Bryant W · Hartford, SDS/N E-318N9483QSouthwest Investment Co · Little Rock, ARS/N D-9331N9484YZimmerman Michael P · Verona, WIBuilt 1961 · S/N D-6663N9486YRobbins Donald Lee Jr DBA · Ruston, LABuilt 1961 · S/N TC-49N9487QLebarron David · Winnsboro, TXBuilt 1972 · S/N D-9333N9487SBailey Hugh E · Gainesville, VABuilt 1966 · S/N D-8067N9487YSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1961 · S/N TC-50N9488EV2 Destinations LLC · Cullman, ALBuilt 2000 · S/N E-3367N9489SRoccatani Dante D · Merritt Island, FLBuilt 1966 · S/N TE-79N948TPray Aviation Inc · Augusta, KSFirst renewal noticeBuilt 1964 · S/N TD-600N9491QMcclung Aerial Spraying Inc · Big Springs, NEBuilt 1972 · S/N E-321N9492SBlue Line Aerial Productions LLC · Lexington, KYBuilt 1966 · S/N D-8065N9494SLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1966 · S/N TC-985N9495SLsa LLC · Kalispell, MTBuilt 1966 · S/N D-8068N9497YGreystone Enterprises Inc · Oklahoma City, OKBuilt 1961 · S/N TC-57N9499QE J K LLC · Brawley, CABuilt 1972 · S/N E-323N949BTgt Adventures LLC · Virginia Beach, VABuilt 1962 · S/N D-7003N949BGGabriel Kevin E · Galveston, TXBuilt 1979 · S/N E-1494N949DEMiller Dennis · Denton, TXBuilt 1955 · S/N D-4073N94BWErdman Aviation LLC · Cameron Park, CABuilt 1964 · S/N D-7627N94EMSkyclub A36 LLC · Alpharetta, GABuilt 1982 · S/N E-2011N94HD U Aircraft Leasing Inc · Green Bay, WIS/N A-33N94JKWestwind Aviation Inc · Plantation, FLS/N E-2149N94JVSlikker Benn W · Marana, AZBuilt 1991 · S/N E-2625N94MQBreshan Enterprises LLC · Chicago, ILBuilt 1975 · S/N TE-1060N94PBBaron 94pb LLC · Tuscaloosa, ALBuilt 1979 · S/N TJ-245N94WWZephyr Homes LLC · Sebring, FLBuilt 1981 · S/N E-1817N9501RParker Robert M · Hurst, TXS/N D-6050
Back to AD 99-05-13 R1 WD