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.

N2736PBeard Jared · Fallon, NVBuilt 1955 · S/N 22-3043N2736QBachich George A · Napa, CABuilt 1967 · S/N 18257936N2736SVmc Development Inc · Sanger, TXBuilt 2020 · S/N 81921N2736TM & N Leasing Co · Marietta, GAS/N D-8458N2736WMcnamara Jeffrey E Trustee · Riverside, CABuilt 1966 · S/N 1036N2736XMehling Michael R · Fairview, MTBuilt 1965 · S/N 18051536N2737AKnight Farms Inc · Pasco, WABuilt 1969 · S/N E-175N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643N2737KFanazick Joseph P · Juneau, AKBuilt 1979 · S/N 18053051N2737XFly-By Aviation Services LLC · Colorado Springs, COBuilt 1965 · S/N 18051537N2738BSonrise Aviation LLC · Portland, INBuilt 1979 · S/N 310R1828N2738TProtac Aviation LLC · Highland, CAFirst renewal noticeBuilt 1967 · S/N TD-693N2738WMead James R · Jonesboro, ARFirst renewal noticeBuilt 1966 · S/N 260N2739CLge Flying Club Inc · Marietta, GABuilt 1978 · S/N R18200223N2739GSwanson Gordon · Prescott, AZS/N 52039N2739RPerrong Andrew R · Huntingdon Valley, PABuilt 1969 · S/N 28R-35279N2739TPickering Kevin P · Lakeland, TNBuilt 1967 · S/N D-8457N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344N2739XSvoboda Realty Inc · Bucyrus, KSFirst renewal noticeBuilt 1965 · S/N 18051539N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321N273BGates Hiram P · Faribault, MNBuilt 1959 · S/N 131N273BBBrenthel Industries LLC · Helena, MTBuilt 2025 · S/N 14920N273BTN273bt Air LLC · Sweetser, INBuilt 1979 · S/N 27-7954112N273CAN273ca LLC · Tulsa, OKBuilt 2012 · S/N 13403N273CBGause Timothy L · Georgetown, SCBuilt 1953 · S/N G-72N273CCRegenald Michaud Aviation LLC · Willows, CABuilt 2001 · S/N 9920CCN273CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282354N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018N273JTros Corp · Wilmington, DEBuilt 2017 · S/N 1211N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732N273METopel Holdings LLC · Scottsdale, AZBuilt 2000 · S/N T20608217N273NDPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 28-42073N273PSBlack James F · Sister Bay, WIBuilt 1972 · S/N CE-379N273QTrident Aircraft Leasing LLC · Easton, MDBuilt 1966 · S/N TC-1020N273RRJet Set Aircraft Inc · Van Nuys, CABuilt 1965 · S/N 27-3020N273SState Of Alaska Department Of Public Safety · Anchorage, AKBuilt 2018 · S/N 14283N273SBAero White LLC · Wheat Ridge, COBuilt 1997 · S/N 1615N273SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4243N2740AMcdaniel Joseph Stewart II · Henderson, TXS/N D-10113N2740RRegistration Pending · Wilmington, DERegistration pendingS/N 28R-35280N2740TKraybill Paul D · Portola Valley, CABuilt 1979 · S/N 310R1843N2740WBakewell Keith · Independence, LABuilt 1966 · S/N 1038N2741HEaa Aviation Foundation Inc · Oshkosh, WIBuilt 2014 · S/N 81180N2741WEdison Robert J · Anchorage, AKBuilt 1966 · S/N 1039N2741YCoelum LLC · Lake Mary, FLBuilt 1958 · S/N TD-94N27423Kadrmas Arnold E · Lewiston, IDBuilt 1977 · S/N 31-7752173N2742DLloyd Land Plane III LLC · Brighton, COBuilt 1952 · S/N 25284N2742HWilbert John W III · Plaquemine, LABuilt 1979 · S/N 340A0929N2742QKibler James · Indialantic, FLBuilt 1967 · S/N 18257942
Back to AD 2007-04-19 R1