OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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.

N2DGAgostini Glenn · Tampa, FLBuilt 1964 · S/N 28-1526N2RSSlippy Timothy W · Bothell, WABuilt 1972 · S/N 28-7205179N300CACharlie Alpha LLC · Midland, MIBuilt 1973 · S/N 28-7305324N300WYChupka William J · Riverton, WYBuilt 1965 · S/N 28-21280N301STTechnical Education Services Inc · Virginia Beach, VAS/N 28-25655N3059FAtwell Charles A · Eldred, NYBuilt 1969 · S/N 28-25760N307PTWindmeier David W · Wheatland, WYBuilt 1966 · S/N 28-3207N3083TLaubscher John E · Cazenovia, NYBuilt 1972 · S/N 28-7205313N3085THewett Brian · Yankee Hill, CABuilt 1966 · S/N 28-3044N3087TArroniz Valentin · San Juan, TXBuilt 1972 · S/N 28-7225542N3089THalverson Wyatt · Colbert, WABuilt 1972 · S/N 28-7225545N311AWWidener Adam S · Sharpsburg, GABuilt 1974 · S/N 28-7525015N312TMVan Hofwegen Douglas E · Spencer, IABuilt 1973 · S/N 28-7305382N313LNBazal Jared W · Castle Rock, COS/N 28-2571N313WMKafer Mark T · Colleyville, TXBuilt 1965 · S/N 28-2678N316BT316 Bravo Tango LLC · Austin, TXS/N 28-7305433N3171QLynn Aviation LLC · Wilmington, DEBuilt 1977 · S/N 28-7725217N317HMSplendid Aviation-Victoria LLC · Corpus Christi, TXBuilt 1966 · S/N 28-3734N317LBTrail Of 140 Tears LLC · Bozeman, MTBuilt 1970 · S/N 28-26935N318FCMendoza Jeremy · Honolulu, HIS/N 28-25156N31SN31s LLC · Wadsworth, OHBuilt 1971 · S/N 28-7205080N31VTSnediker Daniel G · Pittsburgh, PABuilt 1966 · S/N 28-3208N32008K L M Aircraft Co · Media, PABuilt 1974 · S/N 28-7505014N32019Spicher Samuel Charles · Harrisonburg, VABuilt 1974 · S/N 28-7505017N32052Risley Bryan D · Bartow, FLBuilt 1974 · S/N 28-7525016N32059Coast Property Inc · Nipomo, CABuilt 1974 · S/N 28-7505021N32070Williams Seth M · Jeanerette, LAFirst renewal noticeS/N 28-7505022N32095Rogers Dekishon W B · Atlanta, GABuilt 1974 · S/N 28-7525021N32101Speed Hunter Aviation LLC · Franklin, OHBuilt 1974 · S/N 28-7505024N32103Freeman David B · Liberty, NCS/N 28-7505026N32115Kowatra Anil K · Lilburn, GAFirst renewal noticeBuilt 1974 · S/N 28-7505027N32128David William Christy Trustee · Willis, TXBuilt 1974 · S/N 28-7505028N32151Wilson James E III · Brentwood, CAS/N 28-7505030N32156Fier Michael A Sr · Mundelein, ILBuilt 1974 · S/N 28-7525029N32160Emmons Thomas M · Millington, MIBuilt 1974 · S/N 28-7525030N32169Airleasing LLC · Beverly Hills, CABuilt 1974 · S/N 28-7505031N32170Kenslow Michael · Denton, TXBuilt 1974 · S/N 28-7505032N32171Chicken Hawk Aviators LLC · Pembroke Pines, FLBuilt 1974 · S/N 28-7505033N32177Ace Aircraft Leasing Inc · Nazareth, PABuilt 1974 · S/N 28-7525031N32178Nebraska Generator Service LLC · Gibbon, NEBuilt 1974 · S/N 28-7525032N32194Parker Brandt · Hillsboro, WIBuilt 1974 · S/N 28-7505036N32198Garrison Resource Development LLC · Bridgeport, TXBuilt 1974 · S/N 28-7525035N321DNBrookway Aviation LLC · Brookhaven, MSBuilt 1971 · S/N 28-7125236N321VAvia Flight Academy LLC · Stratford, CTBuilt 1968 · S/N 28-4665N321YZStroh Michael · Killdeer, NDS/N 28-7505039N32200Owsley Kevin · Auburn, ALBuilt 1974 · S/N 28-7525036N32209Mitchellville Flyers Inc · Annapolis, MDBuilt 1974 · S/N 28-7505037N32228Segalla Susan B Trustee · Venice, FLBuilt 1974 · S/N 28-7505040N32255Registered aircraftBuilt 1974 · S/N 28-7505041N32256Hasek Christopher A · Plano, TXBuilt 1974 · S/N 28-7505042
Back to AD 96-10-01 R1