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.

N4489HCharles Peter Colomello · Tillson, NYBuilt 1948 · S/N 15-278N4489ZHernandez Michael J · Sterling, AKS/N 18-8845N4490ASmith Jeffrey Steven · Fenton, MIBuilt 1956 · S/N 18-4856N4490HCragg Noel J · Millbrae, CABuilt 1948 · S/N 15-279N4490YMinnesota Soaring Club Inc · Stanton, MNBuilt 1966 · S/N 25-4154N4491ANatwick Joel L · Port Alsworth, AKFirst renewal noticeS/N 18-4860N4491HStevens Aviation And Parts LLC · Norfolk, VABuilt 1948 · S/N 15-281N4492AMerkes Dennis R · Soldotna, AKBuilt 1956 · S/N 18-4861N4492HBryant Stephen · Anchorage, AKS/N 15-280N4493ZGates Mary Jill · Anchorage, AKFirst renewal noticeBuilt 1969 · S/N 18-8847N4494HHayton James B · Sedro Woolley, WAFirst renewal noticeBuilt 1948 · S/N 15-283N4494YBegrow Adroaldo D · Gulf Shores, ALBuilt 1966 · S/N 25-4161N4494ZKasemodel Alan D · Billings, MTBuilt 1969 · S/N 18-8848N4495DHaszard John R · Ophelia, VAS/N 11-506N4495YMerlin Soaring Association Inc · Amelia Court House, VABuilt 1966 · S/N 25-4162N4495ZDolfi Rick · Sutton, AKBuilt 1969 · S/N 18-8850N4496YHill Kenneth G · Pocatello, IDBuilt 1966 · S/N 25-4166N4496ZBarnes Rodney L · Mayville, WIBuilt 1969 · S/N 18-8851N4497AMorris Duane E · Wasilla, AKBuilt 1956 · S/N 18-4869N4499HMoore Jeffrey D · Cleveland, NYBuilt 1948 · S/N 15-290N449WFGlenns Super Cub LLC · Fort Lauderdale, FLS/N 18-7773N44EBray Nick R Trustee · China Spring, TXBuilt 1947 · S/N 12-2575N44PMPhipps Johnny · Salem, ORBuilt 1952 · S/N 22-726N44PPKnr Inc · Evanston, WYBuilt 1955 · S/N 22-2576N44RTWinkelman Dan · Bethel, AKBuilt 1971 · S/N 18-8927N44TCKinzie Hon K · Anchorage, AKBuilt 2002 · S/N 9941CCN44WMBloomfield Robert C · Anchorage, AKBuilt 1974 · S/N 18-7409095N44YYYankee LLC · Kasilof, AKBuilt 1979 · S/N 18-7909069N4500WMagalsky Jacob J · Wilsall, MTBuilt 1980 · S/N 18-8009019N4500ZBielefeld James L · Kenai, AKBuilt 1960 · S/N 22-8000N45016Weber Jeffrey W · Marlton, NJBuilt 1941 · S/N 7467N4502MPletcher Marvin D · Yuma, COBuilt 1947 · S/N 11-6N4502TSprague-Hilsen Julia · Kent, WAS/N 18-2113N4502ZBoyer Bruce A · Toledo, OHBuilt 1960 · S/N 22-8002N4503YSteppler Dean M · Culbertson, MTBuilt 1971 · S/N 18-8923N4503ZDoran Daniel E · Lake In The Hills, ILS/N 22-8003N4504MMiller John M · Newburgh, MEBuilt 1947 · S/N 11-7N4504YCronin Monty A · Gettysburg, SDBuilt 1971 · S/N 18-8924N4505ASteadman Norman W · Arlington, TXBuilt 1956 · S/N 22-3810N4505MHayden Joseph C · New York Mills, MNBuilt 1947 · S/N 11-19N4505YGeneral Air Service LLC · Van Wert, OHBuilt 1971 · S/N 18-8925N4506APennsylvania College Of Technology · Williamsport, PAS/N 22-3811N4507MToft Patricia A Personal Representative · Myakka City, FLBuilt 1947 · S/N 11-11N4508ABonogofsky Thomas L · Bridger, MTBuilt 1956 · S/N 22-3813N4508MJanis Paul H · Anchorage, AKS/N 11-12N4509MNewburg Dale E · Rhome, TXS/N 11-13N4509YWolfrum John A · Two Rivers, AKBuilt 1971 · S/N 18-8930N4509ZLawrence Bobby L · Willis, TXBuilt 1960 · S/N 22-8011N450PMStroede Scott E · King Salmon, AKBuilt 1958 · S/N 22-6206N4510AGarvey James R · Fairhope, PABuilt 1956 · S/N 22-3815
Back to AD 99-01-05 R1