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.

N9168J2binc LLC · Adrian, MIBuilt 1966 · S/N 28-3229N916HPNeustaeter Pedro Thiessen · Anthony, NMS/N 28-2658N916JFHammett Gary N · Prince Frederick, MDBuilt 1974 · S/N 28-7405130N9171JRichardson Adam D · Franklin, INBuilt 1966 · S/N 28-3232N9174JOrleans Flying Club Inc · Orleans, INBuilt 1966 · S/N 28-3238N9175JSommer Eric M · London, OHBuilt 1966 · S/N 28-3241N9176JPayson Aero Club LLC · Payson, AZBuilt 1966 · S/N 28-3242N9178JCrawley Rohan · Bloomington, INS/N 28-3244N9182JTremblay Christopher A · Albion, MEBuilt 1966 · S/N 28-3250N9182KRoth Howard R · Mott, NDBuilt 1976 · S/N 28-7625169N9185JRatcliff Dale A · Granville, OHBuilt 1966 · S/N 28-3253N9188JBooth Emmett W · Waitsburg, WAS/N 28-3256N9189JMileski William J · Ledyard, CTBuilt 1966 · S/N 28-3257N9190JLarchar William S · Rockledge, FLS/N 28-3258N9191JArmstrong Donald Bradford · Sterling, COBuilt 1966 · S/N 28-3259N9192VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1965 · S/N 28-3268N9193JGref Michael C · Murfreesboro, TNBuilt 1966 · S/N 28-3261N9194JStange Robert C · Toledo, OHBuilt 1966 · S/N 28-3262N9195JLau-Camarena Alvaro · Euless, TXBuilt 1966 · S/N 28-3263N9196JScarlett Seth T · Omaha, NEBuilt 1966 · S/N 28-3264N9197JDifabio Jack F · Newtown, PABuilt 1966 · S/N 28-3265N91CGRick Jelinek Trucking Inc · Palmyra, WIBuilt 1964 · S/N 28-20214N91PGTri Angle 7 · Bonham, TXS/N 28-26448N91QAEskridge Daniel A · Heathsville, VABuilt 1969 · S/N 28-26233N91WBethany Holdings LLC · Jamestown, NCBuilt 1969 · S/N 28-25441N9201JPiedmont Flight Co LLC · Nicholson, GAS/N 28-3269N9202JMathews Richard C · Bradenton, FLBuilt 1966 · S/N 28-3270N9203JRegistration Pending · Bulverde, TXRegistration pendingBuilt 1966 · S/N 28-3271N9204JCherokee N9204j Inc · Spanish Fork, UTBuilt 1966 · S/N 28-3272N9205JAviation Partners LLC · Greer, SCBuilt 1966 · S/N 28-3274N9206JBolles Aviation LLC · Johns Creek, GABuilt 1966 · S/N 28-3275N9211JBrown Herbert R · Halls, TNBuilt 1966 · S/N 28-3280N9212JJones Greg E · Thomasville, GABuilt 1966 · S/N 28-3281N9213JRegistered aircraftBuilt 1966 · S/N 28-3283N9213KCarver Clarence K · Lutz, FLBuilt 1976 · S/N 28-7625170N9214JSale Reported · Hurdsfield, NDSale reported, pending cancellationBuilt 1966 · S/N 28-3284N9215JGrizzard Shawn C · Hayden, IDS/N 28-3285N9216JSantana Alexandre C · Long Beach, CABuilt 1966 · S/N 28-3286N9217JWaicekauskas Joe · Raymondville, MOBuilt 1966 · S/N 28-3287N921LCCrum Robert W · Lake Havasu City, AZBuilt 1969 · S/N 28-25939N9221JJgms Rose LLC · Stamford, CTBuilt 1966 · S/N 28-3291N9223JRudo Mark R · Milton, DEBuilt 1966 · S/N 28-3293N9224JJackson Jonathan · Siloam Springs, ARBuilt 1966 · S/N 28-3294N9227JBinns George E · Hackettstown, NJBuilt 1966 · S/N 28-3297N9229JUnterschuetz Phillip David · Ladysmith, WIBuilt 1966 · S/N 28-3299N9231JLeetz Tom · Elgin, ILBuilt 1966 · S/N 28-3302N9232JAdirondack Flying Club LLC · Rome, NYBuilt 1966 · S/N 28-3305N9236KLabrada Fabio · Decatur, TXBuilt 1976 · S/N 28-7625172N9239JAshmore Benjamin H Jr · Austin, TXBuilt 1966 · S/N 28-3313N9240JThorson Jason J · East Grand Forks, MNBuilt 1966 · S/N 28-3314
Back to AD 96-10-01 R1