OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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.

N961LWGrassroots Aviation · Starkville, MSS/N 20-961N9621DLimitless Outdoors · Bonners Ferry, IDBuilt 1958 · S/N 22-6532N9624DBuster Wendy K · Forney, TXBuilt 1959 · S/N 22-6536N9625DCentral Products Inc · Gladwin, MIBuilt 1958 · S/N 22-6537N9629DAnderson Antoinette · Granbury, TXBuilt 1958 · S/N 22-6541N9631PKansas Air LLC · Linn, KSS/N 25-7656013N9634DBacklund Scott W · Greybull, WYBuilt 1959 · S/N 22-6546N9637DSpivey Harold E · Thomaston, GABuilt 1959 · S/N 22-6549N9639DVestal James L · Kernersville, NCBuilt 1959 · S/N 22-6552N963JKeith William F · Bakersfield, CABuilt 1962 · S/N 24-3195N9642DMalsom Isaac B · Box Elder, SDBuilt 1959 · S/N 22-6556N9642PSouthern California Soaring Academy Inc · Valencia, CABuilt 1976 · S/N 25-7656023N9643DBlumhorst Ricky W · Paola, KSBuilt 1959 · S/N 22-6557N9645DDarryn Allyson R · Las Cruces, NMBuilt 1959 · S/N 22-6559N9646DFerrell Alan B · Arlington, OHBuilt 1959 · S/N 22-6560N9647DSutton Neal · Ashby, NEBuilt 1959 · S/N 22-6561N9649DUlrich Kenneth B Jr · Kingwood, TXBuilt 1959 · S/N 22-6563N9649PHarris Hill Soaring Corp · Horseheads, NYBuilt 1975 · S/N 25-7556008N964MMModular Aviation LLC · Saratoga Springs, UTBuilt 1978 · S/N 27-7854132N9650DKahanek Doug II · Alvarado, TXBuilt 1959 · S/N 22-6564N9651DKadera David E · Dorchester, IABuilt 1959 · S/N 22-6565N9652DWilliams Michael P · Shelburne Falls, MAS/N 22-6566N9653DHurt Thomas J · Kerrville, TXBuilt 1959 · S/N 22-6569N9656DSpearman Clint · Scottsbluff, NEBuilt 1959 · S/N 22-6572N9658DSwann Sherrie Kim Trustee · Toledo, OHBuilt 1959 · S/N 22-6574N9663DRamsey Bobby W · Harrogate, TNBuilt 1959 · S/N 22-6579N9667DAppling Justin Glenn · Amarillo, TXS/N 22-6583N966AMattson Edward B · Quincy, WABuilt 1951 · S/N 22-271N966AAGateway Of Sturgis LLC · Sturgis, MIBuilt 1978 · S/N 44-7995120N967EYJoy Ventures LLC · Helena, MTBuilt 1967 · S/N 30-1577N967ROpen Sky Aviation LLC · Salem, ORBuilt 1959 · S/N 23-1776N9680DGoundry George D · Sammamish, WABuilt 1959 · S/N 22-6597N9681DLynch Sean L · Brighton, ILBuilt 1959 · S/N 22-6598N9683DSmith James A · Lyle, WAS/N 22-6600N9685DPadgett Matthew K · Star City, ARBuilt 1959 · S/N 22-6602N9688DPetersohn Jeffrey A · Ellijay, GAS/N 22-6605N9689DFoster Stephen G · Grand Ledge, MIBuilt 1959 · S/N 22-6606N968AMasura Judith E · Glenoma, WABuilt 1951 · S/N 22-280N9697DWarner Carl P · Lindley, NYBuilt 1959 · S/N 22-6607N969AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496644N96JNPetz Leroy E Jr · Montverde, FLBuilt 1985 · S/N 39-91N9701DCharles Benjamin L · Willow, AKBuilt 1959 · S/N 22-6612N9701PTucson Soaring Club Inc · Sahuarita, AZBuilt 1975 · S/N 25-7556012N9702DAdams Carl B · Albuquerque, NMBuilt 1959 · S/N 22-6613N9704DTrimmer Marvin E · Willow, AKBuilt 1959 · S/N 22-6615N9705DHensley Roger A · Rosamond, CABuilt 1959 · S/N 22-6616N9707DPapke Brian D · Beulah, MIS/N 22-6619N9709DPearce Ricky · Parsons, KSBuilt 1959 · S/N 22-6621N970AWilson Douglas W · Stockton, CABuilt 1951 · S/N 22-281N9713DBallard Gary B · Leslie, ARBuilt 1959 · S/N 22-6625
Back to AD 85-02-05 R1