OpenAirDocs.org
AD 99-01-05 R1

Registered aircraft · 10,639

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:99-01-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:99-01-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.

N8646DAdams James F · Flagstaff, AZBuilt 1958 · S/N 22-5854N8647CBrown Roger K · Port Saint Lucie, FLS/N 22-1335N86483Eaa Aviation Foundation Inc · Oshkosh, WIBuilt 1957 · S/N 22-5777N8648CHouse Justin W · Uriah, ALBuilt 1953 · S/N 22-1326N8649DGho Michael M · Fairbanks, AKBuilt 1958 · S/N 22-5857N8650CMalan Desiree · Anchorage, AKBuilt 1953 · S/N 18-2735N8653YMorris Equipment LLC · Yuma, AZS/N 18-7309024N8654DTreml Kent E · Luxemburg, WIS/N 22-5861N8655CBraun Ronald J · Wasilla, AKBuilt 1953 · S/N 18-2787N8656CRhodes Charles R · Homosassa, FLBuilt 1953 · S/N 18-2786N8656LAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1969 · S/N 25-5101N8657DParks John T · Ripon, WIBuilt 1958 · S/N 22-5865N8658LMid Atlantic Soaring Association Inc · Frederick, MDBuilt 1969 · S/N 25-5104N8659CBraddock Randall C · Syracuse, KSBuilt 1953 · S/N 18-2791N865ESHangar Ak LLC · Sterling, AKS/N 18-7874N8660DManuella Timothy J · Sandusky, OHS/N 22-5868N8661DSheets Wayne H · Hagaman, NYBuilt 1958 · S/N 22-5869N8662CKillen Land & Livestock · Angela, MTBuilt 1953 · S/N 18-2796N8663DLawrence Alexander · Miamisburg, OHBuilt 1958 · S/N 22-5871N8664DWyant David Mark · Dallas, TXBuilt 1958 · S/N 22-5872N8664YWard Nelson Harley · Salcha, AKBuilt 1970 · S/N 18-8895N8665CBlack Butch · Lakeside, NEBuilt 1953 · S/N 18-2799N8670CReabe Damon P · Ripon, WIBuilt 1953 · S/N 18-2814N8670LSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1969 · S/N 25-5123N8671CKasemodel Alan D · Billings, MTBuilt 1953 · S/N 18-2837N8671MPiper Aviation Museum Foundation · Lock Haven, PAS/N 12-2623N8672DPlate Ronald L · Soldotna, AKS/N 18-6273N8673LKnutson Wayne R · Tioga, NDBuilt 1968 · S/N 25-4791N8676CGillett Glen C · Roy, MTS/N 18-2821N8677CSchneider Richard J · Wasilla, AKS/N 18-2822N8681CEvans Richard H · Niceville, FLBuilt 1953 · S/N 22-1343N8681DWayward Willow LLC · Wasilla, AKBuilt 1958 · S/N 18-6286N8682DCasabonne Family Ltd Partnership · Hope, NMBuilt 1958 · S/N 18-6287N8683CDirt Strip LLC · Kalispell, MTBuilt 1953 · S/N 22-1341N8684CWest Yvonne R · Warrensburg, NYS/N 20-1008N8684DScott Lonnie L · Nikiski, AKBuilt 1958 · S/N 18-6289N8687CMorgigno Daniel A · Mission Viejo, CABuilt 1953 · S/N 22-1358N8688DHarmon Mike D · Mansfield, SDS/N 18-6295N868PKYellow Therapy LLC · Kalispell, MTBuilt 1982 · S/N 18-8209021N868RTMartin John D · Billings, MTS/N 18-7809119N8691COrtet Craig A · Etna, WYBuilt 1953 · S/N 22-1331N8692DBryan Kirk J · Big Timber, MTS/N 18-6298N8694DJunek John M · Leonardtown, MDS/N 18-6303N8696DDupuis Raymond F Jr · Pelham, NHBuilt 1958 · S/N 18-6306N8697DHigher Ground Aviation LLC · Ely, MNBuilt 1958 · S/N 18-6307N8697LFried Stephen · Kingston, MABuilt 1969 · S/N 25-5124N8698CRichard Waldren LLC · Newberg, ORBuilt 1953 · S/N 22-1348N8699DBohannon James A III · Waller, TXBuilt 1958 · S/N 18-6277N869WCSchofield Wayne D · Polson, MTBuilt 1957 · S/N 22-5521N86ABAir Sailing Inc · Reno, NVBuilt 1965 · S/N 25-3409
Back to AD 99-01-05 R1