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.

N3187UMillikan Kimball S · Honolulu, HIBuilt 1963 · S/N 18254587N3187WG S Aviation Inc · Stilwell, KSBuilt 1974 · S/N TH-428N3187YMiller Richard G · Anson, TXS/N 18254187N3187ZRucks Chad W · Okeechobee, FLBuilt 1996 · S/N 18022CN31885It Is Well · Kennett, MOBuilt 1978 · S/N 32-7840152N3188NMhr44 LLC · Queen Creek, AZBuilt 2007 · S/N 11575N3188QLutz Paul A Trustee · Seville, OHBuilt 1967 · S/N 18258188N3188SCrossman Charles · Rusk, TXBuilt 1964 · S/N 18255688N3188TRucinski Edward A · Climax, NCS/N 17700488N3188UAsb Avionics LLC · Mojave, CABuilt 1963 · S/N 18254588N3188YIngram Patrick Joseph · Pinedale, WYS/N 18254188N3189CSmith David J · Duluth, MNBuilt 1954 · S/N 30988N3189MSnowbird Aviation Corp · Signal Mountain, TNBuilt 2000 · S/N E-3325N3189QBoll Weevil Flyers LLC · Reedville, VABuilt 1977 · S/N 28R-7737049N3189SMarvin Franz Interests Inc · Victoria, TXS/N 18255689N3189ULaney Donald R · Inkster, MIS/N 18254589N3189YSkotynsky Michael · Broomfield, COBuilt 2001 · S/N E-3389N3189ZSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 2007 · S/N 4105N318ALeaders Robert O · Clear Lake, MNBuilt 1966 · S/N TE-229N318ACAughenbaugh Alan M · Iroquois, SDBuilt 2000 · S/N 1298-2000N318AWWeinberg Andrew B · Meadow Vista, CABuilt 2019 · S/N 003N318CAKornegay Patrick · Harlingen, TXBuilt 2001 · S/N TH-2001N318CCVan Schoonhoven Nicholas R · Kent, WABuilt 1966 · S/N 18257289N318DSchutes John T · Brimfield, MABuilt 1967 · S/N TE-311N318DMDelta Kilo Mike LLC · Rayville, LABuilt 1977 · S/N 18266215N318DSStrodtbeck Dale G · Eureka, MTBuilt 2025 · S/N 40624N318EBEdwards Robert G · Madison, WIBuilt 2016 · S/N 81878N318FCMendoza Jeremy · Honolulu, HIS/N 28-25156N318GAero Fliers Inc · Akron, OHBuilt 1966 · S/N CE-71N318JMN318jm LLC · Wilmington, DES/N 32R-8313021N318JRFlywell Aviation LLC · Bowling Green, KYBuilt 2006 · S/N 1013-2006N318LLLee Aviation Services LLC · Wilson, NCBuilt 2024 · S/N 18283287N318MAHigh Plains Aviation LLC · Nara Visa, NMBuilt 2001 · S/N 2178N318MBHenderson Michael E · Edmonds, WABuilt 2006 · S/N 5661N318ME1st Avenue Ttc LLC · Los Angeles, CABuilt 1977 · S/N 301/27-003N318MFBusy Bee Helicopters LLC · Lone Jack, MOS/N 0073N318NRNorthern Arizona Investment Group LLC · Prescott, AZBuilt 1982 · S/N 18504382N318PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496134N318PWN318pw LLC · New Canaan, CTBuilt 1973 · S/N 17262171N318RALouden Bruce H · Kalispell, MTFirst renewal noticeBuilt 1977 · S/N 13048N318RCLafrance Lon H · Rocky Mount, MOBuilt 1977 · S/N 17269183N318RNPendas Aviation Corp · Orlando, FLBuilt 2010 · S/N 13060N318SJObr Leasing · Manassas, VAFirst renewal noticeBuilt 2010 · S/N 18282251N318TCGilmer Thomas · Toccoa, GABuilt 1976 · S/N 60-0316-117N318TMOgino Todd T · Barrington, ILBuilt 2009 · S/N 71942N318UTraffic Law LLC · Tampa, FLBuilt 1977 · S/N 310R0994N318VFShramek Troy A · Bossier City, LABuilt 1973 · S/N 17702008N318WCDelta Dusters LLC · Lake Providence, LABuilt 2006 · S/N 18281829N318WMQuinn James Yancie · Farmers Branch, TXBuilt 2001 · S/N 1327N318WTThompson Brent D · Bloomington, INBuilt 2003 · S/N 0474
Back to AD 2007-04-19 R1