OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,001

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

N201TLPiorkowski Christian E · Pearland, TXBuilt 1977 · S/N 24-0202N201TMTrujillo John Francisco · Newport News, VABuilt 1978 · S/N 24-0388N201TQJackson Zarick · Pembroke Pines, FLBuilt 1977 · S/N 24-0351N201TRAero Nautical Electronics Inc · Starke, FLBuilt 1977 · S/N 24-0279N201TSJacobsen Eric A · Scottsdale, AZBuilt 1977 · S/N 24-0077N201TVHiivala Robert J · Hanover, MNBuilt 1977 · S/N 24-0332N201TYSingleton Kimberley P · Stuart, FLBuilt 1977 · S/N 24-0322N201TZMayerchak Mark · Mooresville, NCBuilt 1977 · S/N 24-0324N201UAAllard Aviation LLC · Nashua, NHBuilt 1977 · S/N 24-0361N201UBProxima Flight LLC · Spring Lake, MIBuilt 1977 · S/N 24-0362N201UEWoodhams Brian · Wayland, NYBuilt 1977 · S/N 24-0366N201UFReck Robert · Cameron, MTBuilt 1977 · S/N 24-0338N201UGRojemann Nathaniel W · Pass Christian, MSBuilt 1977 · S/N 24-0369N201UJ787 P&G 201 LLC · West Chicago, ILBuilt 1977 · S/N 24-0389N201UKLewis Daniel F · Edgewater, FLBuilt 1977 · S/N 24-0394N201UTRegistered aircraftBuilt 1977 · S/N 24-0313N201UWFlyscotty Development LLC · Gary, INBuilt 1977 · S/N 24-0390N201UXMccallister Randy S · Pulaski, VABuilt 1977 · S/N 24-0391N201UZForrest Dean L · Hales Corners, WIBuilt 1977 · S/N 24-0393N201VBH3 Aero Concepts LLC · Groveland, FLBuilt 1977 · S/N 24-0372N201VELa Brucherie Andrew · Redlands, CABuilt 1978 · S/N 24-0395N201VFTyler Walter M II · Canoga Park, CABuilt 1977 · S/N 24-0344N201VHJt Engineering Inc · Wilmington, DEBuilt 1977 · S/N 24-0397N201VKSandy Cove Inn LLC · Seaside, ORBuilt 1977 · S/N 24-0208N201VLHuxley Jonathan S · San Diego, CABuilt 1977 · S/N 24-0398N201VMGilbert Jeremy · Collinsville, ALBuilt 1977 · S/N 24-0336N201VNPrzebinda Viktor · Boulder, COBuilt 1977 · S/N 24-0248N201VPWascher Larry · Mesa, AZBuilt 1977 · S/N 24-0274N201VRHall Keith M Trustee · Great Falls, MTBuilt 1977 · S/N 24-0349N201VSFoglein Aurel T · Trinity Center, CABuilt 1977 · S/N 24-0318N201VUBlanco James A · El Dorado Hills, CABuilt 1977 · S/N 24-0401N201VVMead Jeffery · Carrollton, TXBuilt 1977 · S/N 24-0175N201WASombric Scott · Okeechobee, FLBuilt 1977 · S/N 24-0406N201WDHunter David G · Marietta, GABuilt 1977 · S/N 24-0269N201WGWolf Dirk R · Troy, MIBuilt 1977 · S/N 24-0250N201WHAllen Joseph P · Coon Rapids, MNBuilt 1977 · S/N 24-0407N201WJGaudet Douglas · Oldsmar, FLBuilt 1977 · S/N 24-0333N201WMN201wm LLC · Palmetto, FLS/N 24-0195N201WNBeaty H Allen · Abilene, TXBuilt 1977 · S/N 24-0408N201WSSeale Charles M · Greensboro, ALBuilt 1977 · S/N 24-0080N201WTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1977 · S/N 24-0183N201WVPerry Russell L · Washington, WVBuilt 1977 · S/N 24-0410N201WWN201ww LLC · Fort Lauderdale, FLBuilt 1977 · S/N 24-0128N201WYDoyle David L · Waxahachie, TXBuilt 1977 · S/N 24-0312N201WZMullnix Bruce A · Liberty, TXBuilt 1977 · S/N 24-0411N201XBPena Joseph Jr · Mount Sinai, NYBuilt 1977 · S/N 24-0385N201XCRegistered aircraftBuilt 1977 · S/N 24-0346N201XDAir Worthy Inc · Lyon, MSBuilt 1977 · S/N 24-0378N201XERogers Thomas B · San Antonio, TXS/N 24-0165N201XFMount James Michael · Bardstown, KYBuilt 1978 · S/N 24-0400
Back to AD 87-10-06 R1