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.

N56844Lubben Ryan D DBA · Fergus Falls, MNBuilt 1974 · S/N 36-7460006N5684PAce Drilling LLC · Johnson, KSBuilt 1959 · S/N 24-756N5684ZMuehlberg Stephen E · Newcastle, OKBuilt 1962 · S/N 22-9514N5686PGray Gary L · Frederick, OKBuilt 1959 · S/N 24-758N5687YBrouse Dan T · Magnolia, TXBuilt 1965 · S/N 27-2805N5688YYates Mary A · Haysi, VABuilt 1965 · S/N 27-2806N5689ZNichols Troy G · Clinton, ARS/N 22-9522N5691PCoady Michael · Taylorville, ILBuilt 1959 · S/N 24-763N5693PBays Aviation LLC · Boerne, TXBuilt 1959 · S/N 24-766N5693YAlligator Air Transport LLC · Fort Lauderdale, FLS/N 27-2813N5693ZRustin Cody W · Reynolds, GABuilt 1962 · S/N 22-9527N5697ZLink James L · Raleigh, NCS/N 22-9532N5699PHahn Curtis D · St George, UTBuilt 1959 · S/N 24-772N56ADTifc LLC · Winnsboro, SCBuilt 1971 · S/N 27-4642N56CCMichel David L · Pickens, SCBuilt 1959 · S/N 24-1297N56DFThorpe Arthur N Jr · Salisbury, MDBuilt 1980 · S/N 44-8107030N5700PEdmundson George · Burlington, WABuilt 1959 · S/N 24-773N5702PChilds Group Inc · Altoona, IABuilt 1959 · S/N 24-775N5702YLil Dawg Aviation Inc · Wilmington, DES/N 27-2823N5702ZVanhouten Christian J · Tunkhannock, PABuilt 1962 · S/N 22-9540N5704ZSmalbergher Dorin · Soldiers Grove, WIBuilt 1963 · S/N 22-9542N5705DBirdwell Brett M · Lewistown, MTBuilt 1956 · S/N 22-4401N5705PN5705p Inc · Pompano Beach, FLBuilt 1959 · S/N 24-778N5706DReese Lonnie E · Talking Rock, GAS/N 22-4402N5708ZSantee Steven J · Ellendale, MNBuilt 1962 · S/N 22-9547N5709PSaadjack LLC · Amelia Island, FLBuilt 1959 · S/N 24-783N5709ZBettilyon Walter S · Shady Shores, TXBuilt 1963 · S/N 22-9548N570PUPurdue University Trustees · West Lafayette, INBuilt 2002 · S/N 4496141N5710ZSpangler David G · New Richmond, WIBuilt 1962 · S/N 22-9549N5711DEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4407N5712DLo Jeffrey G · San Jose, CABuilt 1956 · S/N 22-4408N5712PGibson Kevin M · Denver City, TXBuilt 1959 · S/N 24-786N5712ZVollmerhausen Otto J · Bethpage, NYBuilt 1963 · S/N 22-9551N5713YAnderson Leroy · San Angelo, TXBuilt 1965 · S/N 27-2835N5714DAnte George Sherman Jr · Eagle River, AKBuilt 1956 · S/N 22-4410N5714YWild Frederick E Jr · Oklahoma City, OKBuilt 1965 · S/N 27-2836N5715DScootair LLC · Alburgh, VTS/N 22-4411N5715ZProper Theron · Arlington, AZBuilt 1963 · S/N 22-9554N5716DNeumayer Barry A · Redlands, CABuilt 1956 · S/N 22-4412N5717DClaxon David W · Gifford, ILS/N 22-4415N5717PGraber Tim B · Santee, CABuilt 1959 · S/N 24-791N5717ZJohnston Charles W C Jr · Newfield, NJBuilt 1963 · S/N 22-9556N5718DBurk Albert A Jr · Parkville, MDBuilt 1956 · S/N 22-4416N571ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496193N571PUPurdue University Trustees · West Lafayette, INBuilt 2002 · S/N 4496142N5720PPatterman Emil S · Fort Worth, TXS/N 24-794N5720ZIrvine Hollis E Jr · Greenwich, NJBuilt 1963 · S/N 22-9559N5722PCrazy 8 Aviation LLC · Ridgecrest, CABuilt 1959 · S/N 24-796N5724ZKpa LLC · Kalamazoo, MIS/N 22-9563N5725PJason Waddell Pllc · Oklahoma City, OKBuilt 1959 · S/N 24-799
Back to AD 85-02-05 R1