OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,130

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-13-06-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:2009-13-06-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.

N837HBKellum Mark · Belden, MSBuilt 1978 · S/N 27-7954021N83BFHayssen Arthur H · Sebastopol, CABuilt 1976 · S/N 27-7654171N83CACheyenne 2 LLC · Colonial Heights, VABuilt 1980 · S/N 31T-8020072N83JWCarpe Diem Aviation LLC · Cleveland Heights, OHBuilt 1979 · S/N 27-7954034N83MGWatkins Jon Trustee · Florence, ORBuilt 1981 · S/N 31T-8104047N83MHStich Michael A · Malvern, OHBuilt 1969 · S/N 27-4302N83PAHill Enterprise Inc · Wilmington, DEBuilt 1981 · S/N 31-8112050N83WCRegistered aircraftBuilt 1966 · S/N 27-3281N843DBDoan Creek LLC · Walla Walla, WABuilt 1978 · S/N 31T-7820090N847Ultimate Resort Vacations Inc · Weston, FLBuilt 1977 · S/N 31-7812020N849DWCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 317952070N851PAFlorida Coastal Flying Club LLC · Titusville, FLBuilt 1957 · S/N 23-851N8595BGreene County Vocational School District · Xenia, OHS/N 27-7305127N85RJTechnical Education Services Inc · Virginia Beach, VAS/N 27-7554127N862ARLe Pichon II LLC · San Juan, PRBuilt 1982 · S/N 31-8212019N867DCAir Enterprises LLC · Dover, DEBuilt 1961 · S/N 27-62N868ETSale Reported · Eagle OranjestadSale reportedBuilt 1973 · S/N 31-7305063N86VADe Leon Inc · Perth Amboy, NJS/N 31-7952020N879CSAviatzone LLC · Fort Lauderdale, FLS/N 31-7712033N87AJdkracl Aircraft LLC · Gretna, NEBuilt 1970 · S/N 27-4594N880RCPuerto Rico Aircraft Leasing Corp · Ceiba, PRBuilt 1973 · S/N 31-7305022N885HAFox Airways LLC · Wasilla, AKS/N 31-7405416N888JJGst Inmotion LLC · Kalispell, MTBuilt 1978 · S/N 317852078N888LMAir Mods And Repair · Robbinsville, NJS/N 31-7405464N888PCAirmonarc LLC · Orlando, FLBuilt 1981 · S/N 31-8152086N888PEPacific Flight Academy LLC · Honolulu, HIBuilt 1977 · S/N 27-7754066N888RJMongini David · Cottonwood, AZBuilt 1973 · S/N 27-7305139N888TGSkylens LLC · Hammond, LABuilt 1976 · S/N 27-7654032N888WPVantage Point Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 27-3561N888YAAds-B Technologies LLC · Anchorage, AKS/N 31-7305076N88DEMatta Figueroa Eduardo · Chapman, KSBuilt 1959 · S/N 23-1618N88KJLegal Air LLC · Charleston, WVS/N 31-7912077N88NPRegistration Pending · Saint Petersburg, FLRegistration pendingBuilt 1976 · S/N 27-7754006N88PZ88pz LLC · Clifton Park, NYS/N 27-7754112N88SHSmith Jeary K · Greenfield, INBuilt 1973 · S/N 27-7304930N88TGMakushin Logistics LLC · Fairbanks, AKBuilt 1984 · S/N 31-8452020N88TLAh Legacy LLC · Orlando, FLBuilt 1980 · S/N 31-8152066N88VBBjelland Richard A · Galt, CABuilt 1967 · S/N 27-3609N88ZMFlorida Aero Services Sales Division Inc · Brandon, FLBuilt 1976 · S/N 31-7752016N890HMarc Inc · Bolton, MSBuilt 1980 · S/N 31-8052194N891CBKal-1 LLC · Wichita, KSBuilt 1980 · S/N 31-8012064N892MMWings Of Dubuque LLC · Dubuque, IABuilt 1980 · S/N 31-8112029N892TGTeo Steel Inc · Ramer, TNBuilt 1980 · S/N 31-8012053N892TWTeo Steel Inc · Ramer, TNBuilt 1978 · S/N 31-7812111N893CBAec Navajo LLC · Wilmington, DES/N 31-8012007N89BRN89br LLC · Wilmington, DEBuilt 1967 · S/N 27-3618N89JASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 31T7920030N89SLMclain Scott S · East Troy, WIBuilt 1956 · S/N 23-602N89VVAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1973 · S/N 27-7405254N8APMatthews Aviation LLC · Hardinsburg, KYBuilt 1973 · S/N 27-7305072
Back to AD 2009-13-06 R1