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.

N427KMAviation Advantage LLC · Phoenix, AZBuilt 1974 · S/N TC-1818N427KRDean Michael D · Montrose, CABuilt 2004 · S/N 172S9683N427KSJagged Ridge Imaging LLC · Bainbridge Island, WABuilt 2001 · S/N 21011N427LLForrest Jeffrey H · Bloomfield Hills, MIBuilt 1977 · S/N CE-679N427PWLangford Stephen C · York, SCBuilt 1976 · S/N D-9850N427RAHilty Benjamin D · South Boston, VABuilt 1994 · S/N 0067N427RDHeuerman Jordan Dale · Casey, ILBuilt 1983 · S/N JL-102N427RMWingsleasing LLC · Wichita, KSBuilt 2002 · S/N 2843531N427RSMadden James C · Salt Lake City, UTBuilt 2018 · S/N 667N427SBN16rn LLC · Lakewood, COBuilt 2004 · S/N 70367N427SCJones Jeffrey A · Brooksville, FLBuilt 2010 · S/N 001N427SDBanning Keith K · Helena, MTBuilt 2000 · S/N 24489N427SFN427sf LLC · Lakeview, NCBuilt 1966 · S/N 3410N427TCag Farms Inc · Angier, NCBuilt 1963 · S/N D-7232N427WBColeman Steven R · Fernandina Beach, FLBuilt 1993 · S/N 3234N427WYMayes Neil M · Lovell, WYBuilt 1978 · S/N 18266557N42800Asbury William J · Fresno, CABuilt 1976 · S/N D-9934N42801Aas LLC · Ovid, MIBuilt 1968 · S/N 18259195N42804N42804 LLC · Brush, COBuilt 1968 · S/N 18259196N4280FRt Flyers LLC · Shakopee, MNBuilt 1976 · S/N 28-7790009N4280JWebberley Jason D · Kelso, WABuilt 1967 · S/N 28-22640N4280QHines Thomas J · Amsterdam, NYBuilt 1973 · S/N 18502230N4280SYoung Daniel R · Germantown, TNBuilt 1976 · S/N D-9969N4280ZKamlowsky Scott A · Anchorage, AKBuilt 1967 · S/N 18-8528N42811Harris Patrick · Lincoln, CABuilt 1974 · S/N 28-7415402N42812Skylink Aviation Inc · Florissant, MOBuilt 1974 · S/N 28-7405166N42818Cleveland Jeffrey Allen Trustee · Indian Trail, NCBuilt 1968 · S/N 18259203N4281JLewis Mark · Ozark, ALBuilt 1967 · S/N 28-22641N4281QMcdonald Air Services LLC · Saint Johns, MIBuilt 1971 · S/N 17260181N4281TTheodorakis Alkeviades S · Fort Pierce, FLBuilt 1971 · S/N 28-7225117N42820Cordobesa Aviation LLC · Belgrade, MTBuilt 1968 · S/N 18259204N42823Acs Products Co · Lake Havasu City, AZBuilt 1968 · S/N 18259205N42826Aero Elite Inc · Wilmington, DEBuilt 1968 · S/N 18259208N4282JDill Tharold J Jr · Boron, CABuilt 1967 · S/N 28-22643N4282PAero Tramp Holdings LLC · Dallas, TXBuilt 1999 · S/N E-3282N4282QShirley Walter Allen · Bullhead City, AZBuilt 1971 · S/N 17260182N4282SGoerzen John P · Goessel, KSBuilt 1976 · S/N E-946N4282THudson John P III · Grapeland, TXS/N 28-7225119N42831Shuff James S II · Victor, WVBuilt 1968 · S/N 18259209N4283JBennett Tim M · Cambridge, OHBuilt 1967 · S/N 28-22645N4283SHayes Timothy · Gray, MEBuilt 1974 · S/N 17263748N4283TDziak Chester · Jackson, MIBuilt 1971 · S/N 28-7225120N4283ZHuseby Kelly E · Hulett, WYBuilt 1967 · S/N 18-8530N4284Clements Eric C · Sheridan, WYBuilt 1965 · S/N 24-4284N42849Moonrise Soaring Inc · Wilmington, DEBuilt 1968 · S/N 18259213N4284KHornblower Paul S · Chilmark, MABuilt 1948 · S/N NAV-4-1284N4284PEmpire Aviators LLC · Long Island City, NYS/N 17264088N4284TOsborne Thomas A · Bloomington, INBuilt 1971 · S/N 28-7205130N4284ZBolin Matthew R · Everett, WABuilt 1967 · S/N 18-8532N42851Emmons Steven · Russellville, ARBuilt 1968 · S/N 18259214
Back to AD 2007-04-19 R1