AD 85-03-01

Registered aircraft · 1,385

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-03-01')
    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-03-01')
  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.

N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354N1758UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 20700358N17CJ16d Aviation LLC · Vashon, WABuilt 1968 · S/N U206-1199N17HSRed Oak Centurion LLC · Red Oak, IABuilt 1967 · S/N 21058844N17JYYorkavitz James B · Valley City, OHBuilt 1969 · S/N 21059154N17NFBravo Hotel LLC · Lewes, DES/N P206-0369N17TCKenyon Walter C · Eureka Springs, ARBuilt 1964 · S/N 21058499N1800FReid Brian M · Boise, IDBuilt 1965 · S/N 21058700N1801ZGould Robert R Jr · Sterling, VABuilt 1962 · S/N 205-0001N1802FSantiago Ferdinand · Calhoun, GABuilt 1965 · S/N 21058702N1802ZSparks Timothy J · Jackson, MIBuilt 1962 · S/N 205-0002N1804FWaage Todd · Greenbush, MNBuilt 1965 · S/N 21058704N1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedBuilt 1962 · S/N 205-0008N1809ZCleared For Departure LLC · Kennewick, WABuilt 1962 · S/N 205-0009N1810ZRanzway Corp · Seattle, WABuilt 1962 · S/N 2050010N1814FAlpine Cable And Construction Inc · Grand Junction, COBuilt 1965 · S/N 21058714N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716N181DHWinkler Jeffery L · Brush, COBuilt 1964 · S/N 206-0220N1820ZStaats Douglas E · Anchorage, AKBuilt 1962 · S/N 205-0020N1821FAlexander Travis · Hudson Oaks, TXS/N 21058721N1821SBailey Ralph E · Sikeston, MOBuilt 1962 · S/N 2050021N1822ZAhrens Kevin Michael · Cashmere, WABuilt 1962 · S/N 205-0022N1825ZGreentek Inc · Oroville, CABuilt 1962 · S/N 205-0025N1828FDrew Kevin · Fredonia, PABuilt 1965 · S/N 21058728N1828ZHorrocks Charles M · Blackfoot, IDBuilt 1962 · S/N 205-0028N1833FHale Jay · Corpus Christi, TXS/N 21058733N1833ZEastwood Gregory S · Red Oak, TXBuilt 1962 · S/N 205-0033N1835ZRegistered aircraftBuilt 1962 · S/N 205-0035N1838ZAgee Mark L · Greenacres, WABuilt 1962 · S/N 205-0038N1839FHentz Randy Reuben · Tower City, PABuilt 1966 · S/N 21058739N1842ZVermont Skydiving Adventures Inc · Bristol, VTBuilt 1962 · S/N 205-0042N1843FJordan Jay · Centre, ALBuilt 1966 · S/N 21058743N1843ZVacek George T Jr · Anchorage, AKBuilt 1962 · S/N 205-0043N1844ZN1844z LLC · Hillsboro, ORBuilt 1962 · S/N 205-0044N1845FJones Sandy Ray · Williamsburg, NMS/N 21058745N1848ZBritt Robert J · Augres, MIBuilt 1962 · S/N 205-0048N1849FCrouse William F · Priest River, IDBuilt 1966 · S/N 21058749N1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 21058752N1854FHarlan Bradley J · New Brighton, MNBuilt 1966 · S/N 21058754N1854ZBargabos William M · Wasilla, AKS/N 2050054N1858ZPairofminutes LLC · Marshville, NCS/N 205-0058N1859FBaker Robert J · Ogema, MNBuilt 1966 · S/N 21058759N1863FAndersen Dana K · Scappoose, ORS/N 21058763N1864FSwensen Nathan E · Winnemucca, NVS/N 21058764N1865ZBpf Equipment LLC · Burnet, TXBuilt 1962 · S/N 205-0065N1867FIcarus Aviators LLC · Canon City, COBuilt 1966 · S/N 21058767N1868ZZulu Forty One LLC · Anchorage, AKBuilt 1962 · S/N 205-0068N1869FRegistration Pending · Dublin, OHRegistration pendingBuilt 1966 · S/N 21058769N1869ZPinnell Bradley T · Lake Havasu City, AZBuilt 1962 · S/N 205-0069N186RDWayson Air LLC · Mount Auburn, IABuilt 1966 · S/N 21058761
Back to AD 85-03-01