AD 2007-24-13

Registered aircraft · 4,026

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:2007-24-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:2007-24-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.

N216PBDivine Air LLC · Brookshire, TXBuilt 2025 · S/N 10924N217CEHardgrave Kenneth K · Texas City, TXBuilt 2011 · S/N 3812N217CPAlbie Air LLC · Wake Forest, NCS/N 3147N217ETAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2010 · S/N 3637N217GMMarcom Michael D · Valley View, TXBuilt 2010 · S/N 3688N217SLJ & J Aviation LLC · Lafayette, LABuilt 2017 · S/N 4539N217SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2118N217TJBb Air LLC · Fayetteville, NCBuilt 2006 · S/N 2291N218DPSmb Consulting And Investing LLC · Jamison, PABuilt 2006 · S/N 1800N218EMAir Travel & Transportation Services LLC · Atlantic Beach, FLBuilt 2007 · S/N 2511N218LJFoster James L · Bryan, TXBuilt 2007 · S/N 2673N218LMKrause Cody · Clear Lake, SDBuilt 2003 · S/N 0501N218PM218pm LLC · Fort Collins, COBuilt 2002 · S/N 0201N218SRTs Joyce Aviation LLC · West Fargo, NDBuilt 2006 · S/N 2074N218WTAirflo Aviation LLC · Banner Elk, NCBuilt 2014 · S/N 4036N218XBulzan Lawrence Mitchell · Concord Township, OHBuilt 2004 · S/N 1134N219PMPmm Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 2756N21CBTailworks LLC · Seabrook, TXBuilt 2018 · S/N 4683N21DCDlc Aviation LLC · Lattingtown, NYBuilt 2018 · S/N 4632N21EQBernoulli Otto Wright & Parkinsons Contraption LLC · Mansfield, CTBuilt 2005 · S/N 1457N21FPJet There LLC · Cedar Rapids, IABuilt 2024 · S/N 9826N21GTDesign Leasing Group LLC · Pittsburgh, PABuilt 2017 · S/N 4450N21KTTatkowski Dorota · Mount Prospect, ILBuilt 2024 · S/N 10245N21LZKrishna Group Inc · Oklahoma City, OKS/N 0267N21TENational Test Pilot School · Mojave, CABuilt 2004 · S/N 0964N21UKInternational Air Services Inc Trustee · Carson City, NVS/N 2311N21WEMingst Barry Chris · Bellevue, WABuilt 2009 · S/N 3370N21YYShep Air Inc · Cedar Rapids, IABuilt 2005 · S/N 1664N220Atlantic Coast Aviation Inc · Dover, DEBuilt 2002 · S/N 0177N220ADSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2010 · S/N 3697N220AMLungley George · New Albany, OHBuilt 2010 · S/N 3635N220CDChiller Aviation LLC · Missoula, MTS/N 0019N220EBJag Aviation LLC · South Easton, MABuilt 2024 · S/N 10325N220GKHotel Bravo Aviation LLC · Alexandria, OHBuilt 2009 · S/N 3437N220MRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2011 · S/N 3779N220SRBriar Flyer LLC · Bedford, NHBuilt 2002 · S/N 0391N221AWChapman Lawrence N · Placerville, CAS/N 0758N221BMOne Bravo Mike LLC · Wilmington, DEBuilt 2006 · S/N 1901N221CDJaffee Robert · Victoria, MNBuilt 2001 · S/N 0093N221EDRegistration Pending · Christiansburg, VARegistration pendingBuilt 2022 · S/N 8774N221GWPink Ibis Air LLC · Vero Beach, FLS/N 0381N221JAInner Air Ity LLC · Pensacola, FLBuilt 2007 · S/N 2416N221PHFlorida Flight Physical LLC · Crystal River, FLBuilt 2019 · S/N 4872N221RPPastor Randall J · Granite Bay, CABuilt 2004 · S/N 0878N221TXSooner Aviation LLC · Helena, MTBuilt 2007 · S/N 2468N2225Ica Aviation LLC · Alexandria, VABuilt 2018 · S/N 4614N222BGBeaumont David Matthew · Orcutt, CABuilt 2004 · S/N 1095N222BTBt4 Holdings LLC · The Villages, FLBuilt 2018 · S/N 4726N222BUDarrowby LLC · Medina, MNBuilt 2026 · S/N 11318N222EDInternational Air Services Inc Trustee · Carson City, NVBuilt 2004 · S/N 1103
Back to AD 2007-24-13