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.

N81PMSpinnaker Aviation LLC · Conroe, TXBuilt 1973 · S/N 28-7325314N8201NLang Peter J · Coopersburg, PAS/N 28-25403N8201W8201w General Partnership · Wilbraham, MAS/N 28-2330N8202WN8202w LLC · American Fork, UTBuilt 1965 · S/N 28-2331N8203NPope Jimmy M Jr · Eastover, NCBuilt 1969 · S/N 28-25408N8203WCarter Terry A · Clinton, ARBuilt 1965 · S/N 28-2334N8204NNielson Rex W · Pendleton, ORBuilt 1969 · S/N 28-25396N8204WJeffery Gordon Paul III · Kirkland, WABuilt 1965 · S/N 28-2335N8205WShockey Michael J · Dumas, TXBuilt 1965 · S/N 28-2336N8206WMedia Stew LLC · Carson City, NVBuilt 1965 · S/N 28-2337N8207NRohner Harlan G · Willmar, MNS/N 28-25409N8208NMwh Consulting · Justin, TXS/N 28-25411N8209WRegistered aircraftBuilt 1965 · S/N 28-2341N8211WPeterson Dustin K · Alliance, NEBuilt 1965 · S/N 28-2344N8212WRayviation LLC · Carrollton, MIBuilt 1965 · S/N 28-2345N8213CFaucon LLC · Tucson, AZBuilt 1975 · S/N 28-7525160N8214NKuenzi Scott A · Madison, WIBuilt 1969 · S/N 28-25418N8215NRyder Paul M · Charlotte, NCBuilt 1969 · S/N 28-25419N8216NShelton William B · Wildwood, MOBuilt 1969 · S/N 28-25420N8216WBritair Inc · Austin, TXBuilt 1965 · S/N 28-2349N8217NG U M P S Flying Club Inc · Warner Robins, GABuilt 1969 · S/N 28-25421N8218NLee David · Palm Springs, CAS/N 28-25548N8219WA18 Missions LLC · Clinton, MOBuilt 1965 · S/N 28-2352N821PTHermes Ana Paula F · West End, NCFirst renewal noticeBuilt 1973 · S/N 28-7305600N8221NFedchenko Vitaliy · Cumming, GABuilt 1969 · S/N 28-25425N8222WMitzel Aaron · China Spring, TXBuilt 1965 · S/N 28-2355N8223NEvans Jay M · Arrington, TNBuilt 1969 · S/N 28-25427N8224NDc Aviation LLC · Appleton, WIBuilt 1969 · S/N 28-25429N8224WDavis William M · Chattanooga, TNBuilt 1965 · S/N 28-2357N8225WLewis Devin H · Lacey, NJBuilt 1965 · S/N 28-2359N8227NRegistration Pending · Dawsonville, GARegistration pendingS/N 28-25432N8227WQuarter Circle E Enterprises Inc · Yorba Linda, CABuilt 1965 · S/N 28-2365N8228WKoaks Aviation LLC · Farmers Branch, TXBuilt 1965 · S/N 28-2276N8229WRab Aviation Photography LLC · Lanexa, VABuilt 1965 · S/N 28-2304N8232NWithee Steven A · Batavia, NYBuilt 1969 · S/N 28-25437N8232WR&E Stars LLC · Fairfax Station, VABuilt 1965 · S/N 28-2371N8233WWhelchel Denise B · Upland, CABuilt 1965 · S/N 28-2372N8234WRegistered aircraftBuilt 1965 · S/N 28-2375N8236N8asplanes LLC · Lewes, DEBuilt 1969 · S/N 28-25443N8236WWilson Kevin · Boise, IDBuilt 1965 · S/N 28-2378N8237WS & S Entertainment Inc · Louisville, KYBuilt 1965 · S/N 28-2379N8238NSilver Hawk Aviation LLC · Panora, IABuilt 1969 · S/N 28-25445N8238WParish John I · New Braunfels, TXBuilt 1965 · S/N 28-2380N8239NKattke Timothy J · Redfield, SDBuilt 1969 · S/N 28-25447N8239WJones Sarah M · Butte, MTS/N 282382N8240NStein Kenneth A · Rapid City, SDBuilt 1969 · S/N 28-25448N8240WGeiger Nathaniel · Omaha, NES/N 28-2383N8241WLuckey Jeffrey E · Camarillo, CABuilt 1965 · S/N 28-2385N8242NBrezina Douglas P · Broadview, ILBuilt 1969 · S/N 28-25450N8243WHill Andrew M · Spokane, WAS/N 28-2389
Back to AD 96-10-01 R1