OpenAirDocs.org
AD 2009-13-06 R1

Registered aircraft · 2,131

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.

N15YPDepartamento De Educacion Prami · San Juan, PRBuilt 1968 · S/N 27-3966N160DBAguilar Theodore · Bozeman, MTBuilt 1959 · S/N 23-1670N161MRVictor Aircraft Co · Wilmington, DEBuilt 1977 · S/N 27-7754106N165SWN165sw LLC · Lagrange, GAS/N 31T-7904051N165TTMakushin Logistics LLC · Fairbanks, AKS/N 318452005N16SCWestern Alaska Aircraft Leasing LLC · Pahrump, NVBuilt 1970 · S/N 31-639N16YPSebastian Aero Services Inc · Guaynabo, PRBuilt 1982 · S/N 31-8252008N1707TMoore Merritt T II · Silver Creek, NYBuilt 1955 · S/N 23-299N170TAKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1975 · S/N 27-7654005N1715YPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654096N171JPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 31T-7720028N177Executive Travel Authority LLC · Wilmington, DEBuilt 1970 · S/N 27-4511N178GPanhandle Groundwater Conservation District · White Deer, TXBuilt 1980 · S/N 27-8054028N178MSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1979 · S/N 27-7954028N178SGTango Tango LLC · Naples, FLS/N 31T-8020044N179RMRaven Air LLC · Coral Gables, FLBuilt 1979 · S/N 31-7912074N17AFRolle Caraine A · Cypress, TXBuilt 1973 · S/N 27-7405291N17AKFrancis Joseph · Kure Beach, NCBuilt 1978 · S/N 27-7854103N17FWhiteside Andrew A · Essexville, MIBuilt 1954 · S/N 23-119N17PSNorris C · Land O Lakes, FLBuilt 1976 · S/N 31P-7630008N17WEMckinney Joe M · Tuscumbia, ALBuilt 1978 · S/N 27-7854118N181DCAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedS/N 31T-7520026N18269International Aviation Group LLC · Lake Wales, FLBuilt 1959 · S/N 23-1705N184DGMartin Vicente Eduardo Misa · Miami, FLBuilt 1964 · S/N 27-2504N186GADavis Aviation Inc DBA · Brandon, MSS/N 31T-7820086N186SLJls Property Holdings LLC · Athens, TXS/N 23-236N1872EAmerican Valet Air Inc · Wilmington, DEBuilt 1980 · S/N 31-8052114N1872HDodson International Parts Inc · Rantoul, KSBuilt 1975 · S/N 31-7652053N189SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 31-7512045N18HLBusinessliner Inc · Ft Lauderdale, FLBuilt 1980 · S/N 31-8052055N18MWRed State LLC · Daytona Beach, FLBuilt 1967 · S/N 27-3691N18RJDocs Air LLC · Diamondville, WYS/N 27-4382N18RLAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952090N190CAJag Air LLC · New Castle, DES/N 42-8001028N191AMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 31P-7630012N192CSDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 31P-7300138N1946DArctic Barnabas Ministries · Kenai, AKS/N 27-8054015N194MLGofly Trading LLC · Opa Locka, FLBuilt 1979 · S/N 27-7954081N195AAAir Travel Management LLC · Lemont Furnace, PABuilt 1978 · S/N 31T7904001N196AGMarc Inc · Bolton, MSS/N 31-7952036N196DBBe Right Back Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 27-7405273N1976JLock Haven Aircraft Sales · Lock Haven, PABuilt 1974 · S/N 31T-7520005N19CBCirrus Flying Professionals LLC · Hollywood, FLS/N 31-7752012N19KCGrays Bay LLC · Warrenton, ORBuilt 1970 · S/N 274516N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478N1GLSmith Alfred N D IV · Lake Wylie, SCBuilt 1967 · S/N 27-3826N1SRRensberger Scott C · Lake Jackson, TXBuilt 1962 · S/N 27-2050N1SYPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654186N2007P2007 Papa LLC · Fayetteville, GABuilt 1956 · S/N 23-579N200CXPotter Aviation LLC · Milford, NJBuilt 1984 · S/N 31P-8414042
Back to AD 2009-13-06 R1