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.

N74LCLee County Sheriffs Office · Ft Myers, FLBuilt 1972 · S/N 21059755N74MFCarl Raymond Baker LLC · Brenham, TXBuilt 1981 · S/N TJ-397N74MLHowie Aviation LLC · Bellaire, TXBuilt 2020 · S/N 4982N74MMFief Ron C · Creede, COBuilt 1974 · S/N 21060375N74MTKopair LLC · Saint Louis, MOBuilt 2000 · S/N EA-659N74PBBaranko Peter A · Meridian, IDBuilt 1981 · S/N 414A0828N74RMGrimes Taylor · Odessa, TXBuilt 1976 · S/N 21061694N74SACloud Aviation LLC · Lagrange, OHBuilt 2006 · S/N 1994N74TZTzero Aviation LLC · Warrenton, VABuilt 2017 · S/N 1598N74UKAccelero LLC · Alabaster, ALBuilt 2016 · S/N 1322N74WJVicari Aviation LLC · Harvey, LABuilt 1988 · S/N E-2458N7505NMiller Mary Lou · Dothan, ALBuilt 1968 · S/N E-36N750DBBearpack LLC · Boulder City, NVBuilt 2005 · S/N 29-0355N750DCHills Alan · Youngsville, NCBuilt 1997 · S/N 29-0123N750NTEle Motorsports LLC · Dover, DEBuilt 1978 · S/N U20604230N750PCMarilyn Merlot LLC · Kalispell, MTBuilt 1972 · S/N 340-0189N7516QS Flight LLC · Evergreen, COBuilt 1972 · S/N 310Q0530N751ADPeters Abraham · Copeland, KSBuilt 2002 · S/N 0313N751APAmdent Air LLC · Wyomissing, PABuilt 2005 · S/N 1446N751CAHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0217N751JBJhs Management LLC · Kiel, WIBuilt 2016 · S/N 1470N751PPPlane White Corporation · Sunriver, ORBuilt 1999 · S/N E3260N751PSBruinwald LLC · Vancouver, WABuilt 2011 · S/N 0245N751SBRosen Gary J · Manchester, MABuilt 2026 · S/N 11423N752CTScott Anthony · Frisco, TXBuilt 2008 · S/N 3290N752MBEpic Equipment Rentals Inc · Temecula, CABuilt 2015 · S/N 1174N752PSPneumotronic Aviation LLC · Bismarck, NDBuilt 2010 · S/N 0012N752SBKevu Aviators LLC · Maryville, MOBuilt 2003 · S/N 0773N7530QBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 310Q0030N7532NEagle Air LLC · Morgantown, WVBuilt 1977 · S/N U20603664N753DMAcid And Cementing Inc · Palestine, TXBuilt 2002 · S/N TH-2047N753MNR J Enterprise Inc · Newark, DEBuilt 2004 · S/N 41027N753PAN753pa LLC · Greenland, NHBuilt 2013 · S/N 3937N753PSWagner Adam C · Addison, TXBuilt 2012 · S/N 0309N754APPetrollini Alex · Mesa, AZS/N 2871N754DJIsaiah 4031 LLC · Dexter, MNBuilt 2010 · S/N 3671N754JSDy34 LLC · Adamsville, TNBuilt 1975 · S/N 414-0643N754PSPacific Horizons LLC · Port Angeles, WAS/N 0464N754RFAirtool LLC · Gardena, CABuilt 2009 · S/N 3378N754SRPlane Fun Inc Tr Trustee · Snellville, GABuilt 2007 · S/N 2629N7556QKent Schreiber Company · Greencastle, PABuilt 1972 · S/N 310Q0604N755CMelina Aviation Inc · Wilmington, DES/N 0392N755CDCirus N755cd LLC · Aventura, FLBuilt 2001 · S/N 0121N755CGAir Share LLC · Zephyr Cove, NVBuilt 2004 · S/N LIV-393A-SFBN755CPDardis Stanley K · Woodbury, MNBuilt 2008 · S/N 3174N755EETango Kilo Aviation LLC · Sagle, IDBuilt 2016 · S/N 1276N755GHJeff Hux Farms LLC · Sikeston, MOBuilt 1997 · S/N TH-1838N755GSInfinitymail Corp · Pleasanton, CABuilt 2004 · S/N 0983N755HBBrown William Henry · Ravenna, TXBuilt 1979 · S/N 18053018N755HSAs Aviation LLC · Englewood, NJBuilt 2021 · S/N 5076
Back to AD 2012-10-13