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.

N950TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881950N950WKKendall Kristopher W · Denver, COBuilt 2024 · S/N 41876N95105Airbud Aviation LLC · Morristown, NJBuilt 1969 · S/N 28-25806N9510HRegistered aircraftBuilt 1975 · S/N 17266188N9510LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276568N9510PMadsen Travis E · New Underwood, SDBuilt 1972 · S/N 24-5028N9510QRss Aviation LLC · Myrtle Beach, SCBuilt 1976 · S/N 61P-0344-103N95111Tiny Tin Aviation LLC · Groveland, FLBuilt 1969 · S/N 28-25808N9511DEglin Aero Club · Eglin Afb, FLS/N 17280359N9511GBurdette Ernest L · Pass Christian, MSBuilt 1998 · S/N 18280121N9511JGomez Alexandro · Riverside, CABuilt 1966 · S/N 28-3633N9511KMoore Matt R · Nashville, TNS/N 28-7625182N9511MBenjamin Joseph · Erie, COBuilt 1966 · S/N 670088N95121Preston Aviation LLC · Wilmington, DEBuilt 1969 · S/N 28-25814N9512CDe Aviation Inc · La Porte, TXBuilt 1978 · S/N 28-7816487N9512DFerrell Alan B · Arlington, OHBuilt 1958 · S/N 22-6428N9512FGeorge'S Aviation Services Inc · Honolulu, HIBuilt 1998 · S/N 17280429N9512HTracy Patrick J · Maddock, NDBuilt 1975 · S/N 17266190N9512JArapahoe Flight Club LLC · Colorado Springs, COBuilt 1966 · S/N 28-3634N9512LKreykes K Douglas · Greeley, COBuilt 1998 · S/N 18280237N9512MBible Larry · Mount Pleasant, TXBuilt 1966 · S/N 670089N9512SBlack Daniel L · Spicewood, TXBuilt 1965 · S/N 7GCBA21N9512UWilkes Jack M · Port Orchard, WAS/N 018N95133Rd Aire LLC · Opelika, ALBuilt 1969 · S/N 28-25818N9513BLong Michael A · Grand Lake, COBuilt 1981 · S/N 172RG0844N9513CAgri Business Aviation Inc · Sparta, ILBuilt 1978 · S/N 28-7890418N9513HHigh Flight Academy LLC · Allison Park, PABuilt 1976 · S/N 17266191N9513JGlorioso Richard · Plant City, FLBuilt 1966 · S/N 28-3635N9513LMott Terry W · Hampton, IABuilt 1972 · S/N AA5-0213N9513MHangar9llc · Queen Creek, AZBuilt 1966 · S/N 670090N9513PAir Sailing Inc · Reno, NVBuilt 1974 · S/N 25-7405600N95147Ramirez Ricardo A · San Antonio, TXBuilt 1969 · S/N 28-25822N9514DAdams David D · West Ossipee, NHBuilt 1958 · S/N 22-6430N9514HFrerichs John E · Gurley, ALBuilt 1975 · S/N 17266192N9514JDu Bois Aviation Inc · Chino, CABuilt 1966 · S/N 28-3637N9514LBiller Mary Catherine · Columbus, OHBuilt 1973 · S/N AA5-0214N9514MHolen Benjamin E · Ketchum, IDBuilt 1966 · S/N 670091N95151Gonzalez-Pinto Carmelo · San Antonio, TXBuilt 1969 · S/N 28-25823N95154Cen Inc · Sheridan, WYS/N 28-25825N95157Smutek Brian D · Mio, MIBuilt 1969 · S/N 28-25828N9515BGrason Aviation LLC · Appleton, WIBuilt 1981 · S/N 172RG0846N9515DElmer Charles F · Saint Clair Shores, MIBuilt 1958 · S/N 22-6439N9515JBowman Alex T · Virginia Beach, VABuilt 1966 · S/N 28-3638N9515KBoyd Matthew · Hudsonville, MIBuilt 1976 · S/N 28-7615209N9515MReid Stephen M · Gardner, KSBuilt 1966 · S/N 670092N95160Registration Pending · Lakewood Ranch, FLRegistration pendingBuilt 1969 · S/N 28-25829N9516ESabo John D · New Lenox, ILBuilt 1976 · S/N 76-31133N9516FKelly David · Issaquah, WABuilt 1967 · S/N 170311N9516JEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280396N9516KSmith Dalton L Trustee · Smyrna, DEBuilt 1976 · S/N 28-7615210
Back to AD 87-10-06 R1