OpenAirDocs.org
AD 85-03-01

Registered aircraft · 1,386

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.

N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839N100DZSkydive Santa Barbara LLC · Lompoc, CABuilt 1966 · S/N U206-0693N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932N102JJGrose Christopher E · San Antonio, TXBuilt 1966 · S/N T210-0123N104KJb Aircraft LLC · Anchorage, AKBuilt 1969 · S/N 20700122N1071MJesperson Kenneth R · Ekalaka, MTBuilt 1969 · S/N T210-0451N109HBadke Paul J · Ray, MIBuilt 1962 · S/N 21057921N10ARK Airmotive LLC · St Helens, ORBuilt 1966 · S/N U206-0738N10CCSmith Kord S · Salmon, IDBuilt 1964 · S/N 206-0166N10GMAlo Aviation LLC · Titusville, FLS/N T210-0151N10RVKoehn Shane Michael · Scooba, MSBuilt 1964 · S/N 21058418N111NJNew Jersey Forest Fire Service · Trenton, NJBuilt 1964 · S/N U206-0278N111PWKilgore Eric M · Genoa, NVS/N T210-0066N119MSAeronorth LLC · Ann Arbor, MIBuilt 1969 · S/N 21059121N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058N1205BEngel Shane J · Willow, AKBuilt 1963 · S/N 205-0190N122FSiver Creek Capital LLC · Emery, SDS/N 21058967N123JTGraham Richard A · Wichita Falls, TXBuilt 1965 · S/N T210-0019N123KTHolliday Paul B · Kiln, MSBuilt 1963 · S/N 21058218N123UAwg Aviation LLC · Ainsworth, IABuilt 1968 · S/N 21059004N1333TWoodford Michael F · Fabius, NYBuilt 1969 · S/N T210-59108N136JRaichl John P · Astoria, ORBuilt 1962 · S/N 205-0136N13BJSevcik Clint · Medford, MNS/N 21058486N143TCHarris William D · Topeka, KSBuilt 1962 · S/N 205-0064N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332N146FCUsda Forest Service Fepp · Malvern, ARBuilt 1966 · S/N P206-0247N14872Blumenthal James R · Kingman, AZBuilt 1973 · S/N U20602144N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212N1517UN1517u LLC · Mequon, WIBuilt 1969 · S/N 20700117N1518UN1518u LLC · Waukesha, WIS/N 20700118N1545GSaltzer Eric R · Somerton, AZBuilt 1966 · S/N T210-0208N154BCTen Knot Tailwind LLC · Mesa, AZBuilt 1969 · S/N 21059157N154EFAdams Donald C · Garner, NCBuilt 1968 · S/N 21059089N155KTN155kt LLC · Dover, DEBuilt 1963 · S/N 21058196N1570UReno70 LLC · Anchorage, AKBuilt 1970 · S/N 20700170N1587UGrant Aviation Inc · Anchorage, AKS/N 20700187N1650UWilson Joshua Allen · Mckinney, TXBuilt 1974 · S/N 20700250N1658URenfro Michael W · Bethel, AKBuilt 1974 · S/N 20700258N165WFHardin John M · Terrell, TXBuilt 1962 · S/N 210-57875N1668UUngalik Syndicate LLC · Unalakleet, AKBuilt 1975 · S/N 20700268N169PGHarty Joshua · Strasburg, COS/N T210-0423N16HTAviation Specialties Unlimited Inc · Boise, IDBuilt 1964 · S/N 2060134N1704UKuspuk School District · Aniak, AKBuilt 1975 · S/N 20700304N1717XSay Plastics Inc · Jacksonville, TXBuilt 1967 · S/N T2100267N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960N1748UIliamna Air Taxi Inc · Iliamna, AKBuilt 1976 · S/N 20700348N1748ZRanz Douglas R · West Bloomfield, MIBuilt 1962 · S/N 205-0047N1749UFreshwater Adventures Inc · Dillingham, AKBuilt 1976 · S/N 20700349N1750URenfro Michael W · Bethel, AKBuilt 1976 · S/N 20700350
Back to AD 85-03-01