OpenAirDocs.org
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.

N246JAN246ja LLC · Parsons, TNBuilt 2025 · S/N 10448N246JPCarolina Aviation Partners LLC · Winston Salem, NCBuilt 2019 · S/N 1844N246JWPierson Janice R Trustee · Scio, ORBuilt 1981 · S/N 340A1253N246KAStahl Richard J · Gainesville, TXBuilt 1984 · S/N 340A1817N246MTKolquist Consulting LLC · Hermantown, MNBuilt 2003 · S/N 0760N246PCLna Flyer LLC · West Palm Beach, FLBuilt 1998 · S/N 29-0173N246PLRff Holdings LLC · Paris, MOBuilt 2023 · S/N 9219N246PTShultz L Edward · Brentwood, TNBuilt 2017 · S/N 4505N246RCeilo Aviation LLC · Miami, FLBuilt 2024 · S/N 10176N246TDCg5t LLC · Greenwood Village, COBuilt 2013 · S/N 0674N246TJLally Glen Joseph · Pleasanton, CAS/N 0382N246TWMr Dent Inc · Manheim, PAS/N 0725N246WHLakehouse Aviation LLC · Peoria, ILBuilt 2019 · S/N 1982N246WTKilloran Ron · Buffalo, NDBuilt 2011 · S/N 0098N247AFlying Carpet 247 LLC · Logan, UTBuilt 2021 · S/N 2326N247ABFlight Insite LLC · Atlanta, GABuilt 2019 · S/N 2029N247ALOrtho Aviation LLC · Midland, TXBuilt 2022 · S/N 8821N247ASA & S Aviation Services Llp · EsherBuilt 2024 · S/N 10005N247CPTl Sierra Properties LLC · Mammoth Lakes, CABuilt 2008 · S/N 3166N247DMGrimmett Lester · Clinton, MSBuilt 2005 · S/N 41506N247GMSijan LLC · Marriottsville, MDBuilt 2022 · S/N 8753N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637N247LVRlv Aviation LLC · Valdosta, GABuilt 2025 · S/N 10854N247MFsvc Aero Inc · Wilmington, DES/N 288N247SRPsalmbird Aviation LLC · Ormond Beach, FLBuilt 2007 · S/N 2457N247TSCrosswind Aviation LLC · Enid, OKBuilt 2015 · S/N 4280N247WMNsfm Av LLC · Page, AZBuilt 2022 · S/N 8626N247WYBrimen Aviation LLC · Brookings, SDBuilt 2026 · S/N 11368N248G E Flight Services LLC · Clarksdale, MSBuilt 2001 · S/N EA-678N2480SAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 21061299N2484FJones William Ransom · Anchorage, AKBuilt 1966 · S/N 18051686N248APRegistered aircraftBuilt 2006 · S/N 42541N248ASLlama Cirrus LLC · Concord, MABuilt 2017 · S/N 4537N248CGStahura Conveyor Products Inc · Lewisville, NCBuilt 2001 · S/N 0092N248CRDirect Path Flight Services LLC · Bingham Farms, MIBuilt 2023 · S/N 9126N248DGWhinery Kevin D · La Habra, CABuilt 2005 · S/N 1359N248DMMontana 248dm LLC · Kalispell, MTBuilt 2002 · S/N 0374N248GFollett Enterprises LLC · Vlg Of Lakewd, ILBuilt 2005 · S/N 1261N248JTRegistered aircraftBuilt 2025 · S/N 10905N248KMAutomated Ag Systems LLC · Moses Lake, WABuilt 2016 · S/N 1458N248LFLima Foxtrot Inc · San Rafael, CABuilt 2020 · S/N 2128N248LKTwelve Forty-Eight Aviation LLC · Camden, DEBuilt 2025 · S/N 10819N248PZPapa Zulu LLC · Belmont, MABuilt 2025 · S/N 10569N248SHWaldron Aviation LLC · Fort Lauderdale, FLBuilt 2002 · S/N 0146N248SPStallion Paving LLC · Austin, TXBuilt 2025 · S/N 10519N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306N249CKCarolina Landing LLC · Cambridge, MDBuilt 2003 · S/N 0766N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249N249SAGribble Ted A · Paris, TXBuilt 2001 · S/N 29-0267N249WSSmith Charles L III · Petaluma, CABuilt 2004 · S/N 0975
Back to AD 2012-10-13