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.

N21540Siegel Donald S · Florence, MAS/N 18281238N21547Heaton Troy W · Pasco, WABuilt 2007 · S/N T18208695N2154JLabrum Jack V · Prescott, AZBuilt 2003 · S/N 172S9451N2154VMidwest Laser Service Inc · Janesville, WIBuilt 2007 · S/N T18208694N2155JSlickhorns LLC · Reno, NVS/N T18208209N2156NTerryair LLC · Missoula, MTBuilt 2003 · S/N T20608409N2157HMustang Sally Aviation LLC · Camden, SCBuilt 2003 · S/N 172S9536N2158SChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9539N21591Kohn Aviation LLC · San Carlos, CABuilt 2004 · S/N 172S9658N2159PKiehn Real Estate LLC · Santa Barbara, CABuilt 2003 · S/N T20608432N215CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13074N215DJGreat Plains Aviation LLC · Scott City, KSBuilt 2005 · S/N 18281622N215HGGazzaz Hussein · Lakeway, TXBuilt 2025 · S/N 18283328N215HRLld Inc · Sarasota, FLBuilt 2003 · S/N 172S9527N215LPChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9215N215VBBravo Air Ventures LLC · Salt Lake City, UTBuilt 2015 · S/N T20609210N21608Mmt87 LLC · North Miami, FLBuilt 2003 · S/N 18281286N2160DSamper Katherine · Miami, FLBuilt 2003 · S/N 172S9547N2160QSo Cal Leasing LLC · El Cajon, CAS/N 172S9546N2161PRegistered aircraftBuilt 2004 · S/N 18281321N21621Csa Aircraft Leasing LLC · Salt Lake City, UTS/N 172S9530N21624Ellis Archer A · Shady Shores, TXFirst renewal noticeS/N 18281277N21627Beach David S Trustee · Amherst, NHBuilt 2004 · S/N 172S9575N2162LN2162l LLC · Tyler, TXBuilt 2005 · S/N 18281662N2162WHelicopter Applicators LLC · Pembroke, NHBuilt 2004 · S/N T20608439N2163JPortland Police Bureau · Portland, ORBuilt 2003 · S/N 18281279N2163SOlde Towne Transport LLC · Beaufort, NCBuilt 2007 · S/N 20608285N2164YGolden Eagle Aviation LLC · Park Ridge, ILBuilt 2007 · S/N T18208685N21653Skyhawk Holdings LLC · Waco, TXBuilt 2005 · S/N 18281664N21662Smedley Jonathan G · Leander, TXBuilt 2004 · S/N 172S9647N21670Kingsky Flight Academy LLC · Lakeland, FLBuilt 2004 · S/N 172S9709N2167PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608217N2168DSpartan Education LLC · Tulsa, OKBuilt 2004 · S/N 172S9649N21692Knife Edge LLC · Daytona Beach, FLBuilt 2004 · S/N 172S9651N2169MVan Bortel Aircraft Inc · Arlington, TXBuilt 2007 · S/N 18281918N216ADDiscofly LLC · Bernardsville, NJBuilt 2008 · S/N T18208833N216CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13077N216CCSuncoast Nursery & Tiki Huts Inc · Homestead, FLBuilt 2016 · S/N T20609227N216CPCivil Air Patrol · Maxwell Afb, ALBuilt 2014 · S/N T20609138N216DCDornink Steven R · Birchwood, WIBuilt 2000 · S/N 18280898N216JKKelly James C Jr · Bonaire, GABuilt 2000 · S/N 18280719N216LTWingsleasing LLC · Wichita, KSBuilt 1999 · S/N 172S8121N216NBNby Productions · Bristow, VABuilt 2018 · S/N T20609527N216SBMorotti John M · Las Vegas, NVBuilt 2004 · S/N T20608463N216SPNavy Annapolis Flight Center Inc · Edgewater, MDBuilt 1999 · S/N 172S8216N216TTKclj LLC · Dover, DEBuilt 2022 · S/N 18283197N21705Bagamaspad Alan · Reseda, CABuilt 2004 · S/N 172S9699N21706Spinks Flight Center Inc · Burleson, TXBuilt 2007 · S/N 172S10470N2170WSacks Martin · Mill Valley, CABuilt 2005 · S/N T18208441N21714Aero Equities LLC · Ventura, CABuilt 2007 · S/N 172S10471
Back to AD 2003-24-13