AD 2012-10-13

Registered aircraft · 13,306

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

N798BBFlyboys LLC · Mobile, ALBuilt 2005 · S/N 1435N798CBEye See Express LLC · Scottsdale, AZBuilt 2005 · S/N LIV-549N798GMJust US Pilots Inc · Clearwater, FLBuilt 1998 · S/N E-3184N798HBN798hb LLC · Blanding, UTBuilt 2016 · S/N 1411N798JBMidwest Aircraft LLC · Olathe, KSBuilt 2002 · S/N E-3468N798RJMaklee Enterprises LLC · Taylor, TXBuilt 2006 · S/N 1811N799CDGpa Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1543N799DGCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11580N799EEMiller Robert D · Big Spring, TXBuilt 2025 · S/N 10761N799ESFive Boys Flight Training LLC · Matthews, NCBuilt 1981 · S/N 414A0657N799KTAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N U20603580N799LFSurric LLC · Shreveport, LABuilt 2021 · S/N 5038N799SRMontauk Rumrunners LLC · East Hampton, NYBuilt 2007 · S/N 2799N79AHBmac3 LLC · Fairfield, CTBuilt 2017 · S/N 4542N79ALAirtrust LLC - 19 - Series 19 Trustee · Sheridan, WYBuilt 2026 · S/N 11317N79APHigh Tide Aviation LLC · Naples, FLBuilt 1979 · S/N TJ206N79ASPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 340A1248N79BPOrion 207 LLC · Harpswell, MEBuilt 1979 · S/N 414A0263N79CHPala Angel E · Taos, NMBuilt 1978 · S/N 21062615N79CVVne Aviation LLC · Fort Walton Beach, FLBuilt 2021 · S/N 2329N79CWWeber Cynthia J · Dallas, TXBuilt 2025 · S/N 10690N79DCBnb Marine LLC · Miami, FLS/N 414A0212N79DRMcneill Steve · Santa Fe, NMBuilt 1994 · S/N EA-559N79DSBonanza Air Ventures LLC · Mammoth Lakes, CABuilt 1982 · S/N EA-326N79DVDiscovery Associates Inc · Midland, TXBuilt 1979 · S/N P21000233N79EMLone Mountain Aircraft LLC · Vandalia, OHBuilt 2023 · S/N 9399N79FMWoods Executive Services Inc · Mineola, TXBuilt 1999 · S/N 29-0179N79FWDaniel King Aviation LLC · Dover, DEBuilt 1979 · S/N 414A0278N79GWEight Charlie Tango Inc · Redmond, WABuilt 2019 · S/N 1988N79HCBmc Group · Hawthorne, CABuilt 1990 · S/N E-2538N79HHOverland Aviation LLC · Plymouth, MNBuilt 2006 · S/N 2282N79MKKarger Marjorie · Graford, TXBuilt 2024 · S/N 10251N79PPJon Gibson Co · Cameron Park, CABuilt 1980 · S/N 414A0516N79RCBach II LLC · Lafayette, LABuilt 1982 · S/N 21064697N79RXC Howard Aviation LLC · Rock Spring, GABuilt 2006 · S/N 2066N79SMTurbine Services And Consulting LLC · Bedford, TXBuilt 1995 · S/N 29-0028N79WJGdm Holdings LLC · Hartford City, INBuilt 2020 · S/N 2179N79WP79wp LLC · Scott City, KSBuilt 2012 · S/N 0354N79XCD & J Construction And Real Estate LLC · Jupiter, FLBuilt 2016 · S/N 1288N79YF79yf LLC · Phoenix, AZBuilt 2007 · S/N 2343N7AVPerkins Steven · Mount Juliet, TNBuilt 2004 · S/N 1053N7CJPropart Inc · Austin, TXBuilt 1990 · S/N E-2575N7CNMentor Flight LLC · Savoy, ILBuilt 1955 · S/N 52-8272N7EESeven Echo Echo LLC · Missoula, MTBuilt 2021 · S/N 5086N7EVYellow Star Mgmt LLC · Waco, TXBuilt 1998 · S/N E-3162N7JKosco Matthew D · Munster, INBuilt 2000 · S/N E-3316N7JNB & K Steel & Supply Inc · Ogden, UTBuilt 2000 · S/N EA-663N7LTRobertson Cameron Lee · Las Vegas, NVS/N 21060936N7LVBas Part Sales LLC · Greeley, COBuilt 1980 · S/N P21000506N7MFBarger Christopher H Trustee · Mesa, AZBuilt 1980 · S/N P21000583
Back to AD 2012-10-13