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.

N4462AWeishaar Wallace O · Livingston, TXBuilt 1956 · S/N 22-3795N4462HDutro Mark H · Chico, CABuilt 1948 · S/N 15-253N4463AGifford Anna E · Canadian, TXBuilt 1956 · S/N 22-3796N4463ZStewart William L · Willow, AKBuilt 1969 · S/N 18-8810N4464HGibson Chris F · De Pere, WIS/N 15-252N4464ZMcinelly Leon · Fairbanks, AKBuilt 1977 · S/N 18-7709089N4465ABrown Michael Ryan · Santa Maria, CABuilt 1956 · S/N 22-3798N4465HCanon Robert Glen · Waller, TXS/N 15-254N4465ZWood Randy L · Delta Junction, AKBuilt 1969 · S/N 18-8813N4467YKingsley Kiman J · Miller, MOBuilt 1966 · S/N 25-4119N4468HFreeland Christopher G · Brownwood, TXS/N 15-256N4468YBegrow Adroaldo Dorivaldo · Gulf Shores, ALBuilt 1966 · S/N 25-4120N4469AStacy Richard E · Westfield, NYBuilt 1956 · S/N 22-3802N4469HSlinger LLC · Randolph, WIBuilt 1948 · S/N 15-257N4470AAnderson Stephen A · Yuba City, CABuilt 1956 · S/N 18-4822N4470MDunlap Gary P · Seattle, WAS/N 12-3422N4470YAmundson Daryl A · Blue Earth, MNBuilt 1966 · S/N 25-4124N4470ZRegistration Pending · Weatherford, TXRegistration pendingBuilt 1969 · S/N 18-8819N4471ZEgolf Charles F · Spokane, WAS/N 18-8821N4472YSilent Flight LLC · Payette, IDBuilt 1966 · S/N 25-4128N4473HUhlenhopp Eldon K · Ames, IABuilt 1948 · S/N 15-261N4473YJackson Robert S · Gallatin, TNBuilt 1949 · S/N 16-375N4473ZEriksen Rodney B Trustee · Juneau, AKBuilt 1969 · S/N 18-8822N4474ZWatts Craig W · Incline Village, NVBuilt 1969 · S/N 18-8824N4475ZShepard Brothers LLC · Columbia, MSS/N 18-8825N4476HHutson Ac N · Griffin, GAS/N 15-265N4476ZS And C Flying LLC · Pierre, SDS/N 18-8827N4477ABrown Danny J · Skidmore, MOBuilt 1956 · S/N 18-4833N4477PAirknocker Inc · Wilmington, DEBuilt 1960 · S/N 25-253N4478AOrth Henry J · Wasilla, AKBuilt 1956 · S/N 18-4835N4479YKnutson Wayne R · Tioga, NDBuilt 1966 · S/N 25-4108N4479ZHardan Weston W · Palmer, AKBuilt 1969 · S/N 18-8834N4480HStatz Matthias Scott · Madison, WIBuilt 1948 · S/N 15-269N4480MBush Pilot Inc · Soldotna, AKBuilt 1947 · S/N 12-3431N4481HMurray Gregory T · Napa, CABuilt 1948 · S/N 15-270N4481ZTucker Jason M · Wasilla, AKBuilt 1969 · S/N 18-8816N4482EStaton Stephen D · Soldotna, AKBuilt 1981 · S/N 18-8109025N4482MPapon Bruce G · Hardtner, KSS/N 12-3435N4482YMiller Andy D · Marana, AZS/N 25-4140N4483MLorring David W · Fairbanks, AKBuilt 1947 · S/N 12-3436N4483ZWild Valley LLC · Wasilla, AKBuilt 1969 · S/N 18-8837N4484YMasterwings LLC · Princeton, KYBuilt 1966 · S/N 25-4144N4485ACrabb Philip E · Fairbanks, AKBuilt 1956 · S/N 18-4850N4485MSuper Cruiser LLC · Fort Wayne, INBuilt 1947 · S/N 12-3438N4486MRnc Air Service LLC · Bedford, WYBuilt 1947 · S/N 12-3439N4486YQuality Aviation Inc · Marana, AZBuilt 1966 · S/N 25-4147N4487HAnderson Noel · Sheffield, MABuilt 1948 · S/N 15-276N4487MBoyer James A · Lancaster, OHBuilt 1947 · S/N 12-3442N4487YWitthuhn Johnie B · Callaway, NEBuilt 1966 · S/N 25-4150N4488ZAlaska Tailwheel LLC · Fairbanks, AKBuilt 1969 · S/N 18-8843
Back to AD 99-01-05 R1