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.

N55646Bluto Paul · Branson, MOBuilt 1973 · S/N 28-7325450N55648Pic Aviation Inc · Bloomsburg, PABuilt 1973 · S/N 28-7305434N5564BKramer Clifford R · Eastport, IDBuilt 1956 · S/N 33564N5564FVazquez Oscar C · Moreno Valley, CABuilt 1968 · S/N 28-24904N5564UGoldinger Matthew L · Ligonier, PABuilt 1969 · S/N 28-26291N55652A Group Inc · Houston, TXBuilt 1973 · S/N 28R-7335266N55656Denovellis Dennis T · Sidney, NEBuilt 1973 · S/N 28-7325453N55659Beiderman Allan R · Melbourne, FLBuilt 1973 · S/N 28-7305439N5565BMargetts Kevin M · Folsom, CAS/N 33565N5565DDirect Flight Inc · Vineyard Haven, MABuilt 1989 · S/N TH-1552N5565FHenley Brett · Manchester, TNBuilt 1968 · S/N 28-24905N5565JPerez Luis M Trustee · Corona, CAS/N 32-982N5565PGrant Zachary J · Indianapolis, INBuilt 1958 · S/N 24-629N5565UFiebich Stephan C · Kearney, MOBuilt 1969 · S/N 28-26292N5565XHenry Michael Todd Trustee · Manhattan Beach, CABuilt 1990 · S/N CE-1485N55660Cifuentes Julio · Naples, FLS/N 28R-7335268N55665Bramley Matt J · Mesa, AZBuilt 1973 · S/N 28-7310123N55667Stanick Paul J · Whitinsville, MABuilt 1973 · S/N 287305438N5566BMoore Michael E · Renton, WABuilt 1956 · S/N 33566N5566PTwig And Giggleberries LLC · Wichita Falls, TXBuilt 1958 · S/N 24-630N5566UKingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26293N5566WRegistered aircraftBuilt 1962 · S/N 28-660N55671Brown Christopher A · Tigard, ORBuilt 1973 · S/N 28-7305440N55673Smith Gordon H · Racine, WIBuilt 1973 · S/N 28-7305442N55674Frog Air LLC · Amarillo, TXBuilt 1990 · S/N E-2542N55675Sykes Kinsley · Palm Coast, FLBuilt 1973 · S/N 28-7305443N55677Arrow II Aviation LLC · Rocky Mount, NCBuilt 1973 · S/N 28R-7335270N55678Murdick Robert A II · Bluemont, VABuilt 1973 · S/N 28R-7335271N5567MAnderson Layne A · Wichita Falls, TXBuilt 1967 · S/N 092N5567PRegistered aircraftS/N 24-631N5567QRicol Aviation LLC · Naples, FLBuilt 1965 · S/N 2972N5567W3k Weavers Investment Group LLC · Shelbyville, KYBuilt 1962 · S/N 28-661N55680Madsen Pest Management LLC · Siren, WIBuilt 1973 · S/N 28-7325466N55687Rieber Russell C · Stockton, CABuilt 1973 · S/N 28-7305444N5568BDill David M · Buena Vista, COBuilt 1956 · S/N 33568N5568PSimon Jack · Spring Hill, TNBuilt 1958 · S/N 24-632N5568QJ & F Aviation Adventure LLC · North Fort Myers, FLS/N 637N5568WRegistration Pending · Lebanon, INRegistration pending, pending cancellationS/N 28-662N55691Brown Alan · Lugoff, SCS/N 28-7305447N55695Straight Arrow Aviation LLC · Aurora, ILBuilt 1973 · S/N 28R-7335273N55696Walla Walla University · College Place, WABuilt 1973 · S/N 28R-7335274N55699Hill Caleb · Indianapolis, INBuilt 1973 · S/N 28R-7335281N5569DYniguez Rudy · Redding, CABuilt 1957 · S/N D-5123N5569MWichita Flight Training LLC · Wichita, KSBuilt 1967 · S/N 079N5569NReverie Aviation LLC · Burbank, CABuilt 1990 · S/N E-2529N5569PSpirit Wings Ltd · Wilmington, DEBuilt 1958 · S/N 24-633N5569QBrian C Elbert · Rochester, NHBuilt 1965 · S/N 2973N5569UJapikse Bert · Pawleys Island, SCBuilt 1970 · S/N 28-26884N5569WBridges Michael D · Clovis, NMBuilt 1962 · S/N 28-663N556ATAdventure Partners LLC · Mercer Island, WABuilt 1964 · S/N 206-0190
Back to AD 2007-04-19 R1