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.

N6724LStern Margaret A · Talkeetna, AKBuilt 1974 · S/N 18-7409115N6724ZGray Ronald W · Hooker, OKBuilt 1963 · S/N 25-2339N6725BCallen Jeremy T · Filer, IDBuilt 1956 · S/N 22-4058N6726BNickel Henry William · San Bernardino, CABuilt 1956 · S/N 22-4059N6727AWolf Cub Aviation LLC · Wasilla, AKBuilt 1981 · S/N 18-8109031N6727ZMyers Randall · Parshall, NDBuilt 1963 · S/N 25-2343N672SSCalta Joseph P · Acton, CAS/N 11-890N6734LSky Sailing Inc · Warner Springs, CABuilt 1974 · S/N 18-7409116N6735BBallard Donald · Conneaut, OHS/N 22-4068N6735LPaynes Landing LLC · Inlet, NYS/N 18-7509131N6738CStillwater Aviation LLC · Winter Haven, FLS/N 182134N6739BDeal Stuart F · Santa Rosa, CABuilt 1956 · S/N 22-4072N6740LAslesen Leasin LLC · Halstad, MNBuilt 1974 · S/N 18-7409119N6741BPoehler Fred G · Newberg, ORBuilt 1956 · S/N 22-4074N6741LMountain Aviation Corp · Mccall, IDBuilt 1974 · S/N 18-7409121N6745ZSouthern California Soaring Academy · Valencia, CABuilt 1963 · S/N 25-2360N6749BFinke Andy R · North Liberty, INS/N 22-4083N6749ZKnutson Wayne R · Tioga, NDBuilt 1963 · S/N 25-2368N6751BCook Harry F · Sequim, WABuilt 1956 · S/N 22-4085N6753BThorpe Brandon · Bremerton, WABuilt 1956 · S/N 22-4087N6755BTwotards Aviation LLC · Moses Lake, WABuilt 1956 · S/N 22-4089N6756ZKoenig Donald J · Las Animas, COBuilt 1963 · S/N 25-2376N6757BStuart Lee L · Smithville, ARBuilt 1956 · S/N 22-4091N6759BDean Richard L · Ridgeland, SCBuilt 1956 · S/N 22-4094N6760BAnderson Michael N · Anchorage, AKBuilt 1954 · S/N 18-5035N6762BCarver Clarence K Trustee · Lutz, FLBuilt 1956 · S/N 18-5037N6764BMccollum Glen R Jr · Nikiski, AKBuilt 1956 · S/N 18-5039N6766BRutland Norman L Jr · Birmingham, ALBuilt 1956 · S/N 18-5041N6767BHolseberg Aviation LLC · Ridgeville, SCBuilt 1956 · S/N 18-5042N6768BKimmel Frank Stewart III · Greenwood, MSBuilt 1957 · S/N 18-5046N6774BLegacy Aviation And Sales LLC · Ririe, IDBuilt 1956 · S/N 18-5007N6775BOcean Aerial Ads Inc · Berlin, MDBuilt 1956 · S/N 18-5008N6777BJim Franklin Aviation Service Inc · Ruidoso, NMBuilt 1956 · S/N 18-5011N6778TAlexander Todd A · Milton Freewater, ORBuilt 1946 · S/N 12-1104N6780BTyler Marvin L · Carthage, NYS/N 18-5014N6782ZWillamette Valley Soaring Club · Beaverton, ORBuilt 1963 · S/N 25-2418N6783BBlue Sky Aviation Inc · Peyton, COS/N 18-5017N6789BCartee Terry Allen Trustee · Anchorage, AKBuilt 1956 · S/N 18-5023N678WSInfinity Aviation LLC · Piedmont, SDBuilt 1946 · S/N 12-233N6791BHassell Dan J · Ketchikan, AKBuilt 1956 · S/N 18-5025N6791ZAir Care Inc · Lamar, COBuilt 1963 · S/N 25-2435N6792BPeterson Joel · Fargo, NDBuilt 1956 · S/N 18-5026N6792ZMid Continent Aircraft Corp · Hayti, MOBuilt 1963 · S/N 25-2436N6793ZJnc Aviation LLC · Saint Louis, MOBuilt 1963 · S/N 25-2438N6794ZKnutson Wayne R · Tioga, NDBuilt 1963 · S/N 25-2439N679AFord Darryl E · Aurora, COBuilt 1951 · S/N 22-81N679RKRwr Air Inc · Tok, AKBuilt 1956 · S/N 18-5024N67CJEngineered Cub Components Inc · Chugiak, AKBuilt 2003 · S/N AF18090CJN67FNNoska Frank S IV · Wasilla, AKBuilt 1966 · S/N 18-8481N67MVBuron A Michael · North Pole, AKBuilt 1975 · S/N BR9000
Back to AD 99-01-05 R1