OpenAirDocs.org
AD 2007-24-13

Registered aircraft · 4,018

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.

N1000V1kv LLC · Moultrie, GAS/N 0660N100FRQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0770N100JBAirbyars LLC · Spartanburg, SCBuilt 2024 · S/N 10290N100MJMh Aviation LLC · Glendale, AZBuilt 2007 · S/N 2844N100PXS & R Air LLC · Amarillo, TXBuilt 2004 · S/N 0953N100WMValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1268N100YZCay Air LLC · North Palm Beach, FLBuilt 2004 · S/N 0814N100ZWFetch Aviation LLC · Bonita Springs, FLBuilt 2014 · S/N 4086N1011GInternational Air Services Inc Trustee · Carson City, NVBuilt 2025 · S/N 10795N101BEOne Bravo Echo LLC · Fernandina Beach, FLBuilt 2011 · S/N 3759N101CDCharlie Delta Aviation LLC · Marietta, GABuilt 2001 · S/N 0101N101FKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 3027N101GWPlan B Air LLC · Lago Vista, TXBuilt 2007 · S/N 2528N101MWMaroon Creek LLC · Aspen, COBuilt 2007 · S/N 2823N101VMKrowel Nicholas E · Woodstock, GABuilt 2001 · S/N 0109N101XMMaier Gerard · Hartford, WIBuilt 2004 · S/N 1226N101ZACirrus Sr22 10117 Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10117N102DWFlyboy Aviation LLC · Memphis, TNBuilt 2006 · S/N 1750N102KWVentura Douglas · Cambridge, MDBuilt 2003 · S/N 0755N102LTSandjuice LLC · Gainesville, FLBuilt 2002 · S/N 0288N102PBDeland Air And Sea Brokerage Inc · Deland, FLS/N 0321N102SRAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1864N103CClarity Its LLC · Canton, GABuilt 2002 · S/N 0432N103EECirrus Djh LLC · Bountiful, UTBuilt 2006 · S/N 2104N103FDMidnight Echo LLC · Miami Lakes, FLBuilt 2024 · S/N 9838N103MK2141 Corp · Wilmington, DEBuilt 2005 · S/N 1444N104BZSterling Aviation LLC · Newport Beach, CABuilt 2004 · S/N 1219N104ETLmc Angels LLC · Hinckley, OHBuilt 2004 · S/N 1024N104GHBluff Point Aviation LLC · Jensen Beach, FLBuilt 2014 · S/N 4087N104TQGtw Aviation LLC · San Jose, CABuilt 2006 · S/N 2304N10502Flying Chipmunk LLC · Charlotte, NCBuilt 2025 · S/N 10502N105CKHdm Aviation LLC · Saratoga, CABuilt 2016 · S/N 4399N105HCJi Aviation LLC · Vidalia, LABuilt 2019 · S/N 4777N105KLWing It LLC · Madison, WIBuilt 2017 · S/N 4461N105TTW&P Aircraft LLC · Humble, TXBuilt 2006 · S/N 1867N105WLSchmitt Family Holdings LLC · Independence, IABuilt 2006 · S/N 2210N106EZDannemann Kevin · Wallkill, NYBuilt 2006 · S/N 2044N106TJN106tj LLC · Murray, UTBuilt 2010 · S/N 3592N106TQRogers Scott · Asheville, NCBuilt 2007 · S/N 2633N107AJAltitude Aviation LLC · West Point, GABuilt 2007 · S/N 2671N107BCCjw Aviation LLC · San Antonio, TXS/N 3057N107CBR&Dsl Corp Trustee · Wilmington, DEBuilt 2008 · S/N 3244N107MTTuch Michael · Gonzales, TXS/N 4846N107PBAntler Air LLC · Klamath Falls, ORBuilt 2006 · S/N 2292N107TQSouthland Air Holdings LLC · Albany, GABuilt 2013 · S/N 3996N1086CTeare Matthew A · Sagamore Hills, OHBuilt 2003 · S/N 0462N108EZGraybull Aviation LLC · Lake Orion, MIBuilt 2006 · S/N 2037N108GPCoral Desert LLC · Andalusia, ALBuilt 2005 · S/N 1317N1098RSweat Kristie S · Buford, GABuilt 2021 · S/N 5010N109FTCisco Aero LLC · Cisco, TXBuilt 2006 · S/N 2025
Back to AD 2007-24-13