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.

N4341ZMeans Loren Alonzo III · Wasilla, AKBuilt 1968 · S/N 18-8659N4342MStout Lloyd J · Belmont, CABuilt 1947 · S/N 12-3280N4342ZCook Raymond L · Spring Grove, ILBuilt 1968 · S/N 18-8660N4343ZHood River County Sheriff'S Office · Hood River, ORBuilt 1968 · S/N 18-8661N4344AMccarthy James L · Anchorage, AKBuilt 1956 · S/N 22-3700N4344HOstrowski Frederick J · Otsego, MNBuilt 1948 · S/N 15-129N4344ZLindley Douglas R · Nantucket, MABuilt 1968 · S/N 18-8662N4345DKrischik Travis · La Pine, ORS/N 12-3300N4345HChampaign Sharon · New Holstein, WIBuilt 1948 · S/N 15-130N4345MTice Robert M · Millinocket, MEBuilt 1947 · S/N 12-3283N4345ZSimonson Daniel J · Loring, MTS/N 18-8663N4346ADeakyne Carl · Rehoboth Beach, DEBuilt 1956 · S/N 22-3702N4348ZWilliams Reid G · Cantwell, AKBuilt 1968 · S/N 18-8645N4349HEsparza George · Loves Park, ILBuilt 1948 · S/N 15-134N4349MRupiper Nicholas J · Ankeny, IABuilt 1949 · S/N 12-3287N434ABMondkar Avinash M · Payson, AZBuilt 1940 · S/N 5-373N4350ZBenning Gary R · Blue Grass, IABuilt 1968 · S/N 18-8667N4352ABrito Angelo M · Dillingham, AKS/N 22-3708N4353AVinson David L · Mc Alpin, FLBuilt 1956 · S/N 22-3709N4353HMoore Jeffrey D · Blossvale, NYBuilt 1948 · S/N 15-138N4354HLind Ronald C · Rainier, WABuilt 1948 · S/N 15-139N4355ABurrows Aviation LLC · Deer Park, WABuilt 1956 · S/N 22-3711N4355HPiper Aviation Museum Foundation · Lock Haven, PABuilt 1948 · S/N 15-140N4355MWasden Jackson L · Anchorage, AKBuilt 1947 · S/N 12-3293N4355ZBurwell Jeffery S · Wasilla, AKS/N 18-8673N4356MWalton Alfred V Jr · Shattuck, OKBuilt 1947 · S/N 12-3294N4358ACarruthers Steven L · Livingston, TNBuilt 1956 · S/N 22-3714N4359ZBritton Kelly D · Buffalo, SDBuilt 1968 · S/N 18-8677N4360ZPetersen Jacob R · Wasilla, AKS/N 18-8679N4361ARust Todd S · Anchorage, AKBuilt 1956 · S/N 18-4820N4361DVan Wagner Aerial Media LLC · Hollywood, FLS/N 18-2325N4361MCape May Aerial Advertising LLC · Cape May Ch, NJBuilt 1947 · S/N 12-3298N4361ZBennett Scott M · Ninilchik, AKBuilt 1968 · S/N 18-8680N4362YBarrett Jane T · Tehachapi, CABuilt 1969 · S/N 25-4868N4362ZCooper Scott J · Fellows, CABuilt 1968 · S/N 18-8681N4363ASchulz Florian · Anchorage, AKBuilt 1956 · S/N 22-3715N4363ZOcean Aerial Ads Inc · Berlin, MDBuilt 1968 · S/N 18-8682N4364APapp Frank J · Fort Mohave, AZS/N 22-3716N4364HBudde Gregory L · Morgan Hill, CABuilt 1948 · S/N 15-149N4364MChildress Michael C · Akron, OHBuilt 1947 · S/N 12-3302N4364PMeehan Patrick K · Anchorage, AKBuilt 1960 · S/N 18-7444N4365HDiamond B Farms Trucking Inc · Gamaliel, KYBuilt 1948 · S/N 15-150N4365MMartin Nathaniel W · Wasilla, AKBuilt 1947 · S/N 12-3303N4366HShank Paul L · Gaithersburg, MDBuilt 1948 · S/N 15-151N4366MCline Robert A · Clarkston, WABuilt 1947 · S/N 12-3312N4367HJakowiw Nicholas · Clifton Park, NYBuilt 1948 · S/N 15-152N4369AWinston William A · Bremo Bluff, VABuilt 1956 · S/N 22-3722N4369HMaynard Marc L · Dartmouth, MAS/N 15-154N436PDDibartolo Michael · Wasilla, AKBuilt 1955 · S/N 18-4238N4370AMacdonald Kenneth A · Willow, AKBuilt 1956 · S/N 18-4772
Back to AD 99-01-05 R1