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.

N5495PMilligan David Bourke · Locust Grove, GAS/N 24-556N5495YBerman Samuel I · Minneapolis, MNBuilt 1964 · S/N 27-2588N5495ZHayes Robert L · Chesapeake, VABuilt 1962 · S/N 22-9281N5496PStreetman Bryan Scott · Palm Coast, FLBuilt 1958 · S/N 24-557N5496YAmundson Nancy F · Chugiak, AKBuilt 1952 · S/N 22851N5497ZShira Daniel C · Homedale, IDBuilt 1962 · S/N 22-9283N5498KMitchell Dean R · Bay Village, OHS/N 22-8552N5498PC & J Ventures LLC · Center, COS/N 24-559N5498ZCunningham Florence Jean · Spokane Valley, WAS/N 22-9284N5499PLabelle Consulting Group Inc · OntarioBuilt 1958 · S/N 24-561N549DMCallaghan Jerry R · El Paso, TXBuilt 1961 · S/N 22-8500N54AWWilson Cecil P · Lithonia, GABuilt 1974 · S/N 27-7405392N54BCloud Nine Ventures LLC · Riverview, FLBuilt 1956 · S/N 22-4150N54MVNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1976 · S/N 27-7654043N54PPHancock Andrew M · Kettle Falls, WABuilt 1954 · S/N 22-2199N54STMac Air Aviation LLC · Xenia, OHBuilt 1974 · S/N 27-7405358N5500ZPfc Aviation Repair Inc · Wallingford, CTS/N 22-9286N5501PClairday Joey · Melbourne, ARS/N 24-563N5502PBeans David W · Sharpsburg, MDBuilt 1958 · S/N 24-564N5502YCreative Strategies Inc · Grayson, KYBuilt 1964 · S/N 27-2596N5503PCore Tech Services And Supply LLC · Odessa, FLBuilt 1958 · S/N 24-565N5504PLanghorst Richard C · Waltham, MEBuilt 1958 · S/N 24-567N5505PLandmann Ryan J · Fort Walton Beach, FLS/N 24-568N5509PBurns Regina L · Decatur, TXS/N 24-572N5514PCohran Enterprise LLC · Pineville, LABuilt 1958 · S/N 24-577N5514ZWilkinson Bruce O · Williamsburg, VABuilt 1962 · S/N 22-9301N5515ZLandrum Kelly T · Halifax, VABuilt 1962 · S/N 22-9302N551MDVero Technical Support Inc · Pensacola, FLBuilt 1978 · S/N 44-7995112N5521PSkyview Aviation Services Inc · Lakeland, FLBuilt 1958 · S/N 24-584N5521ZTessenear James A · Hopewell, VABuilt 1962 · S/N 22-9309N5522ZWolfe Robert N · Rogers, TXBuilt 1962 · S/N 22-9310N5523PBens Motorworks Inc · Fullerton, CAS/N 24-586N5524PSwarm Darryl J · Quincy, CABuilt 1958 · S/N 24-587N5526PWard County Irrigation District #1 · Barstow, TXS/N 24-589N5528ZSmith Ryan M · Midland, TXS/N 22-9317N552MDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 447995008N552PCSaint Louis University · Saint Louis, MOBuilt 2001 · S/N 4496069N5530ZReeves Todd J · Mosier, ORS/N 22-9319N5531ZDarr Henry S · Drummond, MTBuilt 1962 · S/N 22-9321N5532PHoudek Todd L · Roseburg, ORBuilt 1958 · S/N 24-596N5533PRado Richard L · Fortville, INBuilt 1958 · S/N 24-597N5533YAce Tomato Co LLC · Daytona Beach, FLBuilt 1964 · S/N 27-2631N5535ZPayne Dustin J · Weirsdale, FLS/N 22-9325N5536PGryhon Designs · Camden, SCBuilt 1958 · S/N 24-600N5537ARobinson Albert B · Byhalia, MSS/N 20-776N5537PField Gerard · Middleboro, MABuilt 1958 · S/N 24-601N5538ARado Robert L · Petersburg, MIBuilt 1952 · S/N 20-944N5538ZBradburn William P · Pearl River, LAS/N 22-9328N5539ASchneider Benjamin J · Wheeling, WVS/N 20-945N553PCSaint Louis University · St Louis, MOBuilt 2001 · S/N 4496072
Back to AD 85-02-05 R1