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.

N38859Castlerock Realty Investments LLC · Visalia, CABuilt 1977 · S/N 28-7716279N38861Mahaffey Jeffrey · Bristol, TNBuilt 1977 · S/N 28-7716281N38868Spain Brandon R · Pace, FLBuilt 1977 · S/N 28-7790602N3888FBank Of Utah Trustee · Salt Lake City, UTBuilt 1976 · S/N 28-7690454N388ARPiper Aircraft Inc · Vero Beach, FLS/N 28010088N388NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881679N38900Thompson Henry S · Plantsville, CTBuilt 1977 · S/N 28-7790604N38901Weintraub Beverly · New York, NYBuilt 1977 · S/N 28-7790606N38914Acadian Aviation Pilot Training Centre Inc · Lafayette, LABuilt 1977 · S/N 28-7716291N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123N3894FNorth Shore Aero Club · Beverly, MABuilt 1976 · S/N 28-7690459N38952Ponto Phillip R · Vista, CABuilt 1977 · S/N 28-7716297N38954Faulkner Wade DBA · Sterrett, ALBuilt 1977 · S/N 28-7716299N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002N38968Vagabond Flying Association · Winfield, ILBuilt 1977 · S/N 28-7716300N38969Vandervelden Harmen J · Ware, MABuilt 1977 · S/N 28-7716301N38970Triple R Aviation LLC · Cleburne, TXBuilt 1977 · S/N 28-7716302N38972August Aero LLC · Kalispell, MTS/N 28-7716304N38974International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7716305N38986Ascend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716306N38987Ocean City Flying Club LLC · Middletown, RIBuilt 1977 · S/N 28-7716308N38988Bms Aircraft LLC · Tinley Park, ILBuilt 1977 · S/N 28-7716309N38989M5 LLC · Kit Carson, COBuilt 1977 · S/N 28-7716310N38990Augusta Aviation Inc · Hilton Head Island, SCBuilt 1977 · S/N 28-7890002N389GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881174N38CTAerialcam Media LLC · Goliad, TXBuilt 1977 · S/N 28-7890025N38JPLaymon Kenneth D · Redlands, CABuilt 1976 · S/N 28-7690396N390TCD & J Aviation LLC · Apopka, FLBuilt 2007 · S/N 2842290N3910UUniversity Of Oklahoma · Norman, OKBuilt 2005 · S/N 2842220N3912MGateway Flight Training LLC · Saint Louis, MOBuilt 1978 · S/N 28-7816385N3917MWells Brandon A · Mechanicsville, VABuilt 1978 · S/N 28-7890339N3918MAstro Aviation LLC · Cross Plains, TNBuilt 1978 · S/N 28-7890341N391DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843849N392DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843850N3936MAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816386N393BTPiper Aircraft Inc · Vero Beach, FLS/N 28010094N393DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843851N3940MCondair Flyers Inc · Latham, NYBuilt 1978 · S/N 28-7816388N39456Lorber Robert M · East Brunswick, NJBuilt 1978 · S/N 28-7816660N39457Pro-Aire Inc · Chisago City, MNBuilt 1978 · S/N 28R-7837297N3945FBrougnton Eric S · Catlettsburg, KYBuilt 1976 · S/N 28-7690463N39472Moore Tucker S · Keswick, VABuilt 1978 · S/N 28-7816662N39496Texter John F · Saint Ignace, MIBuilt 1978 · S/N 28-7890536N394DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843858N394DSP&R Operations Ltd · Muscatine, IABuilt 1980 · S/N 28-8116040N39512Tcb Consulting LLC · Yorba Linda, CABuilt 1978 · S/N 28-7890537N39513Vitale F Richard · Colts Neck, NJBuilt 1978 · S/N 28R-7837300N3952FOdonnell David B · Milton, WIBuilt 1976 · S/N 28-7690464N39535Flight Services Inc · Headland, ALBuilt 1978 · S/N 28R-7837302N39546L A M Capital Management LLC · Sheridan, WYBuilt 1978 · S/N 28-7890539
Back to AD 2016-07-21