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.

N4138PFreyburger Gregory P · Strykersville, NYBuilt 1959 · S/N 23-1619N4143PSparrowhawk Aviation · Manvel, TXBuilt 1959 · S/N 23-1624N4145PBlackhawk Holding Corp · Wilmington, DEBuilt 1959 · S/N 23-1626N4153PHilty Robert · Wheatland, WYS/N 23-1637N4157EBel Air LLC · Henderson, KYBuilt 1984 · S/N 31P-8414047N4159PSparks Brian E · Monmouth, ORBuilt 1959 · S/N 23-1644N415CCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 27-3908N415MDHammychan Industries LLC · Glendale, AZBuilt 1967 · S/N 27-3492N4160POgle Richard W Jr · Joplin, MOS/N 23-1645N4164PSeaplanes R Fun Inc · Wilmington, DEBuilt 1959 · S/N 23-1649N416GSB & K Travel LLC · Wilmington, DEBuilt 1975 · S/N 27-7554094N4170PIfa Aviation Inc · Wilmington, DEBuilt 1959 · S/N 23-1657N417GTLs Aerospace Inc · Big Spring, TXBuilt 1974 · S/N 27-7405467N4188PAero Club Valkaria LLC · Malabar, FLS/N 23-1676N4189PAdams Carlos · Hawi, HIS/N 23-1677N4191PBerry Michael C · Stanfield, AZBuilt 1959 · S/N 23-1679N4196PHarmon Aviation LLC · Exeter, NHBuilt 1959 · S/N 23-1684N4198BAero Flight Flying Club · Minneapolis, MNBuilt 1959 · S/N 23-1687N41DMMission Air LLC · Oklahoma City, OKBuilt 1959 · S/N 23-1566N41TNBvbd Aviation LLC · Charlotte, NCBuilt 1980 · S/N 31-8012034N4202PWells John · Eugene, ORBuilt 1959 · S/N 23-1691N42050Baum Thomas J · Kaufman, TXBuilt 1969 · S/N 27-4081N4209PN4209p LLC · Eagle River, WIS/N 23-1702N4217PInternational Air Services Inc Trustee · Carson City, NVS/N 23-1710N4218PPn4 Aviation Holdings LLC · Bishop, CAS/N 23-1711N422WBHbk LLC · Lynden, WABuilt 1977 · S/N 31-7752152N4239POneal Hollis R · Deridder, LABuilt 1959 · S/N 23-1737N423ACGv Air Inc · Medford, ORBuilt 1976 · S/N 31-7612044N4243PLandry Lonny R · Fort Worth, TXS/N 23-1742N4248PDavila Rudolfo G · Runge, TXFirst renewal noticeBuilt 1959 · S/N 23-1747N4252UDoitch Dan · Parowan, UTS/N 27-465N4253PBowles Alan B DBA · Georgetown, TXBuilt 1959 · S/N 23-1752N4254PPetersen Clayton L · Albert Lea, MNBuilt 1959 · S/N 23-1753N4259PSkypark Inc · Wadsworth, OHBuilt 1959 · S/N 23-1758N425RRValiair Lc Trustee · Casper, WYBuilt 1984 · S/N 42-5501008N425SQSpinola Hernandes M · Homestead, FLS/N 23-1376N4262PPower Willis H · Weatherford, TXS/N 23-1761N4264PFergason John S · Louisville, OHBuilt 1961 · S/N 23-1763N4268PAhlem Mark · Hilmar, CABuilt 1959 · S/N 23-1767N426SSale Reported · Kotzebue, AKSale reportedS/N 31-8152190N4276PNiec Steven M · Clio, MIBuilt 1959 · S/N 23-1775N427DDYunus Asim · Saginaw, MIBuilt 1978 · S/N 31T-7820029N427TAAircraft Properties LLC · Hampstead, NCBuilt 1977 · S/N 31T-7720027N4286PGress Gabrielle M · Davenport, FLBuilt 1959 · S/N 23-1786N4296PInvestair LLC · Conway, ARBuilt 1959 · S/N 23-1796N4299PAllison Daniel H · Whittier, NCBuilt 1959 · S/N 23-1799N429HPJohn Allen Construction LLC · Big Sandy, TNBuilt 1971 · S/N 274695N42DDG F E Management Inc · Elmira Heights, NYBuilt 1974 · S/N 31P-7400222N42HDMsm42h LLC · Jericho, NYBuilt 1980 · S/N 31-8152031N42HTP&M Partners LLC · Sumter, SCBuilt 1978 · S/N 31-7852106
Back to AD 2009-13-06 R1