AD 2003-24-13

Registered aircraft · 7,870

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:2003-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:2003-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.

N808BPChemtech-Engineering Inc · Racine, WIBuilt 2004 · S/N 18281455N808DTGh Aircraft Leasing LLC · Coconut Creek, FLBuilt 2001 · S/N T20608278N808DWHall Danny J · Torrington, CTBuilt 2001 · S/N 18281044N808PEBarbers Point Flight School LLC · Kapolei, HIBuilt 2020 · S/N 172S12538N808TPAvian Leasing LLC · Bremerton, WABuilt 1997 · S/N 17280141N808ZTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608236N809CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281222N809DWReed Land & Properties LLC · Kalispell, MTBuilt 2002 · S/N T18208109N809EMDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608213N809FTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T18209209N809GTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608245N809HWDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608248N809KPDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608249N809LNDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608251N809NDDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608219N809PGDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608190N809QJDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608209N809RHDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608210N809SEDepartment Of Homeland Security · Washington, DCBuilt 2003 · S/N 20608208N809TTDepartment Of Homeland Security · Washington, DCBuilt 2004 · S/N 20608211N809USDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608231N809VADepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608232N80BFAir Future Airways Corp · Miami, FLBuilt 2000 · S/N 172S8611N80LULetourneau University · Longview, TXBuilt 2023 · S/N 172S12969N80PELakepoint Aviation LLC · Augusta, KSBuilt 2004 · S/N 18281472N810CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13358N810CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281247N810EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13508N810KKKenzy 2023 LLC · Aurora, ORBuilt 2023 · S/N 172S13060N810KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281244N810RFQuiring Mark Edmond · Mount Pleasant, TXBuilt 2012 · S/N 18282329N810SABlack Hound Aviation LLC · Austin, TXBuilt 2003 · S/N 172S9422N811AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281196N811AHOtv Leasing · Manassas, VABuilt 2010 · S/N 18282240N811CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13359N811CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281248N811CSSheldon Brent Robert · Warwick, NYBuilt 2012 · S/N T18209081N811CTBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12492N811EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12958N811GWGreat Western Aviation Leasing LLC · Ogden, UTBuilt 2002 · S/N 18281101N811KSFargo Jet Center LLC · Fargo, NDBuilt 2005 · S/N 17281245N811PEPalmito Resources Lc · Dallas, TXBuilt 2007 · S/N T18208731N811TWNova Aircraft Holdings Inc · San Diego, CABuilt 2002 · S/N 18281118N812AFState Of Louisiana · Baton Rouge, LABuilt 2003 · S/N 18281197N812EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12797N812HVPinpoint Locating Inc · Altoona, ALFirst renewal noticeS/N T20609098N812KSUniversity Of Central Missouri · Warrensburg, MOBuilt 2005 · S/N 17281246N812MCFly Bye Air LLC · Southport, NCBuilt 2003 · S/N 18281208N813CAChristiansen Aviation LLC · Wilmington, DEBuilt 2025 · S/N 172S13362N813CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281249
Back to AD 2003-24-13