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.

N4040HDevil Dusters Inc · Artesia, NMBuilt 1947 · S/N 12-3467N4040ZAcme Cub Training Inc · Anchorage, AKBuilt 1963 · S/N 18-8001N4041EBurns Charles R · Huntsville, ALS/N 18-7809048N4041MSessions John L · Kirbyville, TXBuilt 1947 · S/N 12-2924N4043EL C Hanson Co · Helena, MTBuilt 1977 · S/N 18-7809049N4043HWeggel Roger F · Fairbanks, AKS/N 12-3470N4044GFlyrs Field · Anchorage, AKS/N 18-5614N4044MRed Baron LLC · Kenai, AKBuilt 1947 · S/N 12-2927N4044ZHainline David O · Poway, CABuilt 1962 · S/N 18-8005N4045MSchad Paul E · Gainesville, TXBuilt 1947 · S/N 12-2928N4045ZEastman Gregory L · Pueblo, COBuilt 1963 · S/N 18-8007N40463Sportsmans Air Service Inc · Anchorage, AKBuilt 1975 · S/N 18-7509120N4046ZSprik Robert Jay · Hamilton, MIBuilt 1963 · S/N 18-8009N4047ERegistration Pending · Somers, MTRegistration pendingBuilt 1977 · S/N 18-7809046N4047ZGrunwaldt Peter J · Anchorage, AKBuilt 1963 · S/N 18-8011N4050ZMaya Aviation LLC · Lee, NHBuilt 1964 · S/N 18-8052N40520Goodman Larry D Trustee · Prineville, ORBuilt 1975 · S/N 18-7509121N40523Gossett Owen L · Central Point, ORBuilt 1975 · S/N 18-7509123N4052VBorror Eric F · Gerber, CABuilt 1956 · S/N 18-5218N4052ZMetro Service Air · Fairbanks, AKBuilt 1963 · S/N 18-8054N4053ZSpohnholz Randy K · Anchorage, AKBuilt 1963 · S/N 18-8056N40549Agnew Mark W · Wasilla, AKBuilt 1969 · S/N 18-8865N4054ZBiggs Craig P · Preston, IDBuilt 1963 · S/N 18-8059N40552Peeler Jason B · Flooresville, TXS/N 18-7509126N40558Hill Casey J · Anchorage, AKBuilt 1975 · S/N 18-7509127N4055ZMartin Lawrence M · Clam Gulch, AKS/N 18-8060N4056ZG & L Airborne Inc · Wilmington, DEBuilt 1963 · S/N 18-8064N40575Evans Samuel F · Iuka, MSBuilt 1976 · S/N 18-7709018N40579Burwell Jeffery S · Wasilla, AKBuilt 1976 · S/N 18-7509129N4057MUsac Airways 693 LLC DBA · Fort Lauderdale, FLBuilt 1947 · S/N 12-2940N4057ZBruegger Shannon B · Lance Creek, WYBuilt 1963 · S/N 18-8066N405THNewgren Steven A · Kasilof, AKBuilt 1975 · S/N 18-7509005N4060MStall Aero LLC · Burnsville, MNBuilt 1947 · S/N 12-2943N40618Hoffman Barry L · Central Point, ORBuilt 1941 · S/N 7374N4061MKrupinski Floyd M · Chugiak, AKBuilt 1947 · S/N 12-2950N4061ZJones Michael D · Eagle River, AKBuilt 1963 · S/N 18-8071N4062EReimler Dan T · Rozet, WYBuilt 1978 · S/N 18-7809047N40632Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1941 · S/N 7391N4063ZDenton Bobby L · Las Animas, COFirst renewal noticeS/N 18-8073N40642Douglass Scott H · Reno, NVBuilt 1941 · S/N 7402N40658Goodnight James J · Kannapolis, NCBuilt 1941 · S/N 7417N4065EKubat Wayne DBA · Wasilla, AKBuilt 1978 · S/N 18-7809052N40663Moss Frank V · Punta Gorda, FLS/N 7418N4066ENelson Flyers Inc · Louise, TXBuilt 1977 · S/N 18-7809057N40673Simons Corey E · Roy, WABuilt 1941 · S/N 7433N40678Saville David · North Royalton, OHBuilt 1941 · S/N 5-1116N4067ZBenninger Timothy A · Cobleskill, NYBuilt 1963 · S/N 18-8078N40683Helseth Keith A · Kirksville, MOBuilt 1941 · S/N 51113N40685Pierce James C · Tallahassee, FLBuilt 1941 · S/N 51117N4068AAvg Services Inc · Wilmington, DEBuilt 1958 · S/N 18-2121
Back to AD 99-01-05 R1