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.

N54MKKuhn Morris L · Dallas, TXS/N 22732N54MMGwinn Roger A · Maple, NCBuilt 1979 · S/N 21063756N54MTMay Rose Ellen · Hampshire, ILBuilt 1969 · S/N 28-25821N54PFSilverado Land Management LLC · Sparks, NVS/N E-2941N54PPHancock Andrew M · Kettle Falls, WABuilt 1954 · S/N 22-2199N54PRReimer Lynn C · Sioux Falls, SDBuilt 1972 · S/N 17260943N54PSAustin Bill DBA · Sparta, TNBuilt 1980 · S/N P21000492N54PWScheffers Lee · Riverside, CABuilt 1979 · S/N 18266804N54RAerometrix LLC · Lawrence, KSBuilt 1981 · S/N 21064514N54RAAshlock Mark L · Loomis, CABuilt 1980 · S/N R18201684N54RBWestmoreland Aerosports Inc · Murrysville, PABuilt 2000 · S/N 128N54RFFrasca Lucille A · Urbana, ILBuilt 1957 · S/N G-140N54RHWhite Parker K · Grass Valley, CABuilt 1959 · S/N D-6275N54RLTrimble Steven L · Tallahassee, FLBuilt 1996 · S/N 23675N54RRValentin Jose E · Murrieta, CABuilt 1976 · S/N 13107N54RSIreland Brian T · Springville, UTBuilt 1997 · S/N 633N54RVEbrahimi Mazda · Gerradstown, WVBuilt 1992 · S/N 2370N54RWBaylis Thomas B · Hattiesburg, MSBuilt 1966 · S/N 18256924N54SDJerry W And Barbara J Smith Family Land Lllp · Blanca, COBuilt 1954 · S/N 31162N54SGBiondo Nicholas P · Norfolk, VABuilt 1995 · S/N 080275N54TCK K Stevens Publishing Co · Astoria, ILBuilt 1976 · S/N CE-661N54TDG-Loc Fighters LLC · Wilmington, DEBuilt 1995 · S/N 448N54TF14123 Inc Trustee · Wilmington, DEBuilt 2017 · S/N 14123N54TLArmstron Kevin L · Corvallis, ORBuilt 1992 · S/N 074N54TVAllen And Lambert Inc · Bolingbroke, GABuilt 1975 · S/N 18264264N54TXBail Air LLC · Port Saint Lucie, FLBuilt 1977 · S/N 28-7890151N54VBas Part Sales LLC · Greeley, COBuilt 1980 · S/N ME-313N54VAFisheer Eric E · Memphis, TNBuilt 1968 · S/N 17257295N54VCStrahler Mark D · Peachtree City, GABuilt 2000 · S/N 60338N54VKPain Management And Aesthetics LLC · Celina, OHBuilt 1966 · S/N D-8066N54VVVoutour Ryan R · Tehachapi, CABuilt 1996 · S/N 3030N54WCFlorian Nathan A · Homosassa, FLBuilt 1961 · S/N 18253465N54WDHat Creek Aviation LLC · Hamilton, MTBuilt 1981 · S/N R18201709N54WEWilson Douglas E · Emporia, KSBuilt 2016 · S/N 002N54WMNemensky Jack · Southborough, MABuilt 1976 · S/N CE-657N54WYBernegger Mark S · West Point, MSBuilt 2013 · S/N WF0002N54ZRPoehlmann Ralph T · Brenham, TXS/N 634N54ZZNeuman Michael · Vashon, WABuilt 2023 · S/N 1337N55000Gross Flying Service Inc · Larned, KSBuilt 2003 · S/N 30031CN55001Eastern Stearman Inc Trustee · Leesburg, VABuilt 2003 · S/N 33002CN55007Av8 Inc · Westborough, MABuilt 1973 · S/N 28-7310106N5500BKay James L · Irvine, CABuilt 1956 · S/N 33500N5500CDuncan Robert L · Greenville, MSBuilt 1978 · S/N 401-78N5500DSmoky Mountain Vertical Services LLC · Kodak, TNBuilt 1957 · S/N D-5037N5500EAllen Aviation LLC · Houston, TXBuilt 2001 · S/N 30026CN5500FVernon Walter Benson · Denver, COBuilt 1989 · S/N CE-1400N5500GCummings Terence J · Morgan Hill, CABuilt 1971 · S/N 17260300N5500KMcintyre Ian C · Pace, FLBuilt 2001 · S/N 18079CN5500LWinchell Lawrence R · Salem, NJBuilt 1978 · S/N 1032-78N5500MDecathlon Training Inc · Saint Louis, MOBuilt 1978 · S/N 402-78
Back to AD 2007-04-19 R1