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.

N4315MArntson Le Delle E · Eagle River, AKBuilt 1947 · S/N 12-3248N4316AHvizdak George D · Colliers, WVBuilt 1956 · S/N 22-3668N4316HEvans William H Jr · Gardendale, TXBuilt 1951 · S/N 18-880N4316MDavis Ronald L Jr · Soldotna, AKBuilt 1947 · S/N 12-3249N4316ZGardner Richard T · Delta Junction, AKBuilt 1967 · S/N 18-8628N4317HBaumann Alexander · Two Rivers, WIS/N 15-100N4318HBradley Gary C · Orchard Park, NYBuilt 1948 · S/N 15-101N4319ZNorthland Hangars LLC · Palmer, AKBuilt 1967 · S/N 18-8632N4320AKnutson Daniel T · Lodi, WIS/N 22-3672N4320HBeaver Brandon D · Noblesville, INBuilt 1948 · S/N 15-102N4320MKoinzan Flying Service Inc · Elgin, NEBuilt 1947 · S/N 12-3256N4320ZSchermerhorn Lee V D III · Oak Harbor, WABuilt 1968 · S/N 18-8633N4321HCobb Douglas J · Fremont, OHS/N 15-103N4322MVeal Jeffrey S · Sterling, AKS/N 12-3257N4322ZLee Gerald R · Glennallen, AKBuilt 1968 · S/N 18-8636N4323ZDubious Adventures LLC · Big Lake, AKS/N 18-8638N4324HTrott James E · Cathlamet, WAS/N 185569N4324MMulligan William O · Valentine, NEBuilt 1947 · S/N 12-3259N4324ZBretts Spray Service Inc · Onida, SDFirst renewal noticeBuilt 1968 · S/N 18-8639N4326ZSuchland Simon K · North Pole, AKBuilt 1968 · S/N 18-8643N4327ACasten Scot R · Vernonia, ORBuilt 1956 · S/N 22-3682N4328AHubert Matthew J · Fremont Center, NYBuilt 1956 · S/N 22-3683N4328MMisch Gordon L · Toledo, WABuilt 1947 · S/N 12-3262N4328XWhitehair Donald N · Stevensville, MTBuilt 1946 · S/N 12144N4328ZWilmarth Rebecca C · Red Devil, AKBuilt 1968 · S/N 18-8646N4329ZWalters Leif C · Wasilla, AKBuilt 1968 · S/N 18-8644N432MEEdwards Michael S · Sacramento, CAS/N 18-7609131N4330HKoper James F · Decatur, TNBuilt 1948 · S/N 15-113N4330MCarson Brian P · Battle Creek, MIBuilt 1947 · S/N 12-3269N4330ZOcean Aerial Ads Inc · Ocean City, MDBuilt 1968 · S/N 18-8650N4331HPierce Gilbert H · Germantown, TNBuilt 1948 · S/N 15-118N4331YOdonnell Daniel V · Dover, DEBuilt 1968 · S/N 25-4821N4332AButterfield Robert S · Shelbyville, INBuilt 1956 · S/N 22-3687N4332HMcchesney Corey D · New Berlin, WIBuilt 1948 · S/N 15-122N4332ZSipes Harold T · North Pole, AKBuilt 1968 · S/N 18-8648N4333HHille Tracy D · Sandusky, OHS/N 15-116N4333MHodges June M · Wasilla, AKBuilt 1947 · S/N 12-3267N4333YEvergreen Soaring Inc · Lynnwood, WABuilt 1968 · S/N 25-4824N4334ANorrix James J · Elk River, MNBuilt 1956 · S/N 22-3689N4335YTexas Soaring Association Inc · Midlothian, TXS/N 25-4827N4335ZSigel Edward A · Laramie, WYBuilt 1968 · S/N 18-8653N4336APutney Bruce N · Midlothian, TXBuilt 1956 · S/N 22-3691N4337YJourneys Aviation Inc · Boulder, COBuilt 1968 · S/N 25-4830N4337ZBabcock Greg J · Wapato, WABuilt 1968 · S/N 18-8655N4338ZJwg Aviation LLC · Livingston, MTBuilt 1968 · S/N 18-8656N4339MLazor Ronald E · Middlefield, CTBuilt 1947 · S/N 12-3275N433PCRoush Russel A Trustee · Gillette, WYBuilt 1956 · S/N 18-4874N4340HEiden Ryan J · Central, AKS/N 15-125N4340MMiller William M · Brenham, TXBuilt 1947 · S/N 12-3276N4340ZBrown Helicopter Inc · Pensacola, FLBuilt 1968 · S/N 18-8658
Back to AD 99-01-05 R1