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.

N6839RGolden Wings LLC · Tampa, FLBuilt 2002 · S/N 0405N683DMMcmorphy LLC · Erie, PABuilt 2009 · S/N 3427N683SRTf Global LLC · Houston, TXBuilt 2007 · S/N 2766N684BCRegistered aircraftBuilt 2005 · S/N 1295N684CDFreedom Development Corporation LLC · Matthews, NCS/N 1786N684DMMidwest Aviation Equipment LLC · Solon, IABuilt 2019 · S/N 4774N684SRPelair LLC · Milton, DEBuilt 2007 · S/N 2816N685CDGraves Koene R Trustee · Paso Robles, CABuilt 2006 · S/N 1768N685DMMetcalf Steven · West Union, IABuilt 2002 · S/N 0322N685SRRegistration Pending · Seattle, WARegistration pendingBuilt 2007 · S/N 2586N6869RPro Air Media LLC · Sevierville, TNBuilt 2006 · S/N 2121N686DSScheigert Delbert F Jr · Saint Cloud, FLBuilt 2006 · S/N 1957N687PWDragonflier LLC · Las Vegas, NVBuilt 2020 · S/N 4923N688PDUnusual Attitudes LLC · Bates City, MOBuilt 2007 · S/N 2398N688SRRsm Enterprises LLC · Helena, MTBuilt 2007 · S/N 2826N68BARegistered aircraftBuilt 2017 · S/N 4585N68DXFreeman David J · Seattle, WABuilt 2002 · S/N 0214N68GTBoon Hong Sim · New York, NYBuilt 2009 · S/N 3596N68GYOwll Aviation LLC · Baton Rouge, LABuilt 2016 · S/N 4364N68PFWooden Steve S Trustee · Nokomis, FLBuilt 2013 · S/N 4021N68SYFreeman William M · Cameron Park, CABuilt 2004 · S/N 0930N690NDAltitude Adjustment LLC · Lisle, ILBuilt 2006 · S/N 1851N690SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2678N691TSAl Systems Corp · Weston, FLBuilt 2020 · S/N 4984N6935LBreidenbach Aviation LLC · Bettendorf, IABuilt 2014 · S/N 4116N693CLin Steven C · Granite Falls, NCBuilt 2002 · S/N 0438N693CDAber Air LLC · Amherst, OHBuilt 2004 · S/N 0976N693CPCharlie Papa 1 LLC · Stafford, TXBuilt 2004 · S/N 1181N693JDBowles Brent K · Lake Jackson, TXBuilt 2008 · S/N 3021N693MSandpiper Air LLC · Alexandria, VABuilt 2020 · S/N 4949N693SRCarmichael Mark G · Palm Desert, CABuilt 2007 · S/N 2796N693TFStevenson Farhana · Lexington, MABuilt 2017 · S/N 4583N693TSColtharp William M · Austin, TXBuilt 2009 · S/N 3393N694CDRogers Jack Burton Jr · Bakersfield, CABuilt 2006 · S/N 1789N694MRHarmon Creighton D · Scott, LABuilt 2010 · S/N 3694N694PRAdvanced Charter Industries LLC · Orange, CABuilt 2005 · S/N 1606N694TTMiller Patrick · Riverside, CABuilt 2004 · S/N 1239N6950TThornebymyside LLC · Punta Gorda, FLBuilt 2019 · S/N 4863N696PGCirrus Sr22 3606 Inc Trustee · Wilmington, DEBuilt 2010 · S/N 3606N697CMrc Aviation LLC · Columbia, TNS/N 0443N697CBPaul L W Smith Inc · Kingston, GABuilt 2010 · S/N 3693N697SRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2006 · S/N 1827N698ESSund Lloyd · Kramer, NDBuilt 2022 · S/N 8609N699CDFaridev LLC · White Plains, NYBuilt 2005 · S/N 1505N69MZHall John · Litchfield Park, AZBuilt 2007 · S/N 2700N69PKBiofusion LLC · Fort Smith, ARBuilt 2009 · S/N 3576N69YKMetal Wholesale LLC · Bloomfield, IABuilt 2021 · S/N 5110N69ZAMoleno Capital LLC · Dallas, TXBuilt 2010 · S/N 3519N6BGMollica Air LLC · North Andover, MABuilt 2021 · S/N 5090N6CACra Aviation LLC · Dickerson, MDBuilt 2021 · S/N 5073
Back to AD 2007-24-13