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.

N8411DElliott Frank F · Mojave, CABuilt 1957 · S/N 22-5664N8413YReinbold Frederick K · Anchorage, AKBuilt 1969 · S/N 18-8858N8415YSchwend Brian · Forsyth, MTBuilt 1969 · S/N 18-8859N8417YHighhouse Alan J · Honesdale, PABuilt 1970 · S/N 18-8861N8418DWright Cecil A · Sanford, FLS/N 22-5668N841ACooper Jerry A · Kennewick, WABuilt 1951 · S/N 22-141N8420DAlsworth Glen R Sr · Port Alsworth, AKBuilt 1958 · S/N 22-5675N8420YVanwarmerdam Leslie C · Nampa, IDS/N 18-8862N8421DPutman Bruce C · Leonard, MIBuilt 1957 · S/N 22-5676N8423DKearney Rick G · Amity, PABuilt 1957 · S/N 22-5678N8427DEastin Toby M · Jefferson City, MOS/N 22-5682N8428DMullen Samuel J · Fairbanks, AKBuilt 1957 · S/N 22-5683N8429DDickson Wayne K · Luthersville, GABuilt 1957 · S/N 22-5684N8430DBottorff Marshall B · Kimberling City, MOBuilt 1957 · S/N 22-5685N8434DAllen Clifford R · Indianapolis, INBuilt 1957 · S/N 22-5689N8437DClark Donald S · Atlantic Beach, FLBuilt 1957 · S/N 22-5692N8438YJohnson Aaron D · Colfax, WABuilt 1969 · S/N 18-8864N8439YTracy Bill E · Leoti, KSBuilt 1970 · S/N 18-8866N8440DAkn Inc · Crystal, MNBuilt 1957 · S/N 22-5695N8442DFlymart Inc · Hastings, FLS/N 22-5697N8445DRowell Joe William · Indian Trail, NCBuilt 1957 · S/N 22-5700N8446DMcmaster James R II · Bath, PABuilt 1957 · S/N 22-5701N8448DManary David G · North Platte, NEBuilt 1957 · S/N 22-5704N8452DAndersen Geir · Bellingham, WABuilt 1957 · S/N 22-5708N8453DYork Timothy Mitchell · Beresford, SDS/N 22-5709N8457DMorrison James · Grandview, TXBuilt 1957 · S/N 22-5713N8459DMcconnell Mark S · Paxton, NEBuilt 1957 · S/N 22-5716N8461DSilver Wings Flying Company LLC · Olympia, WABuilt 1957 · S/N 18-6160N8462DBarrett William G · Portland, ORBuilt 1957 · S/N 18-6161N8463DQuist Scott D · Wasilla, AKBuilt 1957 · S/N 18-6162N8464DRegistered aircraftBuilt 1957 · S/N 18-6163N8464YTurner Terrance A · Anchorage, AKS/N 18-8870N8467DAlexander Sam · Fair Play, MOBuilt 1957 · S/N 18-6167N8468DBliss James B · Anchorage, AKBuilt 1962 · S/N 18-6168N8469DPeppel Tom · Big Lake, AKBuilt 1957 · S/N 18-6169N8470DRogers Bryan K · Anchorage, AKBuilt 1957 · S/N 18-6173N8472DKennedy Jared W · Cordova, AKBuilt 1957 · S/N 18-6177N8473DDillon Edward L · Anchorage, AKBuilt 1957 · S/N 18-6178N8476JBlue Streak Aire LLC · Sandpoint, IDBuilt 1949 · S/N 14-204N8476YStenga James E · Soldotna, AKBuilt 1970 · S/N 18-8873N8479YHanks Kay · Eagle River, AKBuilt 1970 · S/N 18-8876N847WAMcpherson Duane Eugene · Spearfish, SDBuilt 1947 · S/N 12-3214N8480DHahn David D · Port Lavaca, TXBuilt 1957 · S/N 18-6193N8480YSchlick David L · Poulsbo, WAS/N 18-5483N8481DShoreline Consulting Inc · Bryan, TXBuilt 1958 · S/N 18-6194N8482YCalvert John A · Pikeville, TNS/N 18-8878N8485DMacdonald Kenneth A · Willow, AKBuilt 1957 · S/N 18-6203N8489DStrub Henry J · Dillingham, AKBuilt 1957 · S/N 18-6210N8490YGolden Eagle Outfitters Inc · Delta Junction, AKS/N 18-8879N8491DDirty Side Down LLC · Downers Grove, ILBuilt 1957 · S/N 22-5718
Back to AD 99-01-05 R1