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.

N66254Beachy Matthew F · Russellville, KYBuilt 1974 · S/N 15075957N6625FManos Norman A · Omaha, NEBuilt 1966 · S/N 15063225N66260Schile James · Janesville, MNS/N 15075962N66261Gregor John P · Allentown, NJBuilt 1974 · S/N 15075963N66268Rahden Tiffany · Bellevue, WABuilt 1974 · S/N 15075967N6626FByler Joseph C · Spartansburg, PABuilt 1966 · S/N 15063226N6626SFast Aircraft Aerowork Corp · Miami, FLBuilt 1967 · S/N 15067426N66271Registration Pending · Waverly, IARegistration pendingBuilt 1974 · S/N 15075969N66273Delgadillo Jose M · League City, TXBuilt 1974 · S/N 15075970N66277Mcclure Wayne R · Anchorage, AKBuilt 1974 · S/N 15075972N6627FLeading Phase LLC · Ham Lake, MNS/N 15063227N6627GBelov Konstantin V · Sierra Madre, CABuilt 1970 · S/N 15072127N66281Alaska Sky School LLC · Anchorage, AKBuilt 1974 · S/N 15075974N6628SN6628s LLC · Arlington, TXBuilt 1967 · S/N 15067428N662BDMetcalf Charles M · Thomaston, GABuilt 1966 · S/N 15063664N6630SRoss Air Chicago LLC · Chicago, ILBuilt 1967 · S/N 15067430N66314Tan Cfi LLC · Plano, TXS/N 15075983N6631GRegistration Pending · Oak Creek, WIRegistration pendingBuilt 1970 · S/N 15072131N66322Barker Michael S · Stanford, KYS/N 15075986N66333Registration Pending · Cooksville, MDRegistration pendingBuilt 1974 · S/N 15075988N6633SRegistered aircraftBuilt 1967 · S/N 15067433N66349Kecy Kevin · Owls Head, MEBuilt 1974 · S/N 15075990N6635FJenkins Keith · Corralitos, CABuilt 1966 · S/N 15063235N6635SCoughanowr David D · Chatham, MABuilt 1967 · S/N 15067435N6636FChesterton Thomas W Jr · Watertown, MABuilt 1966 · S/N 15063236N66376Backhaus John W · Hampton, NHBuilt 1974 · S/N 15076000N66379Curry Zachary A · Loveland, COBuilt 1974 · S/N 15076003N66380Logan Thomas H · Canfield, OHBuilt 1974 · S/N 15076004N66383Tuskegee Airmen National Historical Museum · Detroit, MIS/N 15076007N66384Anderson Rick L · Valley City, NDBuilt 1974 · S/N 15076008N66386Registration Pending · Portage, MERegistration pendingBuilt 1974 · S/N 15076010N66387Bredvold Daniel M · Mendota Heights, MNS/N 15076011N66393Dash Roger A · Niles, MIBuilt 1974 · S/N 15076017N66394Y&S Aviation LLC · Oceanside, CAS/N 15076018N66395Murray Kevin D · Moneta, VABuilt 1974 · S/N 15076019N66397Petersen Bradley L · Bellingham, WABuilt 1974 · S/N 15076021N6639SMoen Richard C · West Dundee, ILS/N 15067439N66402King Dwayne W · Sutton, AKBuilt 1974 · S/N 15076025N6640FFlying High LLC · Gore, VABuilt 1966 · S/N 15063240N6640GKruckeberg Leroy A · Sanford, NCS/N 15072140N66412Farris Chad M · Bronte, TXBuilt 1975 · S/N 15076032N6641FKatzenberger Devin T · Little Falls, MNBuilt 1966 · S/N 15063241N6641GWalborn Carl L · Sun City, AZBuilt 1970 · S/N 15072141N66420Ware Charles W Jr · Atmore, ALBuilt 1974 · S/N 15076035N66422Zaleski-Johnson Laura · Mays Landing, NJBuilt 1974 · S/N 15076036N66425Biornstad John A · Big Lake, AKBuilt 1974 · S/N 15076039N6642FSomerset Flying Club · Basking Ridge, NJBuilt 1966 · S/N 15063242N6642GBurgmeier Peter W · North Vernon, INBuilt 1970 · S/N 15072142N6642SSellers Douglas D · Webster, NYBuilt 1967 · S/N 15067442N66437Fluno John I · San Anselmo, CAS/N 15076049
Back to AD 2009-10-09 R2