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.

N4836ASales Joe Haney · Seminole, TXS/N 22-3989N4836ZDewolfe III Everett C · Cumby, TXBuilt 1961 · S/N 22-8410N4838HAir Cowboy LLC · Roca, NES/N 17-143N4838YWagner Nathan D · Dane, WIBuilt 1968 · S/N 25-4634N4839MStocker James M · Palmer, AKBuilt 1947 · S/N 11-350N4839WPiscoya Thomas G · Anchorage, AKBuilt 1989 · S/N 1809012N4839ZMacias-Flores Guadalupe · Garden City, KSBuilt 1961 · S/N 22-8413N4840YDmc Aircraft LLC · Naples, FLBuilt 1968 · S/N 25-4637N4841APiercy Ronald S · Moses Lake, WAS/N 22-3994N4841YBlack Forest Soaring Society · Monument, COS/N 25-4639N4842AHill Steven Douglas · Stoneville, NCBuilt 1956 · S/N 22-3995N4842HPhillabaum Stephen D · Deer Park, WABuilt 1948 · S/N 17-139N4842MOleary Aviation Inc · Sibley, IABuilt 1947 · S/N 11-354N4843ANous Air LLC · Yukon, OKBuilt 1956 · S/N 22-3996N4843MSnyder Edward A · Hubbard, OHBuilt 1947 · S/N 11-359N4844MGaier Jeffrey H · Neillsville, WIBuilt 1947 · S/N 11-361N4844ZRegistered aircraftBuilt 1961 · S/N 22-8418N4845AParenteau William · Maple Grove, MNBuilt 1910 · S/N 22-3998N4845HVon Bernewitz David Alfred · Myersville, MDFirst renewal noticeBuilt 1948 · S/N 17-144N4846HSmith Cody S · Spring City, PABuilt 1948 · S/N 17-145N4846MChristensen Robert P · Ashton, IDS/N 11-376N4849AVeblen Raak · Auburn, CABuilt 1956 · S/N 22-4002N4849MHoyt Larry M · Clio, MIBuilt 1947 · S/N 11-365N4849ZSwope William T · Georgetown, OHS/N 22-8424N4850MLeishman Randy R · Albin, WYBuilt 1947 · S/N 11-366N4851HBaumgartner Thomas A · La Crosse, WIBuilt 1948 · S/N 17-151N4851ZNorris Randal E · Cambridge, KSBuilt 1961 · S/N 22-8426N4852AHanrahan Andrew D · Soldotna, AKBuilt 1956 · S/N 22-4005N4852HBerry Russell E · West Milton, OHS/N 17-152N4853HHubbard David R · Dexter, MIBuilt 1948 · S/N 15-385N4853MDoore Freeman · Barnard Twp, MEBuilt 1947 · S/N 11-369N4853ZPileggi James B · Berkeley, CABuilt 1961 · S/N 22-8428N4854HWright Cecil · Sanford, FLBuilt 1948 · S/N 17-153N4854MHall James D · Kenai, AKBuilt 1947 · S/N 11-371N4855HKasuske Gerald A · Watertown, SDBuilt 1948 · S/N 17-154N4855MCrawford Michael R · Gainesville, GABuilt 1947 · S/N 11-372N4856AManning Travis J · Reno, NVBuilt 1956 · S/N 22-4012N4856MWheeler George H · Montgomery, TXBuilt 1947 · S/N 11-373N4856YAgland Air Inc · Beaver Dam, WIBuilt 1968 · S/N 25-4657N4856ZWason Luther M III · Raymond, NHBuilt 1961 · S/N 22-8431N4857ARegistered aircraftN-number assigned, not yet registeredS/N 22-4013N4857HEvans Gary S · Independence, ORBuilt 1948 · S/N 17-157N4857ZFrancis Harvey B · Key West, FLS/N 22-8433N4859ADory Lakota L · Caldwell, IDS/N 22-4015N4859ZPinter John M · Grand Ledge, MIFirst renewal noticeBuilt 1961 · S/N 22-8435N4860AWolff Paul J · Baraboo, WIBuilt 1956 · S/N 22-4019N4860YAerial Banners Inc · Pembroke Pines, FLBuilt 1968 · S/N 25-4662N4860ZSewell Dennis L · Clay Center, KSBuilt 1961 · S/N 22-8436N4861ARubbert Randy C · Reynolds, NDBuilt 1956 · S/N 22-4020N4862ASmith James A · Lyle, WABuilt 1951 · S/N 22-279
Back to AD 99-01-05 R1