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.

N202JTHour Time Machine LLC · Bloomington, INBuilt 2002 · S/N 0230N203RFRapid Flyers LLC · Rapid City, SDBuilt 2003 · S/N 0453N204BRRand Joseph · Osprey, FLBuilt 2002 · S/N 0248N207DVWiseman Charles N · Midland, MIBuilt 2002 · S/N 0183N207WMG A Associates LLC · Port Orange, FLBuilt 2008 · S/N 3360N209JAHowen Kyle Verne · San Luis Obispo, CABuilt 2016 · S/N 4309N20CAState Of California Department Of Transportation · Sacramento, CABuilt 2019 · S/N 4844N20LN303cj LLC #1 · Lexington, KYBuilt 2008 · S/N 3195N210JEKoch Henry Thomas · Tampa, FLBuilt 2016 · S/N 4323N210TAN210ta LLC · Jupiter, FLBuilt 2023 · S/N 9077N2113QGlenelg Equipment Leasing LLC · Hanover, MDBuilt 2018 · S/N 4710N211ACJames P Hill Distributor Inc · Ruston, LABuilt 2019 · S/N 4787N211AWWeis Aaron · Waban, MABuilt 2005 · S/N 1278N211CMMoneypit Investment Corp · Wilmington, DEBuilt 2005 · S/N 1692N211LHLidzbarski Mark A · Southington, CTBuilt 2006 · S/N 1831N211SEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 2208N211TMPlane Fun Inc Tr Trustee · Snellville, GAS/N 3572N212BKVitesse Aviation Holding I LLC · Englewood, NJBuilt 2009 · S/N 3558N212MMOlver Keith B · Annapolis, MDBuilt 2002 · S/N 0403N212SRPegasus Flyers LLC · Queen Creek, AZBuilt 2006 · S/N 1871N213CAAble 1 Aviation Inc · Las Vegas, NVBuilt 2014 · S/N 4094N213CFSchantz David E Trustee · Raleigh, NCBuilt 2022 · S/N 8557N213CPTitsworth Richard D · Novi, MIBuilt 2008 · S/N 3142N213JWLipidex Corp · Marshfield, MABuilt 2004 · S/N 1089N213MLTrue Air Speed LLC · Saint Francisville, LABuilt 2020 · S/N 4886N213MPFly High Aircraft Sales LLC · Ocilla, GABuilt 2025 · S/N 10767N213PG213pg Inc · Chattanooga, TNBuilt 2022 · S/N 8702N213RJCrw Enterprise Holdings LLC · Newark, DEBuilt 2003 · S/N 0737N213SEAircraft Partner N213se Dst · BerlinS/N 2391N213SRDonegan Kevin M · Amissville, VABuilt 2006 · S/N 2100N213TBDonley John Roger · Eagle Lake, FLS/N 1056N213WDHamill Enterprises LLC · Reinholds, PABuilt 2004 · S/N 1121N214BBMessina Mark · Wallingford, CTBuilt 2001 · S/N 0085N214BRBaba Daniel · Glastonbury, CTBuilt 2007 · S/N 2318N214CLCx Aviation Inc Trustee · Wilmington, DEBuilt 2012 · S/N 3830N214CPHollis Roofing Inc · Columbus, MSS/N 3146N214CTValiair Limited Co Trustee · Casper, WYBuilt 2009 · S/N 3584N214DJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2003 · S/N 0746N214JGValiair Lc Trustee · Casper, WYS/N 2048N214TWRegistered aircraftBuilt 2004 · S/N 1225N214TXAdams Randy K · Spicewood, TXBuilt 2014 · S/N 4066N214VQSimply Living LLC · Fort Myers, FLBuilt 2011 · S/N 3808N215ALUdaan LLC · Vienna, VABuilt 2025 · S/N 11061N215EBSalty Air LLC · Wayne, PABuilt 2024 · S/N 9766N215EMPostma Air LLC · Saint Paul, MNS/N 2453N215JPPilot Peak Adventures LLC · Ely, NVBuilt 2007 · S/N 2493N215RRRednor Jeffrey · Yardley, PABuilt 2005 · S/N 1448N216DHRebel One LLC · Dover, DEBuilt 2015 · S/N 4270N216LBell John · Linville, NCBuilt 2004 · S/N 1111N216NGrb Aircraft Leasing LLC · West Fargo, NDBuilt 2008 · S/N 3117
Back to AD 2007-24-13