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

N145SRTiger Jones Aircraft Inc · Tampa, FLBuilt 2022 · S/N 9010N1468CBruegman Colt Trustee · Wheatland, WYBuilt 2003 · S/N 0574N146AFIn A Bind LLC · Conway, SCS/N 8727N146DMValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 10233N146GSKyser LLC · Wilmington, DEBuilt 2007 · S/N 2393N146SBN146sb LLC · Vienna, VABuilt 2007 · S/N 2574N146WTLevanders Aircraft II LLC · Grand Island, NEBuilt 2002 · S/N 0324N147GTFlying W Aviation LLC · Bossier City, LABuilt 2004 · S/N 1069N147KB1869 Holding Inc Owner Trustee · Wilmington, DEBuilt 2006 · S/N 1869N147LD1944 Holding Inc Trustee · Wilmington, DEBuilt 2004 · S/N 0937N147LKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1687N147MDDym Flights LLC · Pembroke Pines, FLBuilt 2025 · S/N 10839N147PBGrh Inc · Wilmington, DEBuilt 2005 · S/N 1291N147VC0689 Holdings Inc Trustee · Wilmington, DEBuilt 2003 · S/N 0689N147WLRj Aviation LLC · Linden, CABuilt 2005 · S/N 1454N1487CDuley Brian · Lago Vista, TXBuilt 2003 · S/N 0571N148CZJ5 Aviation LLC · San Diego, CABuilt 2012 · S/N 3888N148MBRosenberg Benjamin E · Mantoloking, NJBuilt 2024 · S/N 10291N148SWHess Daniel A · Cookeville, TNBuilt 2004 · S/N 0987N148TSLazy Dog Aviation LLC · North Myrtle Beach, SCBuilt 2005 · S/N 1451N1490CCloudsurfers LLC · Goreville, ILBuilt 2003 · S/N 0507N1492CArrow Aviation Partners LLC · Crown Point, INBuilt 2003 · S/N 0567N149CKValiair Limited Co Trustee · Casper, WYBuilt 2009 · S/N 3388N149DQuilliam Kevin · Arnold, MDBuilt 2004 · S/N 0835N14DHDenisenkov Dmitry · Seattle, WABuilt 2008 · S/N 3000N14KEJust Got Real Cirrus LLC · Lake Havasu City, AZBuilt 2008 · S/N 3252N14MKBurdzy Christopher · Alton, NHBuilt 2006 · S/N 1801N14WHWaypoints LLC · Mesa, AZS/N 3109N1501CUnderwriting Wave LLC · Woodland Hills, UTBuilt 2003 · S/N 0528N150ZZSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2007 · S/N 2609N151CGN151cg Inc Trustee · Wilmington, DEBuilt 2002 · S/N 0344N151SRBas Part Sales LLC · Greeley, COBuilt 2006 · S/N 2151N1527CSp Air LLC · Birmingham, IABuilt 2003 · S/N 0564N152CDPlane Crazy LLC · Bay Minette, ALBuilt 2007 · S/N 2894N152SBPegasus Aviation Partners LLC · Little Rock, ARBuilt 2004 · S/N 1146N152SDSt Regis Air LLC · Lancaster, PABuilt 2008 · S/N 3304N152SRLangan Adam · Norfolk, NEBuilt 2006 · S/N 1940N152TCJeckair LLC · Soddy Daisy, TNS/N 0959N152WKCrotty Daniel J Jr · Richmond, RIBuilt 2005 · S/N 1436N1531CRamos Aircraft Leasing LLC · Lagrange, OHS/N 0568N1539CMarincus Benjamin Marius · Medford, ORBuilt 2003 · S/N 0545N153BWRegistered aircraftBuilt 2006 · S/N 1997N153CKBrosche David S · Jacksonville, FLBuilt 2009 · S/N 3451N153EQualitair LLC Trustee · MichelstadtBuilt 2007 · S/N 2415N153SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1962N1540CBank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 1518N1547CGraff Oliver E · Long Beach, CABuilt 2003 · S/N 0573N1549HHudson Aviation LLC · Charlotte, NCS/N 4030N154CSGlass Cockpit Aviation LLC · N Massapequa, NYBuilt 2004 · S/N 0915N154JNMatos Holdings Corp · Weston, FLBuilt 2001 · S/N 0126
Back to AD 2007-24-13