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.

N41LSGendron Chistofer P · Prospect Park, PABuilt 1952 · S/N 20-862N41PLTj Air Holdings Inc Trustee · Wilmington, DES/N 30-1293N4202PWells John · Eugene, ORBuilt 1959 · S/N 23-1691N42050Baum Thomas J · Kaufman, TXBuilt 1969 · S/N 27-4081N4209PN4209p LLC · Eagle River, WIS/N 23-1702N4217PInternational Air Services Inc Trustee · Carson City, NVS/N 23-1710N4218PPn4 Aviation Holdings LLC · Bishop, CAS/N 23-1711N422CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 4496438N42362Francis Ellis H Jr · South Hill, VABuilt 1952 · S/N 22-799N4236PRegistration Pending · Chandler, AZRegistration pendingS/N 24-1260N4239POneal Hollis R · Deridder, LABuilt 1959 · S/N 23-1737N423CKBounds Keith A · Thomson, GABuilt 1981 · S/N 44-8107036N423CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 4496439N4243PLandry Lonny R · Fort Worth, TXS/N 23-1742N4248PDavila Rudolfo G · Runge, TXFirst renewal noticeBuilt 1959 · S/N 23-1747N424BYSkyline Soaring Club Inc · Front Royal, VABuilt 1968 · S/N 25-4640N4250Leafgreen Jeff A Trustee · Lander, WYBuilt 1959 · S/N 24-894N4252UDoitch Dan · Parowan, UTS/N 27-465N4253PBowles Alan B DBA · Georgetown, TXBuilt 1959 · S/N 23-1752N4254PPetersen Clayton L · Albert Lea, MNBuilt 1959 · S/N 23-1753N4259PSkypark Inc · Wadsworth, OHBuilt 1959 · S/N 23-1758N425SQSpinola Hernandes M · Homestead, FLS/N 23-1376N4262PPower Willis H · Weatherford, TXS/N 23-1761N4264PFergason John S · Louisville, OHBuilt 1961 · S/N 23-1763N4268PAhlem Mark · Hilmar, CABuilt 1959 · S/N 23-1767N4269WZeek Michael · Munfordville, KYFirst renewal noticeS/N 30-1258N4276PNiec Steven M · Clio, MIBuilt 1959 · S/N 23-1775N4284Clements Eric C · Sheridan, WYBuilt 1965 · S/N 24-4284N4286PGress Gabrielle M · Davenport, FLBuilt 1959 · S/N 23-1786N4296PInvestair LLC · Conway, ARBuilt 1959 · S/N 23-1796N4297ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-114N4299PAllison Daniel H · Whittier, NCBuilt 1959 · S/N 23-1799N429HPJohn Allen Construction LLC · Big Sandy, TNBuilt 1971 · S/N 274695N42DDG F E Management Inc · Elmira Heights, NYBuilt 1974 · S/N 31P-7400222N42PBPfister Mark A · Acworth, GABuilt 1960 · S/N 23-1895N42PMJofredo Corp · Zephyrhills, FLBuilt 1969 · S/N 30-1932N42TPBalkin John S · Bigfork, MTBuilt 1964 · S/N 30-255N42TTRhs Consulting Ltd LLC · Reno, NVBuilt 1972 · S/N 31P-60N4300PMontcalm-Mcdonald LLC · Mansfield, LAFirst renewal noticeBuilt 1959 · S/N 23-1801N4301AStevens Constance I · Homewood, CAS/N 22-3651N4302YLundstedt Gregory · Duncan, SCBuilt 1961 · S/N 23-2025N4303ANelund Craig David · Edwardsburg, MIS/N 22-3653N4304AGuslick Michael M · Milwaukee, WIBuilt 1956 · S/N 22-3655N4306YRegistration Pending · Phoenix, AZRegistration pendingBuilt 1961 · S/N 23-2029N4307AKennedy Gary R · Sanger, TXBuilt 1956 · S/N 22-3658N4307PGibson Kim · Ocean Springs, MSBuilt 1959 · S/N 23-1808N4309AParylak Sean P · Colchester, CTBuilt 1956 · S/N 22-3661N4309PSibille Philippe B · Waller, TXBuilt 1959 · S/N 23-1810N430ABAerial Banners Inc · Pembroke Pines, FLBuilt 1966 · S/N 25-3996N430MMMersereau Iden H · Goodyear, AZBuilt 1966 · S/N 24-4525
Back to AD 85-02-05 R1