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.

N9005JSmolen Timothy R · Mckinney, TXBuilt 1966 · S/N 28-3030N9009JJohnson Kent Paul · St George, UTBuilt 1966 · S/N 28-3035N900FYBain Jeffrey R · Roseville, CAS/N 28-7525252N9010JNix Terry W · Golden, MSBuilt 1966 · S/N 28-3036N9015NPerry David · Campbell, CAS/N 28-4711N9017JHarlan Tom L · Bakersfield, CABuilt 1966 · S/N 28-3045N901EHigh Five Flying LLC · Amarillo, TXBuilt 1973 · S/N 28-7425053N901TQAdirondack Aviation LLC · Saranac Lake, NYBuilt 1977 · S/N 28-7725178N9022JLewis Kristofor M · Sparks, NVBuilt 1966 · S/N 28-3050N9023JCook Richard J II · Princeton, ILBuilt 1966 · S/N 28-3051N9025JAa&R Aviation LLC · Pine Grove, PABuilt 1966 · S/N 28-3053N9026JRay Adam W · Stinnett, TXBuilt 1966 · S/N 28-3054N9028JGarcia Pinedo Adolfo · Miami, FLBuilt 1966 · S/N 28-3055N9030JSunrise Aviation Group LLC · Kalispell, MTBuilt 1966 · S/N 28-3058N9031JBaumgartner Matthew J · Federal Way, WABuilt 1966 · S/N 28-3059N9033JBernstein Matthew D · North Charleston, SCBuilt 1966 · S/N 28-3062N9034JGrammer Steve J · Redding, CABuilt 1966 · S/N 28-3063N9036JBernau Bodies Fitness LLC · Mesa, AZBuilt 1966 · S/N 28-3066N9037JMcgough Julie E · Red Oak, TXBuilt 1966 · S/N 28-3067N903USSchneider Charles · Sioux Falls, SDBuilt 1966 · S/N 28-3068N9040JEllis James E Trustee · Harvard, MABuilt 1966 · S/N 28-3070N9042JRenfroe Charles R · Panama City, FLBuilt 1966 · S/N 28-3073N9043JHunter Lauchlin S Jr · Alexander City, ALS/N 28-3074N9045JLandsgaard Theodore · Rosamond, CABuilt 1966 · S/N 28-3076N9046QDavis John A · Eau Claire, WIS/N 28-7125089N9047JHalajian Dominic M · Rogers, MNBuilt 1966 · S/N 28-3078N9050JHunt-Thorton Trevon · Aurora, COBuilt 1966 · S/N 28-3081N9051JCt Air LLC · Lubbock, TXBuilt 1966 · S/N 28-3082N9052JLairmore John H · Owasso, OKBuilt 1966 · S/N 28-3083N9053JThompson Scott C · Redwood City, CABuilt 1966 · S/N 28-3084N9057JBaker Charles L · Swartz Creek, MIFirst renewal noticeBuilt 1966 · S/N 28-3091N9058JRubinic Brandon S · Harrisburg, PABuilt 1966 · S/N 28-3092N9060JGillis Joseph V · Tempe, AZBuilt 1966 · S/N 28-3094N9062JVernon Sharnell Tamieko · Phoenix, AZS/N 28-3096N9063JHardison Samuel H · Mountain View, ARS/N 28-3097N9064JSolomon Michael Lee · Hope Mills, NCBuilt 1966 · S/N 28-3099N9067JEvans Jennifer M · Escalante, UTS/N 28-3102N9068JGregory Brent · Townsend, DES/N 28-3103N906PSGravitas Services LLC · Richmond Hill, GAS/N 28-777N906WFPapesh Sandra J · Cottonwood, CABuilt 1971 · S/N 28-7125163N9070JCruiser Club Inc · Wahpeton, NDS/N 28-5115N9073JStewart Kenneth E Trustee · Raleigh, NCBuilt 1966 · S/N 28-3109N9074JEast Kentucky Aviation LLC · Ashland, KYBuilt 1966 · S/N 28-3110N9076JMidvale Flying Club Inc · Midvale, IDBuilt 1966 · S/N 28-3112N9077JStreuer Troy · Smithville, TXBuilt 1966 · S/N 28-3113N9078JConner W Larry · Los Lunas, NMBuilt 1966 · S/N 28-3115N9079JTestruth Gary R · Coarsegold, CABuilt 1966 · S/N 28-3116N907PSBrock W Walker · Charleston, SCBuilt 1966 · S/N 28-3762N9081JPerkins Jimmy Keith · Lonoke, ARBuilt 1966 · S/N 28-3118N9085JBligh Michelle C · Oceanside, CABuilt 1966 · S/N 28-3122
Back to AD 96-10-01 R1