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.

N3853PLambert Aviation LLC · Charlotte, NCBuilt 1955 · S/N 22-3545N3854PBall Logan T · Dillingham, AKS/N 22-3546N3855PGriffith Jacob C · Bedford, PABuilt 1956 · S/N 22-3547N385WKTriva Solutions LLC · El Paso, TXS/N 27-4130N3861PDellinger Jeremiah · Eagle River, AKBuilt 1955 · S/N 22-3553N3866PWateractive43 LLC · Auburn, CABuilt 1955 · S/N 22-3558N386ABPlane And Simple Leasing LLC · Delano, MNBuilt 1966 · S/N 25-3790N386AVWestwind School Of Aeronautics Phoenix · Goodyear, AZBuilt 2025 · S/N 4496614N3870PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1955 · S/N 22-3563N3874PPearson Joshua J · Unionville, MOS/N 22-3567N38760Davis Robby E · Plant City, FLBuilt 1969 · S/N 30-1999N388LBSdgair LLC · Port Orange, FLBuilt 1964 · S/N 30-511N388METrinity Aviation Group LLC · Hudson Oaks, TXBuilt 1955 · S/N 23-322N38AGBaxter Kyle W · Tumwater, WABuilt 1959 · S/N 24-1259N38FJAty Aviation Inc · Watertown, SDBuilt 1989 · S/N 4495009N3903PPeterman Michael N · Huron, OHBuilt 1956 · S/N 22-3572N3904PJohnson Rusty E · Enumclaw, WAS/N 22-3573N3906PJb Efta Farms Inc · Argyle, MNS/N 22-3575N390ASOcala Aviation Services Inc · Ocala, FLS/N 27-3117N390UChristiansen Aviation LLC · Wilmington, DEBuilt 1999 · S/N 4496025N390WWalter Paul F · Milwaukee, WIBuilt 1970 · S/N 39-39N3914POrtiz Fernando Mark · Squaw Valley, CAS/N 22-3584N3915PDryer Lucien E · Boise, IDBuilt 1956 · S/N 22-3585N391MGHagedorn Aviation Inc · Columbus, OHBuilt 1975 · S/N 27-7554131N3921PRadwanick Louis S · Virginia Beach, VABuilt 1957 · S/N 22-3591N3922PMoulton Robert Paul · Middletown, NYBuilt 1955 · S/N 22-3594N3924PYetter Mark · Georgetown, PABuilt 1956 · S/N 22-3597N3927PLenz Jerry L · Loveland, COBuilt 1956 · S/N 22-3600N3929CWest Candace F · Helena, MTBuilt 1969 · S/N 27-4049N3930PMatson Dean R · Spring, TXBuilt 1956 · S/N 22-3605N3932PCuozzo Alfred F · Eagle Point, ORBuilt 1956 · S/N 22-3607N3936PTroyer Robert E · Toledo, WABuilt 1956 · S/N 22-3611N3938PSwoboda Matthias W · Green Bay, WIBuilt 1956 · S/N 22-3613N393TBTom Brown Consulting LLC · Ave Maria, FLBuilt 1969 · S/N 30-1874N3945EGeorgeson Troy D · Sheyenne, NDBuilt 1978 · S/N 36-7802066N3945PLiedtka Thomas M · Stevensville, MTBuilt 1956 · S/N 22-3620N3947PGilger Douglas D II · Boyes, MTBuilt 1956 · S/N 22-3622N3948PMoore Roger D · Lubbock, TXBuilt 1956 · S/N 22-3623N3949PGriggs Luz V · Goddard, KSBuilt 1956 · S/N 22-3626N3951PDuncan Kyle A · Whiteville, NCBuilt 1956 · S/N 22-3628N3954PUecker Garrett J · Holdrege, NEBuilt 1956 · S/N 22-3631N3955PBent Prop Club LLC · Waverly, IAS/N 22-3633N3956PWheels Up LLC · Evansville, INBuilt 1956 · S/N 22-3634N3957EAurora Cooperative Elevator Co · Aurora, NEBuilt 1978 · S/N 36-7802069N3958EJohnson Lynn L · Grafton, NDBuilt 1978 · S/N 36-7802070N3958PHoward Kevin B · Plymouth, MIBuilt 1956 · S/N 22-3636N3961PMcquivey David · St George, UTS/N 22-3639N39621Zulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 44-7995016N3964PWard Scot · Belgrade, MTBuilt 1956 · S/N 22-3644N3965PSlaughter Don Wayne · Farmville, NCFirst renewal noticeBuilt 1956 · S/N 22-3645
Back to AD 85-02-05 R1