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.

N5912DRenner David L · Ferndale, CAFirst renewal noticeBuilt 1956 · S/N 22-4574N5912PHarris Gerald Trustee · Rancho Murieta, CABuilt 1959 · S/N 24-998N5913DCaldwell Caleb Z · Anchorage, AKBuilt 1956 · S/N 22-4575N5913PMercer Gary L · Eaton, OHBuilt 1959 · S/N 24-999N5914PAnderson Harry E · Missoula, MTBuilt 1959 · S/N 24-1000N5915DMason Jack A · Reidsville, NCBuilt 1956 · S/N 22-4577N5915PBair James R · Lucas, IAFirst renewal noticeBuilt 1959 · S/N 24-1002N5917PRanger Aviation Inc · Burlington, COS/N 24-1004N5917ZKoch Christopher P · Batavia, NYBuilt 1963 · S/N 22-9785N591NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 4496633N5920DBates Matthew T · Springfield, VABuilt 1956 · S/N 22-4582N5920YAdvanced Mosquito Control & Technology Inc · Boyle, MSBuilt 1965 · S/N 27-3077N5922PWiseman Transport LLC · Henderson, TXBuilt 1959 · S/N 24-1009N5922YUltimate Air Parts LLC · Strasburg, VABuilt 1965 · S/N 27-3080N5922ZBellamy John Mark · Freeville, NYBuilt 1964 · S/N 22-9791N5924PPope Mark I · Arco, IDBuilt 1959 · S/N 24-1011N5926DToste Greg · Newcastle, CABuilt 1956 · S/N 22-4589N592NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2026 · S/N 4496634N5930YHopkins Frank Michael · Wilmington, DEBuilt 1965 · S/N 27-3091N5930ZBrue Peter Gary · Cedar Rapids, IABuilt 1964 · S/N 22-9800N5931DStone Robert K · Piney Flats, TNBuilt 1956 · S/N 22-4594N5933DHoward Trent R · Mandan, NDS/N 22-4596N5934DBalsley Matthew G · Rowlett, TXS/N 22-4597N5934ZNew Daniel A · Deming, WAS/N 22-9804N5935PDaniel Hardy L Jr · Derby, KSBuilt 1959 · S/N 24-1025N5936DSchreiber Faith E · Valparaiso, INBuilt 1956 · S/N 22-4599N5936ZMeulenberg Jacobus M J · Schenevus, NYS/N 22-9806N5937PTindall Michael C · Granite City, ILBuilt 1959 · S/N 24-1027N5937ZFurman Maximillian · Barnum, MNS/N 22-9807N5938YFly For Fun Aircraft LLC · Rockville, MDBuilt 1965 · S/N 27-3103N593NDChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 4496270N5940DRunnin Rabbit LLC · Kalispell, MTBuilt 1956 · S/N 22-4603N5940ZMoore Roger W · Poinciana, FLS/N 22-9811N5941ZByler Jonathan P · Inman, SCBuilt 1964 · S/N 22-9812N5942DFour For Flying Inc · Holyoke, COBuilt 1956 · S/N 22-4605N5943PHarper Carlyle W · Ocilla, GABuilt 1959 · S/N 24-979N5944DBradley Dennis Michael · Myrtle Beach, SCBuilt 1956 · S/N 22-4607N5944PMay Russell L · Las Cruces, NMBuilt 1959 · S/N 24-1034N5945DKline Paul R · Mapleton Depot, PABuilt 1956 · S/N 22-4608N5945ZThompson Neal R · Magnolia, DEBuilt 1964 · S/N 22-9816N5946DInsite Design LLC · Indianapolis, INBuilt 1956 · S/N 22-4610N5946PHoward W E Barney · San Marcos, TXBuilt 1959 · S/N 24-1036N5946Z507 Flying Club Inc · Leetonia, OHBuilt 1964 · S/N 22-9817N5947DPayne David J · Eagle River, AKBuilt 1956 · S/N 22-4611N5947PJam Naba Sem LLC · Beavercreek, OHBuilt 1959 · S/N 24-1037N5948DHumble Servant LLC · Salem, WIBuilt 1957 · S/N 22-4612N5948POverstreet Robert S · Clarksville, VABuilt 1959 · S/N 24-1039N5948YFbm LLC · Laporte, INS/N 27-3114N5949DWick Marcel P · Warsaw, NYBuilt 1956 · S/N 22-4613N5949PDyer Thomas L · Sparks, NVBuilt 1959 · S/N 24-1040
Back to AD 85-02-05 R1