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.

N5744ULance Sylvia · Acushnet, MABuilt 1970 · S/N 28-26564N5744WGarrett Jackson Trustee · Pleasant Garden, NCBuilt 1963 · S/N 28-1447N57454Ck Leasing Services LLC · Wilmington, DEBuilt 1973 · S/N 90-73N57456Marshall James I · Roosevelt, UTBuilt 1973 · S/N 508-73N57458Flytrek3 LLC · Palmer, AKBuilt 1973 · S/N 509-73N5745JJohnson Charles R · Aurora, OHBuilt 1974 · S/N 18263512N5745KGreen Mountain Avionics Inc · Middlebury, VTBuilt 1964 · S/N D-7555N5745PMiller Aaron T · New Braunfels, TXS/N 24-819N5745QHuseman Joseph F · De Witt, IABuilt 1965 · S/N 3159N5745UMccormick Todd L · Ankeny, IAS/N 28-26565N5745VBonanza N5745v LLC · Colorado Springs, COBuilt 1966 · S/N D-8187N57468Lease Gregory C · Grand Rapids, MNBuilt 1973 · S/N 514-73N5746JPassage Way Farms · Lyon, MSBuilt 1974 · S/N 18263513N5746MFlyaware Inc · Lewes, DENon-citizen corporation, flight hours not reportedS/N 310P0046N5746PYinyan Tech US Inc · Brea, CANon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 24-820N5746QKing Jeremy · Sandy Springs, GAS/N 3075N5746USale Reported · Crystal, MNSale reportedBuilt 1969 · S/N 28-26567N57472Kutztown Aviation Service Inc · Germansville, PABuilt 1973 · S/N 512-73N57473Duncan Michael E · Auburn, CABuilt 1973 · S/N 378-73N57476Boucher Gregg D · Hinsdale, MTBuilt 1973 · S/N 516-73N5747BFarris Steve R · Fresno, CABuilt 1956 · S/N 33747N5747DMcmillian Roger L · Camdenton, MOBuilt 1956 · S/N 22-4447N5747FMsol Air LLC · Lakeland, FLBuilt 1968 · S/N 28-25048N5747KDel Martin Lp · Spring, TXBuilt 1964 · S/N D-7534N57488Rocky 80 Inc · Ethridge, MTBuilt 1973 · S/N 521-73N5748JWallner Patrick J · Redding, CABuilt 1974 · S/N 18263515N5748PBaxter Randall T · Maple, NCBuilt 1959 · S/N 24-823N5748VB55 Partners LLC · Vero Beach, FLFirst renewal noticeBuilt 1966 · S/N TC-993N57492Trimble Tanner J · Blue Rapids, KSBuilt 1984 · S/N 24-1455N5749KBase To Final LLC · Mesa, AZBuilt 1964 · S/N D-7536N5749WDch Aviation LLC · Owasso, OKBuilt 1963 · S/N 28-1467N5749XFlash Aviation LLC · Elkton, MDBuilt 1984 · S/N 24-1454N574AKFirey Charles R · Anchorage, AKBuilt 2015 · S/N 001N574ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496199N574BFKrusemark Emma A · Pender, NES/N 28-25047N574CACivil Air Patrol · Maxwell Afb, ALBuilt 2008 · S/N 18282121N574CDMassingale Harold L · Lenoir City, TNBuilt 2005 · S/N 1554N574CLMaier Ludwig Peter · Port Orange, FLS/N 574N574CMMarshall Aviation Services Inc · Elkhart, INBuilt 2008 · S/N 99N574CZSiu Bernard K · Diamond Bar, CABuilt 2016 · S/N 1N574DEMuggsys Aviation Services LLC · Crittenden, KYBuilt 1974 · S/N 172-62959N574DGSmith Bruce Martin Trustee · Spirit Lake, IDBuilt 2003 · S/N 777N574FLDynamic Aviators LLC · San Angelo, TXS/N 28-7125421N574HALow Approach LLC · Wilmington, NCBuilt 2001 · S/N TH-1975N574HBIngram Grant Leigh · Hurricane, UTBuilt 2021 · S/N 4134CN574JPThompson Phillip · Lakeway, TXBuilt 1977 · S/N D-10054N574KKurz Douglas · Houston, TXS/N TH-1901N574KBBrooks Flyers LLC · Willow, AKBuilt 2021 · S/N 22046CN574KRPhoenix Rising Aviation Inc · Bartlesville, OKS/N 22-5273N574LBThoft Matthew M · Wasilla, AKBuilt 1977 · S/N 18-7709109
Back to AD 2007-04-19 R1