OpenAirDocs.org
AD 85-02-05 R1

Registered aircraft · 8,921

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.

N3166ZDarr J L III · Trinity, NCBuilt 1959 · S/N 22-7117N3169ZBixler Tyke L · Massillon, OHBuilt 1959 · S/N 22-7120N316PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496125N3170ZGarrity Frank B · Durham, CABuilt 1959 · S/N 22-7122N3172ZSpitzer Anthony L · Kalona, IABuilt 1959 · S/N 22-7124N3176ZKielty Ronald · Ocala, FLBuilt 1959 · S/N 22-7128N3177ZMorris David P · Inverness, FLS/N 22-7131N317PASkywest Leasing Inc · St George, UTS/N 4496133N317PZFairmont State University · Fairmont, WVBuilt 1980 · S/N 27-8054047N317RJN317rj Inc · Maitland, FLBuilt 1966 · S/N 30-1249N3187PAir Over Ground LLC · Helena, MTS/N 23-1124N318PABird Acquisition LLC · Phoenix, AZBuilt 2002 · S/N 4496134N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184N319AUChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 4496585N31BTMiddle Georgia Aviation Inc · Cochran, GABuilt 1960 · S/N 22-7447N31DEBarber Deans Elliott III · Selma, ALBuilt 1961 · S/N 27-504N31FACarlisle Robert · Pensacola, FLBuilt 1960 · S/N 27-215N31JPOstmeyer John M · Gardner, KSBuilt 1956 · S/N 22-3913N31PCFlight World Inc · San Juan, PRBuilt 1958 · S/N 23-1349N31PNRhs Consulting Ltd LLC · Reno, NVBuilt 1976 · S/N 31P-7630009N31RCJoey Os LLC · Darlington, PAS/N 27-2818N31TUKalm Air Inc · Junction, TXBuilt 1973 · S/N 27-7305011N31TVCornea Kevin Troy · Palm City, FLBuilt 1979 · S/N 27-7954054N31WHDerbecker David G · Katy, TXBuilt 1969 · S/N 24-4810N3200BMuehl Harvey C · Macomb, MIBuilt 1954 · S/N 22-2027N3200GSpinner Family Limited Partnership · White City, ORBuilt 1956 · S/N 22-4042N3200ZBrady Michael E · Buffalo, NYBuilt 1959 · S/N 22-7140N3201ZMcclain William J · Corona, CABuilt 1959 · S/N 22-7141N3205BDurben Robert W · Newcomerstown, OHBuilt 1953 · S/N 22-2032N3206BNull Clifford M · Punxsutawney, PAS/N 22-2033N3208BBallou Robert L · Puyallup, WABuilt 1953 · S/N 22-2035N3209BDebuck Nathan J · Edgewood, NMS/N 22-2036N320AUAuburn University · Auburn, ALBuilt 2020 · S/N 4496496N320GCNordquist Mark O · Petaluma, CABuilt 1970 · S/N 39-60N320JLInspired Oasis LLC · Salem, ORBuilt 1969 · S/N 244886N320MRSic Direct Aviation Inc · Kingwood, TXBuilt 1969 · S/N 30-1917N320RBLogan David J · Saint Helens, ORBuilt 1963 · S/N 27-2389N3210Perry Daryl C · Sanford, NCBuilt 1961 · S/N 22-8079N3211BHinton Scott · Elizabeth City, NCBuilt 1953 · S/N 22-2038N3211PJudie Bear Air LLC · Bend, ORFirst renewal noticeBuilt 1957 · S/N 23-1152N3213ZDasher Daryl L · Boring, ORBuilt 1959 · S/N 22-7153N3215ZCastle Richard E · Callao, MOS/N 22-7155N3216Ropp Dwight F · Pasco, WAS/N 30-796N3217ZQuality Aviation Inc · Marana, AZFirst renewal noticeBuilt 1959 · S/N 22-7158N321ACB & H Aviation LLC · Marion, KYBuilt 1974 · S/N 27-7405334N321CCMclaughlin Ralph B · Groveland, CAS/N 277304950N321NCArizona Air Salvage · Phoenix, AZBuilt 1977 · S/N 27-7754101N3222ZBoggs Anthony M · Pringle, SDBuilt 1959 · S/N 22-7163N3224BSkyward Solutions Inc · Lewes, DEBuilt 1954 · S/N 22-2052N3224ZBagley Sherell G · Suwanee, GABuilt 1959 · S/N 22-7168
Back to AD 85-02-05 R1