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.

N5VThompson James A · Fleming Island, FLBuilt 1969 · S/N D-8914N5VBCustom Fire Apparatus Inc · Osceola, WIBuilt 1980 · S/N TE-1179N5VLLange Vladimir · Santa Ana, CABuilt 1979 · S/N D-10223N5WADenver Timothy Arthur · Gardnerville, NVBuilt 1973 · S/N TE-903N5WENeilson Grant R · Richmond Hill, GABuilt 1976 · S/N TC-1981N5WFMociva Inc · Del Mar, CABuilt 1994 · S/N E-2892N5WLLuke Wagler Services LLC · Pryor, OKS/N D-4754N5WMMerrell Warren · Idalou, TXBuilt 1975 · S/N E-649N5XEMacleod Edward N · Trenton, MEBuilt 1979 · S/N MC-699N5XLLove John R · Sutton, MABuilt 1972 · S/N D-9334N5YBFrasier Samuel R · Gainesville, FLS/N TC-952N60003Faucette Douglas R · Fallon, NVBuilt 1978 · S/N M-2110N60007Haynes Kevin Wayne · Pompano Beach, FLS/N MC-629N6000BYahner William P · Central Square, NYBuilt 1978 · S/N M-2108N6000EWennersten Donald A · Ann Arbor, MIBuilt 1962 · S/N D-6996N6000MValiair Limited Co Trustee · Casper, WYBuilt 1965 · S/N BA-727N6001EPhillips Bruce D · Vashon, WABuilt 1959 · S/N D-6000N6001F2120 Limited LLC · Flushing, MIBuilt 1965 · S/N D-7794N6001HHolmes Robert · Pittsgrove, NJBuilt 1978 · S/N MC-630N6001KAllred Warren D · Marshfield, MOBuilt 1979 · S/N WA-25N6001RSorbi Aviation Inc · El Cajon, CABuilt 1978 · S/N ME-118N6001VNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N M-2112N6001YPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N ME-119N60021Jawn Air LLC · Pine Brook, NJBuilt 1979 · S/N MC-635N60027Young Jason H · Gainesville, VABuilt 1979 · S/N M-2114N6002CChristiansen Aviation LLC · Wilmington, DEBuilt 1978 · S/N ME-120N6002KJet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N ME-122N6002LBadawi Aviation LLC · Orlando, FLBuilt 1978 · S/N ME-123N6002MDisilvestro Steven G · Wallkill, NYBuilt 1978 · S/N MC-633N6002SSouthern Adventures Inc · Stuart, FLBuilt 1979 · S/N M-2115N6003CMiles Darren · Bonita Springs, FLBuilt 1979 · S/N M-2113N6003EFrehner Nathan · Roosevelt, UTBuilt 1959 · S/N D-5911N6003RRemikin I LLC · Naperville, ILS/N ME-126N6003YAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-129N6003ZPetranek John A · Mandeville, LAS/N M-2118N6004WDorr Martin E · Strongsville, OHBuilt 1978 · S/N M-2121N6005EMakiyama Todd · San Ramon, CAS/N D5927N6005ZMarstall Nancy T · Asheville, NCBuilt 1978 · S/N M-2127N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133N6006ESchoenau Michael W · Tulare, CABuilt 1959 · S/N D-5909N6006LThree Sheets To The Wind LLC · Chandler, AZBuilt 1979 · S/N MC-640N6007EOboa Enterprises LLC · Edmond, OKBuilt 1959 · S/N D-5915N6007FMobley Barbara Alice · Kathleen, GABuilt 1979 · S/N WA-4N6007TMinton Richard D · Longville, LABuilt 1979 · S/N WA-5N6007YAudubon Air Of Louisiana LLC · Bossier City, LABuilt 1978 · S/N M-2130N60083Kocik William J Jr · Shepherdstown, WVBuilt 1978 · S/N M-2083N60086Echo Bravo LLC · Helena, MTBuilt 1978 · S/N MC-617N6008DChristopher D Bock · Fishers, INBuilt 1979 · S/N MC-611N6008FShared 08f Inc · Pensacola Beach, FLBuilt 1965 · S/N D-7798N6008KShore Stephen · Longview, TXBuilt 1981 · S/N M-2086
Back to AD 99-05-13 R1 WD