OpenAirDocs.org
AD 2012-10-13

Registered aircraft · 13,311

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.

N1087SVolitation Ventures LLC · El Macero, CABuilt 1996 · S/N EA-587N1088DSpf America LLC · Fort Smith, ARBuilt 2009 · S/N 421015N1088LLima Whiskey Ic LLC · Mertzon, TXBuilt 1995 · S/N E-2988N1089CRegistered aircraftBuilt 1995 · S/N E-2989N1089EAml Aviation LLC · Lexington, KYBuilt 1996 · S/N E-3030N108BGN108bg Co · Wilmington, DEBuilt 2011 · S/N 3RX164N108EZGraybull Aviation LLC · Lake Orion, MIBuilt 2006 · S/N 2037N108GPCoral Desert LLC · Andalusia, ALBuilt 2005 · S/N 1317N108LCTryzub Air LLC · Somerville, MABuilt 2013 · S/N 0535N108LMSkyvista Aviation LLC · Marysville, OHBuilt 1979 · S/N TJ-228N108LWTraceair LLC · Mountain Home, NCBuilt 2014 · S/N 0872N108MBBuchinsky Stephanie Lynn · West Plains, MOBuilt 1994 · S/N 29-0008N108VVCiferno Aviation LLC · Rostraver Township, PABuilt 2024 · S/N 9909N1091GUnderwood Mold Co Inc · Woodstock, GABuilt 1996 · S/N E-3001N1092YCbg Properties LLC · Madison, MSBuilt 1996 · S/N E-3045N1093GLombard William E · Bellingham, WABuilt 1996 · S/N TH-1793N1094GOgan Michael J · Pierre, SDBuilt 1996 · S/N TH-1794N1095ATychsen Scott E Trustee · Horse Shoe, NCBuilt 1996 · S/N E-2995N1096KSlocum Eugene A · Bozeman, MTBuilt 1996 · S/N EA-590N1096WOstroff Alan · Pleasanton, CABuilt 2023 · S/N 9053N1097GAos Aviation LLC · Baton Rouge, LAS/N E-3035N1097LInternational Air Services Inc Owner Trustee · Carson City, NVBuilt 2008 · S/N 421006N1097ZIndian Sky LLC · Bossier City, LABuilt 1997 · S/N E-3083N1098RSweat Kristie S · Buford, GABuilt 2021 · S/N 5010N1098WB & G Aviation LLC · Virginia Beach, VABuilt 1996 · S/N E-3043N1099AFritz William · Franklin, PABuilt 1997 · S/N E-3088N1099MSavery Creek Holdings LLC · Dixon, WYS/N EA-591N109CBSasser Edward Craig · Albemarle, NCBuilt 1975 · S/N 340-0533N109DWAero East USA LLC · Portage, INBuilt 1976 · S/N TJ13N109EADegiarde Robert P · New York, NYBuilt 1994 · S/N E-2897N109FTCisco Aero LLC · Cisco, TXBuilt 2006 · S/N 2025N109LLLewis & Lewis Equipment LLC · Dodge City, KSBuilt 1991 · S/N E-2626N109RCLentfer Clinton H A · Anchorage, AKBuilt 1974 · S/N U20602616N10ACNext Flight LLC · Nokomis, FLBuilt 2022 · S/N 8782N10BManasota Aviation LLC · Saint Petersburg, FLBuilt 2022 · S/N 8963N10BXCleary James A · Fairfield Township, OHBuilt 2021 · S/N 5003N10CDAvbase Flight Group Inc Trustee · Wilmington, DEBuilt 2012 · S/N 0350N10CNJones Carey N · Chesapeake, VABuilt 2015 · S/N 3RX060N10DCHbk LLC · Lynden, WAS/N U206-05366N10FLRandall P Roumillat · Dallas, TXS/N 21062892N10HQAndjul Aviation LLC · Palm Beach, FLBuilt 2024 · S/N 10243N10KKMensch Air LLC · Miami, FLBuilt 2022 · S/N 8975N10LJHarris Michael V · Wildwood, MOBuilt 1982 · S/N EA-276N10MCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 1084N10NFThompson Benjamin K · Nevada, TXBuilt 1976 · S/N TJ-64N10NNK&L Air LLC · Lakewood Ranch, FLBuilt 1994 · S/N E-2895N10PPWendellco LLC · Harlingen, TXBuilt 1983 · S/N 46-8408011N10PWAircraft Partner Holdings Inc Trustee · BerlinBuilt 1995 · S/N E-2950N10PXHls Equipment LLC · Spokane Valley, WABuilt 2016 · S/N 1453N10RAOne Six Bravo LLC · Kernersville, NCBuilt 2021 · S/N 5069
Back to AD 2012-10-13