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.

N5621WHurt Bret K · Huntsville, ALBuilt 1962 · S/N 28-764N56220Seashell Aviation LLC · Milton, FLS/N 28-7325591N56224Thomas Way LLC · Jackson, MIBuilt 1973 · S/N 28-7305554N56227Registration Pending · Ira, MIRegistration pendingBuilt 1973 · S/N 28-7305555N5622KAyorinde Olawale T · Upper Marlboro, MDBuilt 1973 · S/N 28-7305556N56239Hobart Aviation Inc · Akron, OHS/N 28-7325593N5623UMendoza Cesar · Anthony, NMBuilt 1969 · S/N 28-26419N56241Smith Bonny L · Milan, INBuilt 1973 · S/N 28-7305558N56256Flying Bears Aviation LLC · Wilmington, DEBuilt 1973 · S/N 28-7305559N5625USkorina Air LLC · Walla Walla, WABuilt 1969 · S/N 28-26421N5626UFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26423N5626WMiller Andy · Marana, AZBuilt 1962 · S/N 28-769N5627UMcelhannon Susan L · Athens, GABuilt 1969 · S/N 28-26422N5627WSavio Stefan V · Trophy Club, TXBuilt 1962 · S/N 28-772N56280Briggs Samuel K · Portland, ORBuilt 1973 · S/N 28-7325597N56281Lewis Nathan Timothy · Hayden, IDS/N 28-7325598N56282Kowatra Anil K · Lilburn, GAS/N 28-7325601N56288Cole Douglas W · Kennewick, WAS/N 28-7325604N56289Butler Stephen P · Ossian, INBuilt 1973 · S/N 28-7305564N5628WB & D Aviators LLC · Bremen, INBuilt 1962 · S/N 28-773N5629WLawrence Michael · Eden Prairie, MNBuilt 1962 · S/N 28-774N5631UTejada Emilia P · Oakland Park, FLS/N 28-26427N56324De Melo Marcelo Ramos · Vinton, VABuilt 1973 · S/N 287325609N56325Glaser John · Merritt Island, FLBuilt 1973 · S/N 28-7305570N5632USale Reported · Montgomery, ALSale reportedBuilt 1969 · S/N 28-26428N5633WWenzel Mark B · Algona, IABuilt 1962 · S/N 28-779N56343R&T Wings LLC · Lewes, DES/N 28-7325612N56344Rogers Steve M · Brenham, TXBuilt 1973 · S/N 28-7305574N5634WEagle Vision LLC · Hamer, IDBuilt 1962 · S/N 28-781N56350Aerospace Technology Group Inc · Temecula, CABuilt 1973 · S/N 28-7325613N56363Romzick Peter G · Oxford, MIBuilt 1973 · S/N 28-73-25618N5636UMontie Michael · Fairview Park, OHBuilt 1969 · S/N 28-26432N5636WWatkins Micah · Queen Creek, AZBuilt 1962 · S/N 28-783N5637UCurtis Alex K · Winnemucca, NVBuilt 1969 · S/N 28-26433N56380Zimin Carl E · Naknek, AKBuilt 1973 · S/N 287325620N56382Risley Air LLC · Myrtle Beach, SCBuilt 1973 · S/N 287305580N56387Prentice Robert D · Ripon, WIBuilt 1973 · S/N 287305584N5638ULig Tyl LLC · Akron, NYBuilt 1969 · S/N 28-26435N56396Sky North Aviation & Flight Training LLC · Arbuckle, CABuilt 1973 · S/N 287325623N5639UMcconnell Charles L · Phoenix, AZBuilt 1969 · S/N 28-26434N563FLParkerson James R · Greenville, MSS/N 28-7125405N56404Mark Lindstrom · Fort Worth, TXBuilt 1973 · S/N 287305586N5640UJustfly Inc · Houston, TXBuilt 1969 · S/N 28-26436N56414Gordon David P · Truckee, CABuilt 1973 · S/N 287305588N5641WThibodeau Tom M · Kenai, AKBuilt 1962 · S/N 28-789N56429Norman Ronald E · Lopez Island, WABuilt 1973 · S/N 287325628N56432Ladig Aviation LLC · Mount Washington, KYS/N 287305591N5643UExotic Sky LLC · Kalispell, MTBuilt 1969 · S/N 28-26439N5644UDonaubauer Stefan · Charlotte, NCBuilt 1969 · S/N 28-26441N564514gaviation LLC · Reading, PABuilt 1973 · S/N 287305595
Back to AD 96-10-01 R1