OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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.

N782CAChristman Matthew T · Markle, INBuilt 1966 · S/N 28-21849N7830NGonzalez Braulio A · Bourbonnais, ILBuilt 1969 · S/N 28-5284N7830WWildhaber Andrew W · Coal Creek, COBuilt 1964 · S/N 28-1845N7831NRadar Service Terminated LLC · New York, NYBuilt 1969 · S/N 28-5285N7832WRankin Kevin J · Maryville, MOBuilt 1964 · S/N 28-1849N7833NStrait Brian C · Joplin, MOBuilt 1969 · S/N 28-5287N7833WLukehart Steve D · Lincoln, NEBuilt 1964 · S/N 28-1850N7834NVector Aviation LLC · Mentor, OHBuilt 1969 · S/N 28-5288N7834WCleek Norris E · Orland, CABuilt 1964 · S/N 28-1851N7835NOrrill Bill · Godfrey, ILBuilt 1969 · S/N 28-5289N7836NMelancon Scottie J · Baton Rouge, LABuilt 1969 · S/N 28-5291N7837WHock Matthew G · Culbertson, NEBuilt 1964 · S/N 28-1854N7838NWright David P Jr · Chandler, AZBuilt 1969 · S/N 28-5293N7839NHaddle Eddie J · Lindon, UTBuilt 1969 · S/N 28-5295N7840NBiby Steven R · Churchs Ferry, NDBuilt 1969 · S/N 28-5294N7840WTomic Milos · Westminster, COBuilt 1964 · S/N 28-1857N7841WBasin Flyers LLC · Klamath Falls, ORS/N 28-1858N7842NBoon Andrea Elizabeth · Bloomingdale, NYBuilt 1969 · S/N 28-5297N7843NA10 Aviation LLC · Peachtree City, GABuilt 1969 · S/N 28-5298N7844WSaddy Rock · Henderson, NVS/N 28-1861N7846NWelch Koby Adam · Bel Air, MDBuilt 1969 · S/N 28-5302N7846WJohnpeer Kate M · Whittier, CABuilt 1964 · S/N 28-1864N7847WErickson Richard M · Summerville, SCBuilt 1964 · S/N 28-1865N7848NRunions David W · Elon, NCBuilt 1969 · S/N 28-5304N7848WStockman Richard Benjamin · Southaven, MSS/N 28-1866N7849NZdravko Tyrone · Clearwater, FLBuilt 1969 · S/N 28-5305N7850NMach 3 LLC · Enid, OKBuilt 1969 · S/N 28-5306N7851NWilson Steven Alfred Trustee · Runnells, IABuilt 1969 · S/N 28-5307N7851WJl Wings LLC · Prosper, TXBuilt 1964 · S/N 28-1870N7852NDelatte Joseph S · Gonzales, LABuilt 1969 · S/N 28-5309N7852WSouthall David S · Poquoson, VABuilt 1964 · S/N 28-1871N7853NLong Nels B · Caledonia, OHBuilt 1969 · S/N 28-5310N7854JMilstead Eric N · Tampa, FLBuilt 1966 · S/N 28-3736N7856N56 November LLC · Brighton, COBuilt 1969 · S/N 28-5313N7856WN7856w LLC · Shelocta, PABuilt 1964 · S/N 28-1876N7857NKranz Charles Leroy · Milbank, SDS/N 28-5314N7857WAllen Aviation LLC · Spring Hill, KSBuilt 1964 · S/N 28-1878N7858WBeans Steven T · Cozad, NEBuilt 1964 · S/N 28-1879N7859NNls Real Estate LLC · Irving, TXBuilt 1969 · S/N 28-5317N7860NLindsay Construction LLC · Fernandina Beach, FLBuilt 1968 · S/N 28-5318N7860WRed Rock Flying School LLC · Mesa, AZBuilt 1964 · S/N 28-1881N7861WComer Christopher C · Randleman, NCBuilt 1964 · S/N 28-1882N7862NMontero Joseph A · Spring Hill, FLBuilt 1969 · S/N 28-5319N7863WBauer Thomas M · Fairfield, PABuilt 1964 · S/N 28-1884N7865NWalkup Gerald L · Novato, CABuilt 1969 · S/N 28-5322N7866WWiger Theodore L · Falcon Heights, MNBuilt 1964 · S/N 28-1887N7867WGilmore John J · San Carlos, CABuilt 1964 · S/N 28-1888N7869WLichtenstein James E · San Carlos, CABuilt 1964 · S/N 28-1891N786MBSkys Edge Aviation LLC · Midland, TXBuilt 1964 · S/N 28-2106N7870WGaydon Jesse A · Sharpsburg, GABuilt 1964 · S/N 28-1892
Back to AD 96-10-01 R1