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.

N38262Hansen Daniel A · Kotzebue, AKBuilt 1941 · S/N 6887N38266Dewitt Kevin E · Ostrander, OHBuilt 1941 · S/N 6891N3826MBaugh Caleb · Carthage, MOBuilt 1947 · S/N 12-2568N3826PBauries Brian W · Abilene, TXBuilt 1955 · S/N 22-3516N3826ZWebster William S · Eden, WYBuilt 1961 · S/N 18-7569N38270Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1941 · S/N 6896N3828PPupator Peter Trienko · Willow, AKBuilt 1955 · S/N 22-3518N3828ZOrvin Sanden Inc · Wyndmere, NDBuilt 1960 · S/N 18-7571N38297Parra Macarena · Taylorsville, CAS/N 5-936N382CCVeenstra Timothy S · Wasilla, AKS/N 9946CCN382NZPerry Kathryn C · Sultan, WAS/N 18-2078N3830PHeckerman Ted A · Canyon Lake, TXBuilt 1955 · S/N 22-3520N38318Booth Daniel S · Davenport, IABuilt 1941 · S/N 6928N3831PPerkins Jason T · Hudson, MEBuilt 1955 · S/N 22-3521N3831ZFloats N Hoes LLC · Umatilla, FLBuilt 1961 · S/N 18-7574N38326Wehrman Michael E · Billings, MTBuilt 1941 · S/N 6933N3832ZHoward Gary O · Eagle, AKBuilt 1961 · S/N 18-7575N38335L-Bird LLC · Hood River, ORBuilt 1941 · S/N 6941N3833MMiranda Michael R · Enterprise, ALBuilt 1947 · S/N 12-2750N3833ZDominguez Carlos L · Gainesville, GABuilt 1961 · S/N 18-7576N38345May Richard S · Sumter, SCS/N 6953N38346High Country Cub LLC · Lakewood, COBuilt 1941 · S/N 6954N3834MChristoph Mark H · Omak, WABuilt 1947 · S/N 12-2751N3835MLentfer Sheryl A · Anchorage, AKBuilt 1947 · S/N 12-2752N38362Buerk Christian E · West Ossipee, NHBuilt 1940 · S/N 4857N38369Ptacek Stephen R · Estes Park, COBuilt 1941 · S/N 6987N3836ZTroutman Charles W · Lincoln City, ORBuilt 1960 · S/N 18-7588N38372Parmoon Joseph A · Albuquerque, NMBuilt 1941 · S/N 6982N3837PPlancich Don A · Sterling, AKS/N 14-154N3837ZTroutman Charles Wayne · Lincoln City, ORBuilt 1960 · S/N 18-7589N3838MAhumada George Ramon · Palmer, AKS/N 12-2759N3838PArlins Aircraft Service Inc · Belgrade, MTBuilt 1955 · S/N 22-3528N3838ZWoldow Fredric A · Morton, ILBuilt 1960 · S/N 18-7592N38395Buyak David W · New Hartford, CTBuilt 1941 · S/N 5945N38399Registered aircraftBuilt 1941 · S/N 5949N3839PMorris Equipment LLC · Yuma, AZBuilt 1955 · S/N 22-3529N3839ZPrax Philip G · Fairbanks, AKFirst renewal noticeBuilt 1961 · S/N 18-7593N383CCWiplinger Charles · Inver Grove, MNBuilt 2001 · S/N 9938CCN38402Horst Aviation LLC · New Holland, PABuilt 1941 · S/N 5-952N38405Stavolone Daniel P · Maynard, MABuilt 1941 · S/N 5-956N38408Pearson Luke D · Anchorage, AKBuilt 1941 · S/N 5-959N3840MMillman Troy J · Oshkosh, WIBuilt 1947 · S/N 12-2761N3840PPiper Aviation Museum Foundation · Lock Haven, PABuilt 1955 · S/N 22-3530N3840ZWorley Donald E Jr · Rocky Mount, VAS/N 18-7594N38415Kibler John A · Mt Airy, MDBuilt 1941 · S/N 5966N38418Caldwell Gregg P · Desert Hot Springs, CAS/N 5-968N3841ZOcean Aerial Ads Inc · Ocean City, MDBuilt 1961 · S/N 18-7595N38420Cowie Leland K · Jonesburg, MOBuilt 1941 · S/N 5-970N38422Cline David R · Maryville, TNBuilt 1941 · S/N 5-972N38425Schirmer Brandon · Batesville, TXBuilt 1941 · S/N 5976
Back to AD 99-01-05 R1