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.

N24BKN24bk LLC · Jupiter, FLBuilt 1977 · S/N E-1145N24DHJohnson Dean Scott · Chanhassen, MNBuilt 1979 · S/N P-515N24GHWilliams Mitchell L · Chickasha, OKBuilt 1963 · S/N TC-404N24GMFive X Five Flight Inc · The Woodlands, TXBuilt 1981 · S/N ME-395N24HFHangarwise Management LLC · Albuquerque, NMBuilt 1982 · S/N CE-999N24HLLederer Henry A IV · Riderwood, MDBuilt 1976 · S/N CE-660N24JVVan Blarcom John C II · Highland, CABuilt 1972 · S/N D-9337N24KHMoffett Jules M DBA · Elmore, ALBuilt 1974 · S/N TE-996N24LSickels Henry C · El Cajon, CABuilt 1964 · S/N D-7503N24LCFirst Eclipse Ltd · Richmond, VABuilt 1977 · S/N MC-540N24LDAri Ben Aviator Inc · Fort Pierce, FLBuilt 1979 · S/N MC-623N24LKPrime Rib Aviation LLC · Nowata, OKBuilt 1980 · S/N E-1744N24MAMarsh Glen R · Williamson, GABuilt 1972 · S/N TC-1435N24NTrewhitt Douglas G · Camarillo, CAS/N EA-693N24PDRobertson Chad W · Hubbard, ORBuilt 1976 · S/N MC-411N24PQBlackburn Joseph E Jr · Richmond, VABuilt 1974 · S/N MC-227N24RAGrass Peter T · Hampstead, NCBuilt 1989 · S/N CE-1379N24RCJeanes Guy R · Lampe, MOBuilt 1974 · S/N TE-994N24RMTittlemier Warren L · Ventura, CABuilt 1959 · S/N D-5805N24WKCannizzaro Charles DBA · North Syracuse, NYBuilt 1967 · S/N D-8431N24YHoge Aviation LLC · Pipersville, PAS/N BA-301N2501WSolari Peter L · Lebanon, CTBuilt 1973 · S/N MC-155N2506WHeiss William R · Watkins, COS/N MC-165N2507WHoffman Ray Y · Elysburg, PARegistration revokedBuilt 1973 · S/N MC-190N2508WBas Part Sales LLC · Greeley, COS/N MC-166N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91N250GWasalo And Luby Air LLC · La Fayette, GABuilt 1967 · S/N D-8600N250MPray Aviation Inc · Augusta, KSS/N TD-625N250MLAlpha Aero Repair LLC · Dousman, WIBuilt 1973 · S/N CE-475N250MMMone Forwarding Lc · Laredo, TXBuilt 1980 · S/N TJ-261N250TCGroth William B · Hixson, TNBuilt 1969 · S/N D-9048N2511WArcher Ht LLC · Noblesville, INBuilt 1973 · S/N MC-172N2512WMonroe Judy L · Keller, TXBuilt 1973 · S/N MC-174N2513WDaniel Raymond C III · Newborn, GABuilt 1973 · S/N MC-171N2514WFalandys David L · Port Orange, FLBuilt 1973 · S/N MC-178N2515WRegistered aircraftS/N MC-187N2516W4 C'S Aviation LLC · Larose, LABuilt 1973 · S/N MC-188N2519WWilliam Rainey Harper College District 512 · Palatine, ILS/N MC-194N251KNeenah Classic Aircraft LLC · Neenah, WIBuilt 1956 · S/N BA-170N2524WAerowave Aviation LLC · Noblesville, INBuilt 1973 · S/N MC-196N252DPDream Flite LLC · Sarasota, FLBuilt 1973 · S/N TE-932N252VKirschner Joel Trustee · Burbank, CABuilt 1971 · S/N CE-321N2531UClyde Shields Entomological Service · Brawley, CAS/N E-2301N2532WFrontier Flyers LLC · Anchorage, AKBuilt 1974 · S/N MC-207N2533WH&A Aircraft Services LLC · Omaha, ARBuilt 1973 · S/N MC-208N2534WFreds Legacy LLC · Chagrin Falls, OHBuilt 1974 · S/N MC-214N2538WBeach Eric J · Middletown, NYBuilt 1974 · S/N MC-215N2539WZavala David · Demorest, GABuilt 1974 · S/N MC-219N253KTInternational Air Services Inc Trustee · Carson City, NVBuilt 1984 · S/N E2200N253RLArs Automation Design Inc · Greensboro, NCBuilt 1980 · S/N EA-131
Back to AD 99-05-13 R1 WD