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.

N38248Plane Training LLC · Rapid City, SDBuilt 1977 · S/N 28-7716234N3824DDavis Marc · Hilsboro, ORBuilt 1957 · S/N 34524N3824MDraveling Larry J · Wasilla, AKFirst renewal noticeBuilt 1947 · S/N 12-2744N3824RAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N MC-741N3824TStevens Zane Kelly · Carthage, TNBuilt 1967 · S/N 28R-30141N3824WTeel Brian P · Hooper, UTBuilt 1966 · S/N 32-756N3824XHirschauer Jeffrey · Spokane, WABuilt 1981 · S/N CE-941N3824YMclaren Richard T · Sturbridge, MABuilt 1964 · S/N 21058324N3824ZMoore Ricky J · Milton, KYBuilt 1980 · S/N MC-644N38250Elkins John H · Lancaster, MABuilt 1977 · S/N 28-7790531N38254Syracuse Flying Club Inc · Fayetteville, NYBuilt 1977 · S/N 28-7790534N38256Ringler Neil H · Baldwinsville, NYBuilt 1977 · S/N 28R-7737085N3825DSelf Robert R · Tuttle, OKS/N 34525N3825MMckendry Scott P · Sanford, NCBuilt 1981 · S/N E-1813N3825QFischer Roger G · Torrance, CABuilt 1971 · S/N 17259925N3825TArmstrong Aviation Services LLC · Freeport, PABuilt 1967 · S/N 28R-30143N3825WKaizen Companies Inc · Boise, IDBuilt 1966 · S/N 32-757N3825XBliss Aviation LLC · Somerville, TNBuilt 1981 · S/N TH-1230N3825YAtlas Mining & Mechancial Inc · Beryl, UTBuilt 1964 · S/N 21058325N38265Recipe System US Inc · Torrance, CABuilt 1977 · S/N 28-7716236N38267Andy Mack Management LLC · Wilmington, DEBuilt 1977 · S/N 28-7716237N3826PBauries Brian W · Abilene, TXBuilt 1955 · S/N 22-3516N3826WMiller Heather J · Dupo, ILBuilt 1966 · S/N 32-759N3826ZWebster William S · Eden, WYBuilt 1961 · S/N 18-7569N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086N38276N38276 LLC · Las Vegas, NVBuilt 1977 · S/N 32-7740081N3827DKendallville Flying Service Inc · Saint Joe, INBuilt 1957 · S/N 34527N3827MFox James Douglas · Pittsburg, ILBuilt 1978 · S/N 28-7890335N3827QCobb Jeff B · Atlanta, GABuilt 1981 · S/N CE-942N3827TBrauer Noah J · Covington, KYBuilt 1967 · S/N 28R-30145N3827YPrentice Ronald L · Winchester, CABuilt 1964 · S/N 21058327N38282Zemetis Terence A · Meriden, CTBuilt 1981 · S/N E-1819N3828DWarner Thomas E · Beloit, OHBuilt 1957 · S/N 34528N3828NSallustio Eric · Lake Butler, FLBuilt 1981 · S/N E-1818N3828PPupator Peter Trienko · Willow, AKBuilt 1955 · S/N 22-3518N3828XAmerican Flightscope Inc · Wilmington, DEBuilt 1981 · S/N TC-2374N3828YHall Edmond · Bremerton, WABuilt 1964 · S/N 21058328N3828ZOrvin Sanden Inc · Wyndmere, NDBuilt 1960 · S/N 18-7571N38291Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1977 · S/N 28-7716240N38293L & A Bennett Second Family L P · Renton, WAS/N 28-7790537N38294Aerograzmar LLC · Bloomfield, NJBuilt 1977 · S/N 28R-7737087N3829PRalphs Thomas A · Solana Beach, CABuilt 1978 · S/N P21000062N3829QMiller Randall J · Arlington, WABuilt 1971 · S/N 17259929N3829TFreese Pamela L · Frederic, WIBuilt 1967 · S/N 28R-30147N3829XFerrari Martin · Centerville, OHBuilt 1981 · S/N M-2306N382AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281192N382ASAero Leasing · Brookings, ORBuilt 1998 · S/N 2902N382BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010086N382CBMoncada Ramos Edwin Antonio · Lawrenceburg, KYBuilt 1974 · S/N 75-30731N382CCVeenstra Timothy S · Wasilla, AKS/N 9946CC
Back to AD 2007-04-19 R1