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.

N5429FQuick Kenneth C Jr · Burke, VABuilt 1976 · S/N 28-7790119N5429LGardner T Larry · Dickson, TNS/N AA5-0502N5429PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 24-483N5429WLafontaine Generator Exchange Inc · La Fontaine, INBuilt 1962 · S/N 28-501N542APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843762N542CGulf States Financial Services · Lafayette, LAS/N 21063919N542CDStorch David · Goodyear, AZBuilt 2004 · S/N 1186N542CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881051N542DSFox James R DBA · Saint Paul, MNBuilt 1966 · S/N D-8048N542EClegg Edward T · Standish, MEBuilt 2008 · S/N 82179N542EBSvoboda Erik S · Mentor, OHBuilt 1981 · S/N 21064351N542ECWang Warner Weihsu · Vienna, WVBuilt 2005 · S/N 18281691N542EMRw Air LLC · Boerne, TXBuilt 1980 · S/N P21000581N542EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12872N542FCooper Nina · Lake Elmo, MNBuilt 2022 · S/N 542N542FLHaffey George F · Fernandina Beach, FLBuilt 1971 · S/N 28-7125374N542GAtlantic Helicopters International Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1994 · S/N 2459MN542HGraham Jack D · Hamilton, TXBuilt 1976 · S/N 343N542HFPars Avn Corp · Wilmington, DEBuilt 1974 · S/N 28R-7435310N542JJAlf Ix LLC · Chicago, ILBuilt 2022 · S/N 4496542N542JPGrauer Keaton · Marysville, KSBuilt 1968 · S/N 28R-30772N542JVBeaubien Matthew L · Sacramento, CABuilt 1999 · S/N 1450N542KAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843866N542KSKent State University · Stow, OHBuilt 2025 · S/N 172S13367N542MADaystar Aviation LLC · Orange Park, FLS/N 28-7816364N542MJRegistration Pending · Helena, MTRegistration pendingS/N 5511N542MNKeeler Aviation LLC · Plattsmouth, NEFirst renewal noticeBuilt 1976 · S/N 340A0109N542PUNewbridge Unlimited LLC · Sunny Isles Beach, FLBuilt 2003 · S/N 2844099N542RTVerkaik Michael S · Oakdale, CABuilt 2022 · S/N 83342N542SWHardy Tracy G · Tucson, AZBuilt 1978 · S/N 18266661N542THoel Erik Gerhard · Redlands, CABuilt 1961 · S/N D-6718N542THNorthern Cowboy Holdings LLC · Prior Lake, MNBuilt 2019 · S/N 172S12253N542WN542w LLC · Baton Rouge, LABuilt 1975 · S/N 32-7540102N54306Aiken Patrick J · West Greenwich, RIBuilt 1981 · S/N 17274951N5430AAdams Hay Farms LLC · Cedar City, UTBuilt 1979 · S/N 21063433N5430DClark Stephen N · Walnut Cove, NCBuilt 1957 · S/N D-4945N5430FUnion Aviation LLC · El Dorado, ARBuilt 1976 · S/N 28-7790120N5430LKanarick Justin · Colleyville, TXBuilt 1973 · S/N AA5-0330N5430MAmi Aviation Inc · Monroe, NYBuilt 1978 · S/N MC-573N5430PHeight David B · El Prado, NMBuilt 1958 · S/N 24-484N5430WAnderson Douglas S · Gansevoort, NYS/N 28-503N54311Daniel Earl F · Ashland, KYBuilt 1981 · S/N 17274952N54319Jones Roddy H · Thomasville, GABuilt 1981 · S/N 17274954N5431BRi Skydiving Aircraft LLC · Middletown, RIBuilt 1956 · S/N 33431N5431UBrown David G · Knoxville, TNBuilt 1967 · S/N D-8515N5431WBig Daddys Casino Inc · Huntington, WVBuilt 1962 · S/N 28-506N54322Myers Robert E · Sperry, OKBuilt 1981 · S/N 17274956N54324T2xb LLC · Valdosta, GABuilt 1981 · S/N 17274958N5432BDixon Charles W · Brookhaven, MSBuilt 1956 · S/N 33432N5432EMilwaukee Aero LLC · Milwaukee, WIBuilt 1978 · S/N 17271860
Back to AD 2007-04-19 R1