OpenAirDocs.org
AD 87-10-06 R1

Registered aircraft · 72,010

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.

N56992Attebery Larry J · Caldwell, IDBuilt 1973 · S/N 28R-7435071N569932c Fun Aviation LLC · Dallas, TXBuilt 1973 · S/N 28-7410040N56996Zarn Douglas J · Amboy, MNBuilt 1973 · S/N 28-7425080N56997Bibb John G · Paragould, ARBuilt 1973 · S/N 28-7425081N56999Lofty Images LLC · Owosso, MIS/N 517N5699DClear Lake Management Corp · Wilmington, DEBuilt 1981 · S/N 510N5699NStyer David B · Pendleton, ORBuilt 1981 · S/N 1220N5699PHahn Curtis D · St George, UTBuilt 1959 · S/N 24-772N5699ULrh Equipment LLC · Pendleton, ORS/N 511N5699VMesmer Robert F · Grand Island, NYBuilt 1981 · S/N 512N569BSZanetta Wayne T · Portland, ORBuilt 2014 · S/N 18-1686N569DPHale William J · Whitehouse, TXBuilt 2008 · S/N 90707N569DVDelta Victor LLC · Wilmington, DEBuilt 2002 · S/N T18208173N569FLN7396w LLC · Coeymans Hollow, NYS/N 28-7125413N569MKindred Daniel P · Jacksonville, ILFirst renewal noticeS/N 20-0009N569MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 40.314N569RVRicketts Michael D · Weirsdale, FLBuilt 2010 · S/N 91519N569SPGlobal Flight Training Solutions Inc · Immokalee, FLBuilt 2000 · S/N 172S8494N569TJAnderson Thomas C · Poplar Grove, ILBuilt 2013 · S/N 259RN569TSBig South Fork Aero Inc · Huntsville, TNBuilt 1993 · S/N 722-93N569WHGp Cub Air LLC · Sioux Rapids, IABuilt 1965 · S/N 18-8271N56ABBezanson Adam M · Fremont, NHBuilt 2024 · S/N 41687N56ADTifc LLC · Winnsboro, SCBuilt 1971 · S/N 27-4642N56AMPeavy Michael J · Chico, CABuilt 1976 · S/N 957N56BEBirds Eye View Inc · Middletown, RIBuilt 2017 · S/N 2476N56BGGuernsey Gibson R · Belen, NMBuilt 1980 · S/N 140N56BSHansen Nick K · Litchfield Park, AZBuilt 1987 · S/N 1N56BVEuroaviation Inc Trustee · KematenBuilt 1978 · S/N AA5A0719N56CCMichel David L · Pickens, SCBuilt 1959 · S/N 24-1297N56CEWave Shack Acquisitions LLC · Lewes, DEBuilt 1991 · S/N LARES 0001N56CPBulldog Aviation LLC · Goodyear, AZBuilt 1969 · S/N 700003N56CVVaughn Geoffrey · Brunswick, GABuilt 1976 · S/N 14017N56CXThinair LLC · Dover, DEBuilt 2000 · S/N 4636279N56DBBerger Dale · Bay Village, OHBuilt 2002 · S/N 1128N56DDMeier Perry S · Conroe, TXBuilt 1976 · S/N D2DN56DGEagle East Aviation Inc · North Andover, MABuilt 1976 · S/N 17266239N56DWReed John S · Wasilla, AKS/N 18-7709159N56EB56 Eb Inc · Jacksonville, FLBuilt 1968 · S/N 28R30647N56ECBpc Aviation LLC · Rosamond, CABuilt 1962 · S/N 17249661N56EKQuailair LLC Trustee · MichelstadtS/N 2890145N56EPSanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17270728N56ERGsell Bruce Ward · Southampton, NJBuilt 1979 · S/N AA5B-1094N56FAir Kings LLC · West Chester, PABuilt 1975 · S/N 17265348N56FDDefibaugh Fred M · Chino Alley, AZS/N 3535N56GBCalhoun Keith A · Springville, TNBuilt 1997 · S/N 56N56GFInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N TG-29N56GTDonaldson Timothy A · Oklahoma City, OKBuilt 1976 · S/N AA5B-0344N56HCFaire Ken · Mojave Valley, AZBuilt 1976 · S/N 2N56HJRobinson Douglas J · Dayton, NVBuilt 1997 · S/N 24348N56HRStrachan Annmarie C · Overgaard, AZBuilt 2002 · S/N 81408
Back to AD 87-10-06 R1