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.

N96BMKm Medico LLC · Murrieta, CABuilt 1986 · S/N E-2297N96CDHisghman Jonathan G II · Bozeman, MTBuilt 1958 · S/N D-5739N96DBDipasquale Vance L · Grand Prairie, TXBuilt 1951 · S/N D-2753N96DWTom Wood Aviation Inc · Fishers, INBuilt 1977 · S/N E-1197N96HFHeritage Asset Leasing LLC · Ronkonkoma, NYBuilt 1978 · S/N ME-30N96HPCzachor Richard J · Sun City Center, FLBuilt 1975 · S/N E-723N96JKKdk Aviation Ltd · Findlay, OHBuilt 1997 · S/N E-3132N96MCW Patrick Enterprises Inc · Wilmington, DEBuilt 1960 · S/N D-6555N96PSZsp Aviation LLC · Crestview, FLBuilt 1978 · S/N E-1426N96PTEidson Mark C · Weatherford, TXBuilt 1976 · S/N TJ-31N96RCSouthern Wings Aircraft Sales Ltd · Bethany, OKBuilt 1980 · S/N MC-652N96VWWheatcroft Andrew D · Dallas, TXS/N E-1189N96WRegistered aircraftBuilt 1971 · S/N D-9269N9700LJet Aviation LLC · Commerce Township, MIBuilt 1971 · S/N MB-506N9704RPrewitt Scott S · King City, CABuilt 1959 · S/N D-6262N9705LDavis James A · Rockledge, FLS/N M-1324N9705QSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1970 · S/N MC-61N9706LMoore Matthew W · Wichita, KSBuilt 1971 · S/N MC-95N9706RParrish Michael W · Granbury, TXBuilt 1959 · S/N D-6249N9707LGriffith Jonathan E · Newark, NJBuilt 1971 · S/N MC-96N9708RGaberdiel Jeffrey M · Lake Butler, FLBuilt 1960 · S/N D-6269N9709QRobles Andres M · Plantation, FLBuilt 1970 · S/N MB-494N9709RVance Marc G · Canal Winchester, OHBuilt 1959 · S/N D-6263N9709YSolo LLC · Hurst, TXBuilt 1963 · S/N D-7119N9710QBluesky A24r LLC · Nashville, TNBuilt 1970 · S/N MC-66N9712RFenoglid John A II · Florence, TXBuilt 1959 · S/N D-6259N9713YEsteban Rioufol Peralta · Houston, TXBuilt 1976 · S/N MC-396N9714LWebaire LLC · Slidell, LABuilt 1971 · S/N MB-510N9714RMichael Dunlevie Pc · Eagle, COBuilt 1959 · S/N D-6266N9714YSanders Jason · Midland, TXBuilt 1963 · S/N D-7120N9715YHill Ronald D · Fort Myers, FLBuilt 1963 · S/N D-7122N9716LOettmeier Bert W Jr Trustee · Leawood, KSBuilt 1971 · S/N MC-98N9716RTracy Scott J · Santa Barbara, CABuilt 1960 · S/N D-6288N9717LLane Timothy J · Ruffin, SCBuilt 1971 · S/N M-1352N9717RSale Reported · Lenoir City, TNSale reportedBuilt 1960 · S/N D-6395N9718LStucky Verne L · Royal Oaks, CABuilt 1971 · S/N MB-511N9718QRedfield Nathan S · Canton, MSBuilt 1971 · S/N MC-73N9719RHughes Alan J · Edison, OHBuilt 1960 · S/N D-6296N9719YRech Ronald P · Woodinville, WABuilt 1963 · S/N D-7121N971PCMaxwell Daniel T · Glenville, PAS/N E-2123N971RBleriot LLC · East Hampton, NYBuilt 1993 · S/N E-2831N971SFSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N TG-83N9720YNation Robert S · Chesterfield, MOS/N D-7124N9721RDeland Air And Sea Brokerage Inc · Deland, FLS/N D-6192N9724LBarlam Theodore P · Poway, CABuilt 1972 · S/N MC-101N9724QRegistered aircraftBuilt 1970 · S/N M-1306N9724RFinley Trevor S · Caddo Mills, TXBuilt 1959 · S/N D-6196N9725LLeading Edge Aviation LLC · Manchester, MOS/N MB-515N9725YButler Donald Steven · Oak Ridge, NCBuilt 1963 · S/N TD-528N9727LWiseman Holdings Group LLC · Clermont, FLBuilt 1971 · S/N MB-521
Back to AD 99-05-13 R1 WD