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.

N321BGItinerant Orl LLC · Columbia, SCBuilt 2005 · S/N 1311N321BRFlyingu LLC · Austin, TXBuilt 2005 · S/N 1489N321CFTekswork Aviation LLC · London, KYBuilt 2002 · S/N 0304N321ETVlt Aviation LLC · Tampa, FLBuilt 2025 · S/N 10940N321FLSkywalker Aviation LLC · Saint Paul, MNBuilt 2009 · S/N 3392N321GKBrown Water Associates LLC · Monticello, FLBuilt 2015 · S/N 4290N321HBYosemite Axe Throwing · North Fork, CABuilt 2015 · S/N 4257N321HTPartnairs LLC · Lake Charles, LABuilt 2015 · S/N 4246N321JJJayjet Private Aircraft Charter LLC · Swanton, OHBuilt 2004 · S/N 1113N321MTIflyhi Aviation LLC · Sanbornton, NHBuilt 2005 · S/N 1696N321PMPilotpros Training LLC · Longview, TXBuilt 2011 · S/N 3827N321SETesla Aviation LLC · Mount Pleasant, SCBuilt 2006 · S/N 2089N321WGCirrus Design Corp · Duluth, MNS/N 11706N321WRFord Paul · Princeton, NJBuilt 2002 · S/N 0269N322AMProfessional Pilots LLC · Duluth, MNBuilt 2015 · S/N 4199N322CDGnc Industries Inc · Pocahontas, ARBuilt 2005 · S/N 1272N322CWGallagher Maria J · Lakewood Ranch, FLBuilt 2004 · S/N 1098N322MSMes Fire Investigations Inc · Wilmington, DEBuilt 2009 · S/N 3583N322PTMaloy Aviation LLC · Telluride, COBuilt 2008 · S/N 2930N322TWRegistration Pending · Fairview, NCRegistration pending, pending cancellationBuilt 2002 · S/N 0312N322WAAlderman & Company Wings LLC · Danbury, CTBuilt 2004 · S/N 0811N323CDMesibov Steven · Deland, FLBuilt 2004 · S/N 1020N323KCBig Blessing LLC · Saint Louis, MOBuilt 2015 · S/N 4273N323KGN1234 LLC · Costa Mesa, CABuilt 2020 · S/N 4879N323RBAvion Flight Services LLC · Rome, GABuilt 2012 · S/N 3906N323TLPrime Aviation Leasing LLC · Westlake, TXBuilt 2014 · S/N 4035N323WWhitewings Aviation LLC · Milton, GABuilt 2005 · S/N 1509N323WDDurand Paul C · Osceola, WIBuilt 2006 · S/N 2085N324BRBlue Ridge Aviation Holdings LLC · Boone, NCBuilt 2015 · S/N 4194N324RDGood Voyage LLC · Sullivans Island, SCBuilt 2021 · S/N 5134N324SRThree Bell Aviation LLC · Dallas, TXBuilt 2007 · S/N 2458N325A325a LLC · Lecanto, FLBuilt 2006 · S/N 2150N325CLRobin Motorsports And Aviation LLC · Windermere, FLBuilt 2008 · S/N 3061N325CPRachke Aviation LLC · Gardner, ILBuilt 2008 · S/N 3246N325PZCirrus Design Corp · Duluth, MNS/N 11693N325SHSsh Aero LLC · Saint Louis, MOBuilt 2022 · S/N 8660N326AKN326ak LLC · Georgetown, DEBuilt 2009 · S/N 3436N326CDOshoot Inc · Seabrook Beach, NHBuilt 2009 · S/N 3575N326CPCirrus-2-Own LLC · Bellaire, TXBuilt 2008 · S/N 3133N326DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 3517N326SRCharlie Tango Aviation LLC · Miami, FLBuilt 2006 · S/N 1934N326TKClark Shawn B · Fairhope, ALBuilt 2003 · S/N 0716N3272DTesk Aviation LLC · Steele, MOBuilt 2018 · S/N 4636N327AMSchmidt Steven P · West Springfield, VABuilt 2003 · S/N 0691N327DTLafferty Jason · Marana, AZBuilt 2004 · S/N 0972N327EEEmpresas Marex Inc · Mayaguez, PRBuilt 2015 · S/N 4170N327RHInfineon Properties Of Montana LLC · Helena, MTS/N 0958N327SRBisous Dange LLC · Virginia Beach, VABuilt 2006 · S/N 2122N328CPX Aviation LLC · Brooksville, FLBuilt 2008 · S/N 3248N328DKHigh Flight Adventures LLC · Ogden, UTBuilt 2006 · S/N 1749
Back to AD 2007-24-13