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.

N98218Engleman Roy J · Mcalester, OKBuilt 1969 · S/N 28-26114N98222Diol Ranjit S · Dowagiac, MIBuilt 1969 · S/N 28-26117N98223Lustig Keith C · Clyde, MIBuilt 1969 · S/N 28-26118N98226Whited Ronald Glenn · Tampa, FLS/N 28-26120N98237Pierce Teddy D · Savannah, MOBuilt 1969 · S/N 28-26125N98239Sushko Michael S · Plymouth, MNS/N 28-26126N98240Petersen Amos I · Iowa City, IAS/N 28-26127N98241Lh Investments Inc · Albany, ORBuilt 1969 · S/N 28-26129N98242Husbands Klayton P · Bosque, NMBuilt 1969 · S/N 28-26130N98244Kingsbury Janet L · Miramar, FLBuilt 1969 · S/N 28-26002N98249Tramper Air LLC · Rockford, MIBuilt 1969 · S/N 28-25972N98257Fly High Aviation LLC · Miami, FLBuilt 1969 · S/N 28-25954N98263Myers Bobby L · Brookhaven, MSBuilt 1969 · S/N 28-26132N98265Dickey Hugh B III Dr · Rock Hill, SCBuilt 1969 · S/N 28-26134N98266Lockhart Ralph E Jr · Beverly, OHBuilt 1969 · S/N 28-26135N98268Baldassari Roy L · Lawrenceville, NJBuilt 1969 · S/N 28-26137N98269B&R Aircraft LLC · Wadsworth, OHBuilt 1969 · S/N 28-26138N9826WWestrup Gregory W · Greensburg, INBuilt 1967 · S/N 28-23329N98273Ortner Russell · Apopka, FLBuilt 1969 · S/N 28-26141N98293Je Aircraft Repair LLC · Wasilla, AKBuilt 1969 · S/N 28-26150N98297Black Hawk Flight Progress LLC · Cedar Falls, IABuilt 1969 · S/N 28-26254N98298Parsons Mark E · Le Roy, WVBuilt 1969 · S/N 28-26154N98308Morse Robert M · Mayetta, KSBuilt 1969 · S/N 28-26162N98319Restin Air LLC · Kalispell, MTBuilt 1969 · S/N 28-26167N9831WMeyer Dale K · Altamont, NYS/N 28-23335N98320Flyg5 LLC · New London, WIBuilt 1969 · S/N 28-26168N9832WMcmillin Joey D · Edmond, OKBuilt 1967 · S/N 28-23337N98335Wiggs Billy L Jr · Fayetteville, NCBuilt 1969 · S/N 28-26174N98345Fly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26178N98348Industrial Transportation & Distr Consulting LLC · Franklin, OHBuilt 1969 · S/N 28-26179N9834WExceptional Construction LLC · Greenacres, WABuilt 1967 · S/N 28-23340N98351Carufel Elizabeth R · Mesa, AZBuilt 1969 · S/N 28-26180N98357Mook Jerry L · Merritt Island, FLS/N 28-26185N98360Jts Aircraft LLC · Rock Hill, SCS/N 28-26184N98363Fala Lee A · Glendale, AZS/N 28-26187N98365Woolery Timothy A · Maryville, MOBuilt 1969 · S/N 28-26190N98371Buhrow Chris Alan · Humble, TXBuilt 1969 · S/N 28-26195N98372Harlow James Patrick · Liberty Hill, TXBuilt 1969 · S/N 28-26196N98377Sloan Allen Lee · North Augusta, SCBuilt 1969 · S/N 28-26198N98378Basta Scott C · Hayes, VABuilt 1969 · S/N 28-26199N9837WSpeare Clifford W · Saint Charles, ILBuilt 1967 · S/N 28-23344N98380Reese Trenton · Post Falls, IDBuilt 1969 · S/N 28-26128N98383Dunn Karl L · Hazel Green, ALBuilt 1969 · S/N 28-26202N98384Macmillan Alfred R Jr · Salisbury, MDBuilt 1969 · S/N 28-26203N98388Salzwedel Timothy F · New Lisbon, WIBuilt 1969 · S/N 28-26155N98389Sale Reported · Rosenberg, TXSale reportedBuilt 1969 · S/N 28-26207N9838WDutton Margaret Stephanie Executor · Mooresville, NCBuilt 1967 · S/N 28-23345N9839WLoiselle Matthew J · Birch Run, MIBuilt 1967 · S/N 28-23346N9840WWings Of Grace Ministries Inc · Melbourne, FLBuilt 1967 · S/N 28-23347N9841WDubois Aviation Inc · Chino, CABuilt 1967 · S/N 28-23349
Back to AD 96-10-01 R1