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.

N359ERJames Chad · Needville, TXBuilt 1978 · S/N D-10182N359MJSkyway Leasing Inc · Lakeland, FLBuilt 1982 · S/N WA-304N359VBVictor Bravo Aviation LLC · Lincoln Park, NJS/N D-5135N35ABElk River Aero LLC · Noel, MOBuilt 1959 · S/N D-6067N35AUHat Creek Construction & Materials Inc · Burney, CABuilt 1985 · S/N EA-448N35BCjs Aviation LLC · Methuen, MABuilt 1974 · S/N D-9588N35BKNiemi Brian R · Monterey, CABuilt 1964 · S/N D-7685N35BMBecker Lawrence D Md · Anacortes, WABuilt 1970 · S/N D-9191N35BNAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1976 · S/N D-9907N35BTMarconi Properties LLC · Westbrook, CTBuilt 1979 · S/N D-10255N35CGComesa Service Group · Middletown, DEFirst renewal noticeBuilt 1972 · S/N D-9373N35EQualitair LLC Trustee · MichelstadtBuilt 1937 · S/N D-17R-167N35EFFourt Rob · Bentonville, ARBuilt 1949 · S/N D-1964N35EKHaupt Erik · Great Barrington, MABuilt 1979 · S/N D-10238N35ESMurphy Joel · Flowermound, TXBuilt 1965 · S/N D-7918N35EVValiair Limited Co Trustee · Casper, WYBuilt 1954 · S/N D-3752N35FPJohnson Deandre T · Jacksonville, FLS/N D-4831N35GPLimon Hector Jr · Lubbock, TXBuilt 1956 · S/N D-4901N35HVProdigy Aviation LLC · Port Orange, FLBuilt 1957 · S/N D-5236N35JSkybound Shenanigans LLC · Dubuque, IABuilt 1958 · S/N D-5699N35JCRogowski Paul · Dallas, GABuilt 1964 · S/N TC-828N35JGJalu Financial Corp · Gray, GABuilt 1963 · S/N D-7181N35JWN35jw LLC · Enid, OKBuilt 1959 · S/N D-5872N35KAHacker Timothy J · Pangburn, ARBuilt 1979 · S/N D-10231N35KJBunn John Timothy · Winter Garden, FLBuilt 1972 · S/N D-9326N35KWCoy Walter Thomas · Titusville, FLBuilt 1975 · S/N D-9827N35LELyall Enterprises Inc · Pauma Valley, CABuilt 1955 · S/N D-4371N35LFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1976 · S/N D9820N35LGAnderson Charles · Bakersfield, CABuilt 1958 · S/N D-5529N35LVDelta Fox Aviation LLC · Fort Worth, TXBuilt 1969 · S/N D-8900N35MSimmons Dennis L · Wichita, KSBuilt 1970 · S/N D-9143N35MASidetrack Investments LLC · Flower Mound, TXBuilt 1969 · S/N D-8925N35MCWallace James W · Elkins, WVBuilt 1955 · S/N CH-177N35MFFlying Barefoot Ranch LLC · Wilmington, DEBuilt 1980 · S/N D-10304N35MSHazeltine Hugh J · Saint Petersburg, FLBuilt 1964 · S/N D-7637N35MTToft Michael O · Brock, TXBuilt 1966 · S/N D-8338N35MVWeaver Kibwe · Kalamazoo, MIBuilt 1967 · S/N D-8617N35MXMontanez George O · Mesa, AZBuilt 1960 · S/N D-6411N35NBBert John Boyd III · Vero Beach, FLBuilt 1975 · S/N D-9802N35NYPerry Charles E · Aldie, VABuilt 1970 · S/N D-9193N35QTReady Aim Flyer LLC · New Castle, DES/N D-8839N35RBBarnes Roger A · Cheyenne, WYBuilt 1963 · S/N D-7219N35RCG5 Aviation Inc · Englewood, COBuilt 1964 · S/N D-7393N35REDakota Aero Inc · Steamboat Springs, COS/N D-8930N35SHulteen Grant S · Tumwater, WABuilt 1964 · S/N D-7481N35SCCramp Steven J · Cleveland, TXBuilt 1973 · S/N D-9442N35STHess Hendrix · New York, NYBuilt 1951 · S/N D-2936N35TBCencalcom Inc · Santa Barbara, CABuilt 1977 · S/N D-9985N35TDShelton Aviation LLC · Salem, ORBuilt 1993 · S/N EA-555N35TEOusley James Dean Jr · Granbury, TXBuilt 1979 · S/N E-1550
Back to AD 99-05-13 R1 WD