AD 2012-03-06

Registered aircraft · 69,559

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-03-06')
    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-03-06')
  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.

N103ENKjs Development LLC · Temecula, CABuilt 1995 · S/N 4622186N103ERR & J Aviation LLC · Bloomfield Hills, MIBuilt 2016 · S/N 2321N103FDMidnight Echo LLC · Miami Lakes, FLBuilt 2024 · S/N 9838N103FFKnoll G C Jr · Clarendon, ARBuilt 1964 · S/N 1N103FPStyle Ventures LLC · Lafayette, LABuilt 2006 · S/N 42512N103FSHannah Lonnie · Williamson, WVBuilt 1979 · S/N 310R1834N103FVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280553N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023N103GSDuce Phillip N · Kotzebue, AKBuilt 1975 · S/N 6079CN103HMNoblett Ronald D · Bellaire, TXBuilt 2002 · S/N L2K-121N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153N103JGRam Aero Development Inc · Waco, TXBuilt 1979 · S/N 414A0264N103KEuroaviation Inc Trustee · KematenBuilt 2023 · S/N 10193N103KFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1999 · S/N 172S8143N103KSKent State University · Stow, OHBuilt 2005 · S/N 172S10093N103LCKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2021 · S/N 2281N103LHKavalair LLC Series D · Marion, MTBuilt 1980 · S/N TH-1170N103LLMoghaddas Ali · Westlake Village, CAS/N L2K-182N103LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280298N103MHCall One Inc · Clarinda, IABuilt 2010 · S/N 52N103MK2141 Corp · Wilmington, DEBuilt 2005 · S/N 1444N103MRDeepvine Partners LLC · Simonton, TXBuilt 2004 · S/N T20608455N103NCState Of North Carolina · Raleigh, NCBuilt 1999 · S/N 18280647N103PFQuality Protection Inc · Springfield, MOBuilt 2008 · S/N 411092N103PGHnd Operations LLC · Henderson, NVBuilt 1969 · S/N 30-1858N103PZRaging Thermal Sky Sports LLC · Brighton, COBuilt 2005 · S/N 25102CN103RCSonrise Aviation LLC · Portland, INBuilt 1977 · S/N 4040108N103RGTupelo Aeronautics Inc · Tupelo, MSBuilt 1975 · S/N MC358N103RMValiair Lc Trustee · Casper, WYBuilt 1975 · S/N 310R0109N103RRLancaster Flyers LLC · Fenwick Island, DEBuilt 1979 · S/N 32-7940097N103SEClear Prop Aviation LLC · Sioux City, IAS/N E-1099N103SJBarnick Air Holdings LLC · Santa Barbara, CABuilt 2000 · S/N 20608101N103SMHermack John F · Toms River, NJBuilt 1978 · S/N E-1267N103SVSun Valley Aviation Inc · Harlingen, TXBuilt 1998 · S/N 17280534N103TNArthur Lee E · Spring, TXBuilt 2008 · S/N 31-0103N103TXWilliams Bradley H Jr · Charleston, SCBuilt 2001 · S/N 18280984N103URankin Kenneth · Pinellas Park, FLBuilt 1986 · S/N 585N103WWWilkin Richard G · Monticello, ILBuilt 1961 · S/N CD439N1040FMarrs Matthew D · Bentonville, ARBuilt 1975 · S/N 18502697N1040JHefferon John W · Locust Grove, GABuilt 1973 · S/N 40N1040TTen Forty Tango LLC · Wichita, KSBuilt 1962 · S/N TC-318N1040UAmerican Aviation Inc · Brooksville, FLS/N 34-7250025N1040VWilliamson Peter D · Houston, TXBuilt 1976 · S/N R1722090N1040WFoolish Pleasure Aviation Inc · Lewes, DEBuilt 1979 · S/N D-10203N1040ZDonnelly Jeff E · Pembroke, MABuilt 2006 · S/N 3232062N10419C Flying K Aviation LLC · Black Hawk, COBuilt 1976 · S/N T21061484N1041CHelzer Timothy · Tucson, AZBuilt 2003 · S/N 270321N1041GN1041g LLC · Charlotte, NCBuilt 1981 · S/N 25-0567N1041HCentury Flight Systems Inc · Mineral Wells, TXBuilt 1977 · S/N 32R-7780125N10422Jackson Benjamin Tillman · Rancho Mirage, CABuilt 2004 · S/N 29-0323
Back to AD 2012-03-06