AD 2007-04-19 R1

Registered aircraft · 108,434

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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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.

N2993YBranch Robert W · Fort Mohave, AZS/N 18253993N2994ADicicco Matthew Trustee · Los Gatos, CABuilt 1953 · S/N 30194N2994ESkyventure Aviation LLC · Battle Creek, MIBuilt 1979 · S/N 17271398N2994R2994r Aircraft Leasing LLC · Spanish Fork, UTBuilt 1969 · S/N 28R-35386N2994TZakraisek Donald S · Sandy, UTBuilt 1967 · S/N 367N2994XBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 17700394N2994ZAir Ads Inc · El Cajon, CABuilt 1959 · S/N 18-7113N29950Nichols William K · Bainbridge, GABuilt 1974 · S/N TC-1760N2995CAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1948 · S/N NAV-4-1727N2995FCj3 Aviation LLC · Idaho Falls, IDBuilt 1966 · S/N 18257095N2995GVincent Frederick D · Searsport, MEBuilt 1967 · S/N 38N2995LS&S Wings And Wheels LLC · Wilmington, DEBuilt 1967 · S/N 670354N2995RAbj Aviation LLC · Montgomery, OHBuilt 1969 · S/N 28R-35387N2996CSutton Aircraft Salvage LLC · Palmer, AKBuilt 1954 · S/N 30896N2996FSmooth Air LLC · Mequon, WIBuilt 1966 · S/N 18257096N2996PHenry Kent B · Prescott, AZBuilt 1955 · S/N 18-4510N2996TSims Barry Don Sr · Canadian, TXBuilt 1967 · S/N 369N2996XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700396N2996YCrowe Timothy P · Gilbert, AZBuilt 1962 · S/N 18253996N29970Andrecheck Cynthia R · Bethel, AKBuilt 1981 · S/N 185-04292N29972Windblown Ranch Inc · Echo, ORBuilt 1981 · S/N 185-04162N2997CSmith Philip W · Copeland, KSBuilt 1955 · S/N 30897N2997GHiemenz Thomas S · Greenwood, INS/N BM-01N2997LStorke Paul E · Laguna Beach, CABuilt 1967 · S/N 670102N2997YSkyriders LLC · Flagstaff, AZBuilt 1962 · S/N 18253997N2997ZHoppner Gina · Fairbanks, AKFirst renewal noticeBuilt 1959 · S/N 18-7122N2998FChristian Halls International · Arlington, TXBuilt 1966 · S/N 18257098N2998KWallingsford Don C · Yorba Linda, CABuilt 1980 · S/N 18053155N2998LJentes Charles A · Smithville, OHS/N 670103N2998MM T Aviation LLC · Grove, OKBuilt 1986 · S/N CE-1097N2998PRosendahl Peter · Anchorage, AKBuilt 1955 · S/N 18-4514N2998TMartony Joseph M · Chandler, AZBuilt 1967 · S/N 371N2998YReynolds Peter · Athol, MABuilt 1962 · S/N 18253998N2999AFindly Raymond Lee · Ravenna, KYBuilt 1953 · S/N 30199N2999CCarnine Daniel L · Seeley Lake, MTBuilt 1954 · S/N 30899N2999LSodt Brian K · Kernersville, NCBuilt 1967 · S/N 670104N2999MLopez Eve · Santa Monica, CABuilt 1985 · S/N CE-1074N2999NGarcia Michael R · Marshall, VABuilt 1986 · S/N CE-1081N2999RMatthews Flying Club LLC · Ogden, UTBuilt 1969 · S/N 28R-35391N2999TAnderson Richard C · Dickson, TNBuilt 1966 · S/N 039N2999XPoore Zack W · Mcdonald, KSBuilt 1967 · S/N 17700399N2999ZGodensun Aero LLC · Sutherlin, ORS/N 382-78N299AGSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2000 · S/N 29-0252N299ARAutry Timothy R · Stedman, NCBuilt 1987 · S/N 299N299BBCornell David A · Wasilla, AKS/N HB1N299BFMacvey Troy R · Milan, INBuilt 1967 · S/N 310L-0093N299BGHarrison Rv Inc · Jefferson, IABuilt 1989 · S/N CE-1366N299BWKornelson Roseann S · EmoNon-citizen corporation, flight hours not reportedBuilt 2000 · S/N 20930N299CAScenic Concepts LLC · La Crosse, WIBuilt 2005 · S/N 2294N299DASybesma Justin T Md · Benton Harbor, MIBuilt 2020 · S/N 40.1229
Back to AD 2007-04-19 R1