OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,565

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:2009-10-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-10-09-R2')
  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.

N714MJRheintgen Rachel L · Saint Petersburg, FLBuilt 1977 · S/N 15079279N714MKMoe Hudson T · Anchorage, AKBuilt 1977 · S/N 15079280N714MMBragg Peter M · Brooklet, GABuilt 1977 · S/N 15079282N714MPHendrickson Reino W · Osage, MNBuilt 1977 · S/N 15079284N714MWGanser Mark E · Seward, AKBuilt 1977 · S/N 15079290N714MZAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1977 · S/N 15079293N714NFSierra Lima Aviation LLC · Riverton, UTBuilt 1977 · S/N 15079298N714NGIngold Terry L · Albemarle, NCBuilt 1977 · S/N 15079299N714NHCarroll Douglas Orem Jr · Greenwood, DEBuilt 1977 · S/N 15079300N714NJPortes Emerson · Merrimack, NHBuilt 1977 · S/N 15079301N714NLAerolanding LLC · Enterprise, ALBuilt 1977 · S/N 15079303N714NMJax Rentals LLC · Saint Augustine, FLS/N 15079304N714NQSmith Christopher D · Limington, MEBuilt 1977 · S/N 15079307N714NRUdenberg Scott M · Cotter, ARBuilt 1977 · S/N 15079308N714NXPenn Yan Flying Club Inc · Penn Yan, NYBuilt 1977 · S/N 15079314N714PAOne Six Sierra LLC · Boulder, COS/N 15079317N714PCSchuessler Christopher · Upland, CABuilt 1977 · S/N 15079319N714PGJet & Rotor Aviation LLC · Sacramento, CAS/N 15079323N714PHColitti Mark A · North Hollywood, CABuilt 1977 · S/N 15079324N714PLImmel Titan M · Adair, IABuilt 1977 · S/N 15079327N714PXLionudakis Christopher L · Conroe, TXBuilt 1977 · S/N 15079337N714PZLehman Richard S · Mulberry, TNBuilt 1977 · S/N 15079339N714QBVelasco Rolando · Belgrade, MTBuilt 1977 · S/N 15079341N714QDMeese Brian D · Conroe, TXBuilt 1977 · S/N 15079343N714QGFerrick James F · Mechanicville, NYBuilt 1977 · S/N 15079346N714QLGround School Flight Training LLC · Lewes, DES/N 15079350N714QMRichardson David H · Sidell, ILBuilt 1977 · S/N 15079351N714QQJacobsen Sandra N · Moab, UTBuilt 1977 · S/N 15079354N714QSMaharaj Narad · Morgantown, WVBuilt 1977 · S/N 15079356N714QWA Parrottes View In Flight LLC · Wilmington, DEBuilt 1977 · S/N 15079360N714QXLewis Justin S P · Choctaw, OKBuilt 1977 · S/N 15079361N714RBStewart Family Ranch Inc · Chadron, NES/N 15079365N714RCWebster Richard Eric · West Valley City, UTS/N 15079366N714RFB2 Aviation LLC · Hopkinsville, KYBuilt 1977 · S/N 15079369N714RGLumgair David R · Painter, VAS/N 15079370N714RNHubler Alvin J Jr · Elizabethtown, PABuilt 1977 · S/N 15079376N714RPSapp Michael B · Burlington, NCBuilt 1977 · S/N 15079377N714RRMcburney Gary N · Apple Valley, CABuilt 1977 · S/N 15079379N714RSBeefair LLC · Kalispell, MTBuilt 1977 · S/N 15079380N714RVPataky Edward F Jr · Nashville, TNBuilt 1977 · S/N 15079383N714SGAce Aviators LLC · Mcdonough, GABuilt 1977 · S/N 15079393N714SKAlaska Sky School LLC · Anchorage, AKBuilt 1977 · S/N 15079396N714SLSopko Mark W · Flagtown, NJBuilt 1977 · S/N 15079397N714SPBoyer Steven L · Wooster, OHBuilt 1977 · S/N 15079400N714SSPierce Jeanne E · Wellington, NVBuilt 1977 · S/N 15079403N714SVStookey Aaron M · Mesa, AZBuilt 1977 · S/N 15079405N714SWMackin Robert M · Castro Valley, CABuilt 1977 · S/N 15279406N714TAPaterson Fraser · Torrance, CABuilt 1977 · S/N 15279410N714TCJt Air LLC · Luling, LABuilt 1977 · S/N 15279412N714TFK2 Aviation LLC · Somerset, PAS/N 15279414
Back to AD 2009-10-09 R2