OpenAirDocs.org
AD 2016-07-21

Registered aircraft · 5,443

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:2016-07-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-07-21')
  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.

N532TWRooplal Robby Ashram · Spring, TXBuilt 1983 · S/N 28-8416006N53339Skywest Leasing Inc · St George, UTS/N 2843469N5333MWeaver William Cookman III · Fayetteville, NCBuilt 1977 · S/N 28-7816140N53349Arrow Aviation LLC · Howell, MIS/N 2843470N5335FEasterby Daniel · Big Bear Lake, CABuilt 1976 · S/N 28-7790090N5337FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790092N5337SAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 2001 · S/N 2843479N533CASkylink Xpress Inc · San Bernardino, CABuilt 1989 · S/N 2841210N533DDEverglades Aviation Academy LLC · Weston, FLS/N 28-8190240N533PUEagle Flyers Vii LLC · Carmel, INS/N 2837001N5340ACrews Randall S · Valdosta, GAS/N 2843489N5342JMoore Durk · Farmington Hills, MIS/N 2843493N5342KWest Coast Equipment Leasing LLC · Aurora, ORBuilt 2001 · S/N 2843467N53447Bank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 2843535N5345FArcher Air LLC · Traverse City, MIBuilt 1976 · S/N 28-7790093N5346FSo Send I You LLC · Cheyenne, WYS/N 28-7790094N5346UAverett University · Danville, VABuilt 2003 · S/N 2843542N534APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843754N534CACoast Flight Training And Management Inc · San Diego, CABuilt 2019 · S/N 2881278N534SCSpartan Education LLC · Tulsa, OKS/N 2881320N53509Waynes Aircraft Maintenance · Homestead, FLBuilt 2002 · S/N 2844071N5352DN5352d LLC · Costa Mesa, CABuilt 2002 · S/N 2844079N53533Tfw Enterprise Holding LLC · New York, NYS/N 2843579N5353FAllegany Aviation LLC · Tonawanda, NYBuilt 1976 · S/N 28-7790096N5353GG & M Aircraft Inc · Wheat Ridge, COS/N 2844078N53550Kansas City Aviation Center Inc · Olathe, KSS/N 2843451N53558University Of Illinois · Savoy, ILBuilt 2002 · S/N 2844083N5356XSkywest Leasing Inc · St George, UTS/N 2843521N5356YMoore Aviation Inc · Beaver Falls, PABuilt 2002 · S/N 2843528N5357DYadair Inc · Lauderdale Lakes, FLBuilt 2002 · S/N 2843537N5357NSkywest Leasing Inc · St George, UTS/N 2843519N53580Synergy Aircraft Sales LLC · Bloomington, ILBuilt 2002 · S/N 2844087N5359FWashington Fliers Club Inc · Washington, IABuilt 1976 · S/N 28-7790098N5361NKdb LLC · Underwood, IABuilt 2003 · S/N 2843549N5362UHebert Loree W Jr · Saint Francisville, LABuilt 2003 · S/N 2843555N5363JPulliam Joe Clinton Jr Trustee · Pilot Point, TXBuilt 2003 · S/N 2843559N53651Christiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 2843565N5366WM & S Aviation LLC · Lebanon, MOBuilt 2003 · S/N 2843552N5367FBlackburn Kenneth P Trustee · Dubuque, IABuilt 1976 · S/N 28-7790100N5368HPacific Flight Aviation LLC · Costa Mesa, CABuilt 2003 · S/N 2843562N5368JJones Anesthesia LLC · Arcadia, INBuilt 2003 · S/N 2843551N5369FRegistered aircraftBuilt 1976 · S/N 28-7790102N536PUMetro Aircraft Co · Bloomington, MNBuilt 1992 · S/N 2841321N536SCSpartan Education LLC · Tulsa, OKS/N 2881321N537APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843760N538SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881431N5398FFlight Leasing Corp · Wilmington, DES/N 28-7790108N5399FHaueisen Jessica M · Franklin, GAS/N 28-7790109N539TCTexas State Technical College · Waco, TXBuilt 2025 · S/N 28020239N53FSBlue Sky Flyers Inc · Greeley, COBuilt 1981 · S/N 28-8290026
Back to AD 2016-07-21