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.

N7127YSpencer Avionics Inc · Spencer, IABuilt 1963 · S/N 30-148N7128GDsr Cherokee 180 LLC · Dallas, TXBuilt 1969 · S/N 17258828N7128LUrocopters Inc · Lancaster, CAS/N AA5-0428N7128PRegistered aircraftBuilt 1961 · S/N 24-2291N7128QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260428N7128URegistration Pending · Billings, MTRegistration pending, canceledBuilt 1992 · S/N 889N7128VLinville Aero LLC · Chapel Hill, NCBuilt 1974 · S/N 22-0057N7128WVan Curen Mary Ann · Owasso, OKS/N 28-925N7128YAir Mods And Repair Corp · Robbinsville, NJBuilt 1963 · S/N 30-149N7129DBusse Charles U · Cary, ILBuilt 1959 · S/N 22-4989N7129GSmith Lyle D · San Marcos, TXBuilt 1969 · S/N 17258829N7129PBachand Cade C · Dickinson, NDBuilt 1960 · S/N 24-2292N7129QG Alaouie LLC · Port Austin, MIBuilt 1972 · S/N 17260429N7129RLinn Stephen K · Evergreen, COBuilt 1966 · S/N 28-21830N7129YButner Gary W · Yuba City, CABuilt 1963 · S/N 30-151N7129ZBlue Ridge Soaring Society Inc · New Castle, VABuilt 1964 · S/N 25-2947N712DAlpha Aviation LLC · Dalhart, TXBuilt 1976 · S/N 17268279N712DMFox Dennis C · Oklahoma City, OKBuilt 2012 · S/N 72775N712DTBrown Charles A · Boise, IDS/N 575N712GWArmstrong Michael L · Bend, ORFirst renewal noticeBuilt 2010 · S/N 107MN712JGBirdsong Brad · Lubbock, TXS/N 872-320-669-SFBN712JTSkylens LLC · Hammond, LABuilt 1979 · S/N 27-7954057N712LDia Development LLC · Mesa, AZBuilt 1956 · S/N 18-5082N712LDBurns William J · Onalaska, WIBuilt 1982 · S/N 32-8206034N712PJason Schwitters Farm Inc · Clara City, MNBuilt 1947 · S/N 12-1670N712PWDown The Creek LLC · Grant Valkaria, FLBuilt 1976 · S/N 32R-7680276N712RFix Wing LLC · Fort Lauderdale, FLBuilt 1967 · S/N 18-8556N712RFFleming Ray J · Duson, LABuilt 2004 · S/N 70070N712SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2000 · S/N 172S8640N712TMHudson Valley Helicopter Flight Services LLC · Salt Point, NYBuilt 1979 · S/N 27-7954083N712TTAb Cessna LLC · Wilmington, NCBuilt 1981 · S/N 17275235N712UTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 2004 · S/N 3676N712WHWhiskey Hotel LLC · Marengo, ILBuilt 1991 · S/N 1712N7130Lash Alvin C · Redmond, ORBuilt 2007 · S/N 72113N7130DSorenson Gregory John · Hope, AKBuilt 1957 · S/N 22-4992N7130PRieman Joel · Lompoc, CABuilt 1960 · S/N 24-2294N7130THeffron Jacob L · Little Falls, MNFirst renewal noticeBuilt 1958 · S/N 24-598N7130VKerkstra Hilary · Portage, MIBuilt 1974 · S/N 22-0059N7130WRoye Bart L · Slaton, TXBuilt 1962 · S/N 28-928N7131BWeisel Jeffrey W · Prescott, AZBuilt 1956 · S/N 22-4350N7131LMalof Matthew P · Falls Church, VABuilt 1974 · S/N AA5-0631N7131SMaya Aircraft Holdings LLC · Lee, NHBuilt 1981 · S/N R18201697N7131YGreat Lakes Air Ventures LLC · Mason, MIBuilt 1963 · S/N 30-153N7132BConsolini Joseph · Driggs, IDBuilt 1964 · S/N 22-4351N7132PJordan Kevin · Lander, WYBuilt 1961 · S/N 24-2297N7132QAero Quest LLC · Olive Branch, MSBuilt 1972 · S/N 17260432N7132RGreydanus Samuel E · Holland, MIBuilt 1966 · S/N 28-21833N7132VCrowley Preston R · Northport, ALBuilt 1974 · S/N 20-0033N7132WN7132w LLC · Lewes, DEBuilt 1962 · S/N 28-930N7133EAir Assault Agricultural Aviation LLC · New Castle, VABuilt 1999 · S/N 0573
Back to AD 87-10-06 R1