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.

N5660UBecker Timothy L · Vail, AZBuilt 1969 · S/N 28-26457N5660WLopez Javier Garcia · San Jose, CABuilt 1962 · S/N 28-865N5661Bryant Billy Joe · Seymour, TNBuilt 1971 · S/N 588SN56610Pressure Quip LLC · Houma, LABuilt 1973 · S/N 28R-7435017N56612Little Duane V · Puyallup, WABuilt 1973 · S/N 28-7410015N56617Cherokee N56090 LLC · Jackson, GABuilt 1973 · S/N 28-7325671N56619Rock Water Aviation LLC · Herriman, UTBuilt 1973 · S/N 28-7405023N5661BPiekarski John G · Kuna, IDBuilt 1956 · S/N 33661N5661KShockey David Allen · Deland, FLBuilt 1964 · S/N D-7592N5661USkyventure LLC · Washington, INS/N 28-26458N56622Parts And Sparks LLC · Bunnell, FLBuilt 1986 · S/N 10030CN5662BHollibird Aviation LLC · Knightdale, NCBuilt 1956 · S/N 33662N5662KGiddings Melvin J Jr · Vacaville, CABuilt 1964 · S/N D-7588N5662PSullivan Anthony J · Snohomish, WABuilt 1959 · S/N 24-734N5662QMarshall Adam S · Spokane, WABuilt 1965 · S/N 687N5662UBurgin John F · Austin, TXS/N 28-26459N5662VLoft Aire Inc · Venice, FLBuilt 1977 · S/N 28-7716192N56637Hohenstein Douglas · Spokane, WABuilt 1973 · S/N 28-7325674N56639Doskocil Mark · Winston Salem, NCFirst renewal noticeBuilt 1973 · S/N 28R-7435021N5663NMeranda Andrew J · Morganton, NCBuilt 1986 · S/N 11021CN5663QCullen Andrew W · Tennille, GAS/N 3030N5663WCrane Air LLC · Waterford, MIBuilt 1962 · S/N 28-831N5663YWeltyk Michael R · Oxford, MIS/N 10031CN56649International Air Services Inc Trustee · Carson City, NVS/N 28-7410018N5664KEchols Charlotte · Wichita Falls, TXBuilt 1966 · S/N CE-43N5664YFurlong Kelly L · Athens, ALS/N 4033CN56651Boettcher Kurt · Julian, CABuilt 1973 · S/N 28-7405025N56652Carpenter Stephen K · El Paso, TXBuilt 1973 · S/N 28R-7435023N56658American Aviation Inc · Brooksville, FLBuilt 1973 · S/N 34-7450019N56659Skoog Timothy Mark · Monroeville, PABuilt 1973 · S/N 28-7415003N5665JFarwest Aviation LLC · Billings, MTBuilt 1970 · S/N 18800615N5665PLangevin Michael · Anchorage, AKS/N 24-737N5665UZimmerman Damian P · Petersburg, ILS/N 28-26462N5665VWanigas Leasing Corporation · Saginaw, MIBuilt 1977 · S/N 28-7790491N56668Pendarvis Damon E · Morrow, OHBuilt 1973 · S/N 28R-7435026N5666B98x LLC · Caddo Mills, TXBuilt 1956 · S/N 33666N5666DHlavnicka Thomas L · Big Sandy, MTS/N 10035CN5666PChrysoar Group LLC · King George, VABuilt 1959 · S/N 24-738N56671Cooley Edward B III · Lutz, FLBuilt 1973 · S/N 28-7410021N56673Onward Aviation LLC · Brunswick, GABuilt 1973 · S/N 28-7410022N56676Paris Air Inc · Vero Beach, FLBuilt 1973 · S/N 34-7450020N56679Worthington Brian M · Saint Albans, NYBuilt 1973 · S/N 28-7415004N5667BMarmitt Management Inc · Moses Lake, WABuilt 1956 · S/N 33667N5667DWilliams Field LLC · Gig Harbor, WABuilt 1986 · S/N 10037CN5667KSmith John L · Renton, WABuilt 2001 · S/N 172S8991N5667QLove Phillip Love · Rib Mountain, WIBuilt 1965 · S/N 3032N5667SParsons John C · Wichita, KSBuilt 1966 · S/N MB-106N5667WBartanowitz Frank · Millwood, GABuilt 1962 · S/N 28-780N56680Sky III Corporation · Smyrna, TNBuilt 1973 · S/N 28R-7435027N56682Hogan David · Simpsonville, SCBuilt 1973 · S/N 28R-7435028
Back to AD 2007-04-19 R1