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.

N9512JArapahoe Flight Club LLC · Colorado Springs, COBuilt 1966 · S/N 28-3634N95133Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25818N9513JGlorioso Richard · Plant City, FLBuilt 1966 · S/N 28-3635N95147Ramirez Ricardo A · San Antonio, TXBuilt 1969 · S/N 28-25822N9514JDu Bois Aviation Inc · Chino, CABuilt 1966 · S/N 28-3637N95151Gonzalez-Pinto Carmelo · San Antonio, TXBuilt 1969 · S/N 28-25823N95154Cen Inc · Sheridan, WYS/N 28-25825N95157Smutek Brian D · Mio, MIBuilt 1969 · S/N 28-25828N9515JBowman Alex T · Virginia Beach, VABuilt 1966 · S/N 28-3638N95160Registration Pending · Lakewood Ranch, FLRegistration pendingBuilt 1969 · S/N 28-25829N95173First Flight Corporation · San Diego, CABuilt 1969 · S/N 28-25832N9517JBanks Brian H · Zebulon, GABuilt 1966 · S/N 28-3640N95181Stahl Jason R · Etters, PABuilt 1969 · S/N 28-25835N9518WMarshall Christopher · Oshkosh, WIBuilt 1967 · S/N 28-22944N95192Kilo Fox Aviation LLC · Saint Joseph, MIBuilt 1969 · S/N 28-25837N95198Hippen Justin L · Virginia, NEBuilt 1969 · S/N 28-25839N9519JBarlia David L · Anaheim, CABuilt 1966 · S/N 28-3643N95203Neptune Aviation Services Inc DBA · Missoula, MTBuilt 1969 · S/N 28-25840N9520JStaples Laurence C · Makanda, ILBuilt 1966 · S/N 28-3645N95211Massey Aviation LLC · Ashburn, GABuilt 1969 · S/N 28-25843N95217Laight Kevin · Greeneville, TNS/N 28-25844N9521JGeesaman Brian K · Mount Pleasant, PABuilt 1966 · S/N 28-3739N9521WFlap Happy LLC · Sheridan, WYBuilt 1967 · S/N 28-22948N95225Cherokee 95225 LLC · Provo, UTS/N 28-25851N9522WPrio Frank A · Milwaukee, WIBuilt 1967 · S/N 28-22949N95231Duncan Paul D · Norfolk, NEBuilt 1969 · S/N 28-25856N95236Plane Crazy LLC · Bennington, NEBuilt 1969 · S/N 28-25857N95237Klassen Glenn Kurt · Chandler, AZBuilt 1969 · S/N 28-25858N95238Date Greg · Spokane Valley, WABuilt 1969 · S/N 28-25859N9523JMichalka James R · Portage, MIBuilt 1966 · S/N 28-3648N9523WOberg Harry W C III · Evanston, WYBuilt 1967 · S/N 28-22950N95244Banas Darryl P · Waco, TXBuilt 1969 · S/N 28-25861N9524JZanella Paul J · Ballston Spa, NYBuilt 1966 · S/N 28-3649N95253Mmou LLC · Fort Worth, TXBuilt 1969 · S/N 28-25862N95255Herren Robert H · Lexington, KYBuilt 1969 · S/N 28-25863N95259Erickson Landon S · Fairbanks, AKBuilt 1969 · S/N 28-25866N9525JSandpiper Nag LLC · Louisville, KYBuilt 1966 · S/N 28-3650N95264Jorquez Andrew D · Santa Paula, CABuilt 1969 · S/N 28-25867N95265Red River Aviation Services LLC · Altus, OKS/N 28-25868N95266Walton Robert · Franklin Lakes, NJS/N 28-25869N9526JWorthington Brian · Las Vegas, NVBuilt 1966 · S/N 28-3652N9526WMarch Theodore M · Fernley, NVBuilt 1967 · S/N 28-22954N95270Get Away 1 LLC · St George, UTBuilt 1969 · S/N 28-25870N95271Ederer Martin J · Baraboo, WIBuilt 1969 · S/N 28-25871N9527JOklahoma Flight Academy LLC · Owasso, OKBuilt 1966 · S/N 28-3653N9527WDieck Michael J · Fayetteville, NCFirst renewal noticeS/N 28-22955N95285Bangerter James Alan · Indn Hbr Bch, FLBuilt 1969 · S/N 28-25875N9528JGiles Dennis E II · Pearson, WIBuilt 1966 · S/N 28-3654N95302Wright David W · Arlington, TXBuilt 1969 · S/N 28-25878N95303Morrison Robert F II · Denton, TXS/N 28-25879
Back to AD 96-10-01 R1