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.

N83346Riedel Alexander W · Seguin, TXBuilt 1976 · S/N 18-7609086N83347Farrier Ken J · Torrington, WYBuilt 1976 · S/N 18-7609087N83349Betz Timothy W J · Anchorage, AKS/N 18-7609089N83354Stephl Matt J · Anchorage, AKBuilt 1976 · S/N 18-7609094N83358Minikey Jack DBA · Stanton, MIBuilt 1976 · S/N 18-7609098N83359Magalsky Jacob J · Wilsall, MTBuilt 1976 · S/N 18-7609099N83362Magnuson Robert L Jr · Mc Grath, AKBuilt 1976 · S/N 18-7609092N83367Peterson Leland C Co Trustee · Anchorage, AKBuilt 1976 · S/N 18-7609100N83368High Mountain Air LLC · Missoula, MTBuilt 1976 · S/N 18-7609091N83374Vanmeter Dustin D · Kasilof, AKS/N 18-7609101N83378Aldridge Brett A · Soldotna, AKBuilt 1976 · S/N 18-7609105N83379Nei Jeffrey G · Bemidji, MNBuilt 1976 · S/N 18-7609107N83381Fishfull Thinking LLC · Cordova, AKBuilt 1976 · S/N 18-7609111N83386Treit Marlowe · Aurora, ORBuilt 1976 · S/N 18-7609112N83392Guy James L P · Wasilla, AKS/N 18-7609117N83394Hard Luck Aviation LLC · Tok, AKBuilt 1976 · S/N 18-7609118N83395Jorgensen Spike C · Tok, AKBuilt 1976 · S/N 18-7609119N83397Gila Aviation Co LLC · Whitefish, MTBuilt 1976 · S/N 18-7609120N833AMessinger Kevin R · Palmerton, PAS/N 22-135N83403Weaver Andrew J · Palmer, AKS/N 18-7609121N83404Keech Mark A · Fairbanks, AKBuilt 1976 · S/N 18-7709051N83411State Of Montana Fish Wildlife And Parks · Helena, MTS/N 18-7609122N83412Mifflin Enterprises LLC · Mansfield, OHBuilt 1976 · S/N 18-7609123N83417Wood Gordon S · Logan, UTBuilt 1978 · S/N 18-7909027N83418Kagerer John A Trustee · Anchorage, AKBuilt 1976 · S/N 18-7609125N83421Lunoe Finn · Anchorage, AKS/N 18-7609126N83422Mcnamara Michael G · Anchorage, AKS/N 18-7609127N83424Carpenter Richard A · Hermiston, ORBuilt 1976 · S/N 18-7609128N83433Registered aircraftBuilt 1976 · S/N 18-7609132N83434Moyer Kevin M · Ulysses, KSBuilt 1976 · S/N 18-7609134N83437437 Adventures LLC · Anchorage, AKBuilt 1976 · S/N 18-7609135N83442Debevec David J · Tower, MNBuilt 1976 · S/N 18-7609137N83443Lorring David W · Fairbanks, AKBuilt 1978 · S/N 18-7909042N83447Chandler Air Service Inc · Chandler, AZBuilt 1976 · S/N 18-7609138N83449Registered aircraftBuilt 1978 · S/N 18-7909046N83452Wogernese Mark D · Phoenix, AZBuilt 1976 · S/N 18-7609139N83454M Mercer Livestock Transportation LLC · Hyattville, WYBuilt 1976 · S/N 18-7609140N83455Thornton William S · Seadrift, TXBuilt 1976 · S/N 18-7609141N83458Sheeley Ranch · Parkman, WYBuilt 1976 · S/N 18-7601942N83464Dupuis Wilson Ross · Brenham, TXBuilt 1976 · S/N 18-7609144N83472Moreau Leo B · Wasilla, AKS/N 18-7609146N83473Mccarthy Robert F · Purchase, NYBuilt 1976 · S/N 18-7609145N83476Mcmillan Gary · Frankston, TXBuilt 1976 · S/N 18-7609147N83477Reiss Kenneth G · Portville, NYS/N 18-7609148N83480Kloker Daniel E · Owasso, OKBuilt 1976 · S/N 18-7609150N83494Knutson Wayne R · Tioga, NDBuilt 1976 · S/N 18-7609153N83497Popov Chris · Hope, IDBuilt 1976 · S/N 18-7609157N83501J T Howell & Son LLC · Jackson, LAS/N 18-7709046N83508Registration Pending · Homer, AKRegistration pendingS/N 18-7709054N83510Dau Jim · Kotzebue, AKS/N 18-7709059
Back to AD 99-01-05 R1