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.

N7199YFour Way Aircraft Ltd · Pensacola, FLBuilt 1963 · S/N 30-223N71ADSons Aviation LLC · Moody, ALS/N 30-1524N71BBMitchell Trans · Timnath, COFirst renewal noticeBuilt 1967 · S/N 30-1539N71BTSmith Dustin E · Windsor, MOBuilt 1961 · S/N 22-8833N71FLWest Transportation LLC · West Bloomfield, MIBuilt 1968 · S/N 27-3969N71GMEtheredge Mark · Pell City, ALBuilt 1969 · S/N 30-1959N71GTHazduff LLC · Plainfield, INBuilt 1969 · S/N 30-1801N71PVCeleste LLC · Playa Del Rey, CABuilt 1966 · S/N 30-1261N7200PThompson Grover A · Locust, NCBuilt 1960 · S/N 24-2386N7200YBroussard Don W Jr · Wynne, ARBuilt 1963 · S/N 30-224N7201DEnyeart Warren L · Eagle River, AKBuilt 1957 · S/N 22-5025N7203PGorge Fast Aviation LLC · Hood River, ORBuilt 1960 · S/N 24-2373N7204PPittner Hans C · Goshen, NYBuilt 1960 · S/N 24-2374N7204ZKettley Rick W · Steward, ILBuilt 1964 · S/N 25-3115N7206LWilliams Harry D III · Summerland Key, FLS/N 22-5030N7206YSkyflite LLC · Hillsboro, ORS/N 30-232N7207DHerrick David L · Mont Vernon, NHBuilt 1957 · S/N 22-5031N7207PSteinbach Philipp · Bentonville, ARBuilt 1960 · S/N 24-2377N7208DCopper River Airmotive LLC · Copper Center, AKBuilt 1957 · S/N 22-5032N7209DBlue Weayne E · Rochester, NYBuilt 1957 · S/N 22-5033N7209YThy Will Be Done Here LLC · Reno, NVBuilt 1963 · S/N 30-235N720SUOklahoma State University · Stillwater, OKBuilt 2017 · S/N 4496413N7210DRainey Lee S · Troy, MOBuilt 1957 · S/N 22-5034N7210PBirdwell David W · Richmond, TXBuilt 1960 · S/N 24-2380N7211DThacker William E · Chenoa, ILS/N 22-5035N7211LMoes Crop Dusting Service Inc · Marysville, CAS/N 25-7405581N7211PWhite Jordan H · Gold Beach, ORBuilt 1960 · S/N 24-2381N7211YBeers Jason · Girard, OHS/N 30-237N7211ZLas Vegas Valley Soaring Association · Jean, NVBuilt 1964 · S/N 25-3122N7213DFranklin Gary B · Willcox, AZBuilt 1957 · S/N 22-5037N7213LHorne Jared I · Opelika, ALBuilt 1974 · S/N 25-7405582N7215DSchmidt Wilfred L III · Elgin, ILBuilt 1957 · S/N 22-5039N7216YMerriwether David E · Whitesburg, GABuilt 1963 · S/N 30-242N7217PNewman Samuel M · Taylorsville, UTBuilt 1960 · S/N 24-2389N7218ZAerial Banners Inc · Pembroke Pines, FLBuilt 1965 · S/N 25-3134N7219ZJersey Devil Dusters LLC · Southampton, NJBuilt 1965 · S/N 25-3136N7220PHench Martin Stewart · La Verne, CABuilt 1960 · S/N 24-2392N7221LKnutson Wayne R · Thompson, NDBuilt 1974 · S/N 25-7405584N7221PBuhrmeister Timothy J · Centereach, NYBuilt 1960 · S/N 24-2393N7222CMcshane Trent · Wasilla, AKS/N 22-215N7223DTonelli James D R · Locust Grove, GABuilt 1957 · S/N 22-5048N7224DBank Jeffrey J · Littleton, COBuilt 1957 · S/N 22-5049N7224YDistel Harold M · Williamson, GABuilt 1964 · S/N 30-246N7225PSuperior Aviation LLC · Metairie, LABuilt 1960 · S/N 24-2399N7225YTwin Cam Holdings LLC · Union City, TNBuilt 1964 · S/N 30-248N7226DAdams Andrew V · Joplin, MOS/N 22-5747N7226YGilbert Douglas A · Weston, FLBuilt 1964 · S/N 30-249N7227DRobinson Eric C · Palmer, AKBuilt 1957 · S/N 22-5052N7227YClearview Aerial Solutions LLC · Rogersville, TNS/N 30-250N7229DBuergel Sandra J · East Aurora, NYBuilt 1957 · S/N 22-5054
Back to AD 85-02-05 R1