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.

N8468YStone D L · Arlington, TXBuilt 1967 · S/N 30-1629N846PAfonso Joseph · Wallkill, NYBuilt 1967 · S/N 24-4695N8474PCopass Benjamin J · Fountain Run, KYS/N 26-49N8475PBlackdog Air LLC · Wilmington, DEBuilt 1964 · S/N 26-53N8475YSolymossy Robert A · Tysons, VABuilt 1967 · S/N 30-1637N8477PD F Osborne Construction Inc · Topeka, KSBuilt 1964 · S/N 26-55N847BRegistration Inc · Kalispell, MTS/N 30-348N847EDFoster Matthew R · Poplar Grove, ILBuilt 1968 · S/N 30-1692N847NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 4496474N847SPRothschild Joel S · Crestline, CABuilt 1964 · S/N 26-48N8480PGlaser Violet E · Calhan, COBuilt 1964 · S/N 26-58N8481PBailey Roger R · Mineral, TXBuilt 1964 · S/N 26-60N8482PHogan John Robert · Palm Beach Gardens, FLBuilt 1964 · S/N 26-61N8483PHigh Wing Aviation LLC · Sardis, MSBuilt 1964 · S/N 26-62N8486PHaawq Air LLC · Brookshire, TXS/N 26-65N8486ZKlompstra John V · Wadsworth, OHBuilt 1963 · S/N 30-227N8487YAviation Safety Dynamics LLC · Richmond, TXBuilt 1967 · S/N 30-1650N8489YSorbi Aviation Inc · El Cajon, CABuilt 1967 · S/N 30-1652N8491DDirty Side Down LLC · Downers Grove, ILBuilt 1957 · S/N 22-5718N8491PHansen Jed D · Clark, SDBuilt 1965 · S/N 26-70N8492YGaipa Timothy A · Saint Joseph, MIBuilt 1967 · S/N 30-1655N8493PKeystone Flyer LLC · Avon, INS/N 26-73N8494DKincaid Jonathan A · Frankfort, MEBuilt 1957 · S/N 22-5721N8496YOsiol Russell E · Chicago, ILS/N 30-1297N8497PCrotts Leigh O · Peoria, AZBuilt 1964 · S/N 26-77N8498DBig Boy Business LLC · Oklahoma City, OKBuilt 1957 · S/N 22-5725N8498PMiller Marc D Trustee · Tempe, AZBuilt 1964 · S/N 26-78N8499DHolton Randall B · Folley Beach, SCBuilt 1957 · S/N 22-5726N849AScharf Mark T · Rosamond, CAS/N 22-151N849ATAtp Taa LLC · Wilmington, DEBuilt 2023 · S/N 4496567N84JPNichols John E · Bogalusa, LABuilt 1964 · S/N 26-67N84JSKocak Robert G Jr · Peoria, AZBuilt 1966 · S/N 30-1222N84TDBailey Dennis · Kernersville, NCBuilt 1969 · S/N 30-1951N84VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 24-1492N8500DScootair LLC · Alburgh, VTBuilt 1957 · S/N 22-5727N8500QEilinger Richard L · Hertford, NCBuilt 1953 · S/N 22-1213N8501DStrausser Brian J · Lower Burrell, PABuilt 1957 · S/N 22-5728N8501LSnider Scott E DBA · Turner, MTBuilt 1969 · S/N 25-4915N8502DConrad Dylan · Randolph, WIBuilt 1957 · S/N 22-5729N8503CScites Robert W · Toney, ALBuilt 1953 · S/N 22-1215N8503YRoberti John O · Barre, VTBuilt 1967 · S/N 30-1662N8504LTexas Soaring Association · Midlothian, TXBuilt 1969 · S/N 25-4919N8505DRegistration Pending · Wilmington, DERegistration pendingBuilt 1957 · S/N 22-5732N8505YCli Aerospace LLC · Appleton, WIBuilt 1968 · S/N 30-1665N8506YWilliams Russell D · Rehoboth Beach, DEBuilt 1967 · S/N 30-1666N8507DFischer Duane A · New Baden, ILBuilt 1957 · S/N 22-5734N8507YWhiteley Robert L · Pittsburg, CABuilt 1967 · S/N 30-1667N8508DHuhndorf Joshua L · Port Ludlow, WABuilt 1957 · S/N 22-5735N8509DVeal Petra I · Sterling, AKBuilt 1957 · S/N 22-5736N8509PWalsh Robert A · Katy, TXBuilt 1964 · S/N 26-89
Back to AD 85-02-05 R1