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.

N2681CBlack Deberah L Trustee · Las Vegas, NVBuilt 1963 · S/N 18-8004N2681MHebrink Jason R · Grand Rapids, MNBuilt 1946 · S/N 12-1112N2681PFlitner Colten · Greybull, WYBuilt 1955 · S/N 18-4368N2682MDavis Philip L · Spring Hill, TNBuilt 1946 · S/N 12-1113N2683ALovett Andre D · Anchorage, AKBuilt 1953 · S/N 18-2189N2683MBeach Banners Inc · Jacksonville, FLBuilt 1946 · S/N 12-1114N26841Flying A Aviation LLC · Archer City, TXBuilt 1940 · S/N 4210N26846Pollard Jim · Montrose, MIBuilt 1939 · S/N 4224N2684AMckinley I Blake Jr · Spokane Valley, WABuilt 1952 · S/N 18-2190N2684MGrangruth Rory A · Wadena, MNBuilt 1954 · S/N 12-997N26856Reed David A Trustee · Pinedale, WYBuilt 1940 · S/N 4221N26858Ferreira James M · Dixon, CAS/N 4225N2686AJohnson James L · Greenville, TXBuilt 1953 · S/N 22-1099N2686MCummings Scott Alan · Monitor, WABuilt 1946 · S/N 12-999N26876Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 5-3N2687MWilkes Gary W · Lakeland, FLBuilt 1946 · S/N 12-1117N2688ALanham Rex E · Boise, IDBuilt 1953 · S/N 18-2194N26890Ulmer Bryce · Locust Grove, GABuilt 1940 · S/N 4944N2689AWomack W A · Jackson, LABuilt 1953 · S/N 18-2195N2689MKuehni Steven A · Stanley, WIBuilt 1946 · S/N 12-1200N268TCline David R · Maryville, TNBuilt 1953 · S/N 18-2382N26912Rockdale Flying Tigers Inc · Rockdale, TXBuilt 1940 · S/N 4-978N26914Dent William M · Winston Salem, NCBuilt 1940 · S/N 4-939N2691MHartmaier Robert S Jr · Monroe Township, NJBuilt 1946 · S/N 12-1121N26920Deuce Coupe Aviation LLC · Columbia City, INBuilt 1940 · S/N 4-962N2692MOnstott Norman V · Mount Pleasant, MIBuilt 1946 · S/N 12-1122N26940Epley Kennith W · Ladonia, TXBuilt 1940 · S/N 4-966N26946Kramer Peter W · Copper Center, AKBuilt 1940 · S/N 5-16N2694MSwartz William L · Cumb Foreside, MEBuilt 1946 · S/N 12-1206N2694PEllis Wendell K · Chugiak, AKS/N 18-4382N26953Tribley Brooke E · Magnolia, TXBuilt 1940 · S/N 5-9N2695PDodge Alan J · Miles City, MTBuilt 1955 · S/N 18-4384N26987Dornseif Daniel K · Oviedo, FLBuilt 1940 · S/N 5-15N2698PMajors Nathaniel Ray · Ball, LAS/N 18-4388N26995Mckay Franklin D · Rockport, TXBuilt 1940 · S/N 4-986N2699MJohnson George W · Seattle, WAS/N 12-1203N269TCleveland Frank W · Quinhagak, AKBuilt 1953 · S/N 18-2383N269WMRenninger Log Homes · Meeker, COBuilt 1959 · S/N 18-6874N26AKLousberg Daniel A · Wasilla, AKBuilt 1974 · S/N 18-7409079N26GBLunt Christopher J · Marco Island, FLBuilt 1982 · S/N 18-8209004N26QQHauser Family Flying LLC · Mount Pleasant, PABuilt 1946 · S/N 12-605N26VCAlbertson James M · Westville, FLS/N 18-2328N2701MBaltrum Daniel R · Ester, AKBuilt 1946 · S/N 12-1205N27024Machida Steven · Homer, AKBuilt 1940 · S/N 4332N27025Daphna Inc · Middletown, DEBuilt 1940 · S/N 4-997N270313 Point Aviation LLC · Saint Louis, MOBuilt 1940 · S/N 4-998N27036Pace William Todd · Palmer, AKS/N 18-3516N27049Lewis Joseph Burton · Walnut Cove, NCBuilt 1940 · S/N 4323N2704PBriggs Ralph H · Des Moines, IABuilt 1955 · S/N 22-3010N27051Geisler Mark C · Dallas, TXS/N 4-1002
Back to AD 99-01-05 R1