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.

N522SRDias Antonio M · Scottsdale, AZBuilt 2007 · S/N 2475N522VCommodore Aviation LLC · Danville, ALS/N 3951N522WMJaybirds Aviation LLC · Saint Cloud, MNBuilt 2003 · S/N 0670N522WTTme Cirrus LLC · Virginia Beach, VABuilt 2019 · S/N 4823N523CMMelrose Law Pllc · Waynesville, NCBuilt 2018 · S/N 4733N523GWA And P Farms LLC · Wilmington, DEBuilt 2019 · S/N 4832N523RKCirrus Design Corp · Duluth, MNS/N 11726N523RSN523rs LLC · Middletown, DEBuilt 2021 · S/N 5071N524CCAubuchon Scott M · Fenton, MIBuilt 2024 · S/N 9796N524DACpi Management Group LLC · Las Vegas, NVBuilt 2015 · S/N 4259N524ETWanderair LLC · Maple Grove, MNBuilt 2022 · S/N 8798N524PEN524pe LLC · Brookshire, TXBuilt 2025 · S/N 11043N524SRWaypoint Holdings LLC · Greensboro, GABuilt 2007 · S/N 2313N525BECya Aviation LLC · Saint Marys, WVBuilt 2001 · S/N 0136N525ECJohn Papa Zulu LLC · Hauppauge, NYBuilt 2014 · S/N 4039N525PCJcp Logistics LLC · Little Rock, ARBuilt 2025 · S/N 10589N525SRSchnitker Air LLC · Kalispell, MTBuilt 2006 · S/N 2165N5261WHodge Nicholas C · Spokane, WABuilt 2004 · S/N 0845N526CAM & M Aviation LLC · Pompano Beach, FLBuilt 2026 · S/N 11205N526HDTensor Air LLC · Atlanta, GABuilt 2022 · S/N 8887N526SCorvo Alberto · New York, NYBuilt 2005 · S/N 1667N526SRBarrow James E Jr · Keysville, GABuilt 2006 · S/N 2253N526TSN526ts LLC · Lake Charles, LABuilt 2018 · S/N 4675N527AGBroken Road Aviation LLC · Kerrville, TXBuilt 2006 · S/N 1770N527CDAircraft Medical Solution LLC · Kissimmee, FLBuilt 2005 · S/N 1628N527CPBimski Holdings LLC · Orem, UTS/N 3029N527CRJoe Wagner IV Construction LLC · Zebulon, NCBuilt 2010 · S/N 3577N527JKBeckair LLC · Ankeny, IABuilt 2008 · S/N 2950N527TRDawson Kevin · Colorado Springs, COBuilt 2002 · S/N 0265N527WWAirtime Flying Club LLC · Richmond, VABuilt 2008 · S/N 3118N528BJN528bj LLC · Sandyville, WVBuilt 2022 · S/N 8884N528CAWile Frederick A · Meridian, MSBuilt 2026 · S/N 11208N528DBRegistered aircraftBuilt 2015 · S/N 4248N528DLLlt LLC · Middleton, WIBuilt 2022 · S/N 9004N528HEKingdom Airworks LLC · Las Vegas, NVBuilt 2005 · S/N 1409N528MOcala Gator Aviation LLC · Ocala, FLBuilt 2017 · S/N 4470N528PCWhere 2 LLC · Las Vegas, NVBuilt 2016 · S/N 4404N528PFEarspasm LLC · Brooklyn, NYBuilt 2015 · S/N 4231N528SMSpeedishtong Aviation LLC · Deer Park, ILBuilt 2023 · S/N 9080N528SRAaa Flying Club Inc · Fort Wayne, INS/N 2314N529AJCaiazzo Leonard · Belle Harbor, NYBuilt 2004 · S/N 1242N529BKFlying Offices LLC · Princeton, MABuilt 2013 · S/N 4003N529BLLevair LLC · Edmond, OKBuilt 2019 · S/N 4749N529CDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 1621N529MKBlue Ryan LLC · Englewood, COBuilt 2005 · S/N 1590N529PVVlahos Aviation LLC · Destin, FLBuilt 2023 · S/N 9508N529SRGreaney White & Associates Inc · Valley, ALBuilt 2006 · S/N 2266N52DGVero Beach Aviation LLC · Vero Beach, FLBuilt 2024 · S/N 10226N52PJJensen Paul · Highland Village, TXBuilt 2004 · S/N 0850N52SAByrd Aircraft Solutions LLC · Dothan, ALBuilt 2006 · S/N 2139
Back to AD 2007-24-13