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.

N7906HCarter Sheradon Royce · Sumner, TXS/N 12-810N7914HJamrock Leasing LLC · Schenectady, NYBuilt 1946 · S/N 12-818N7915HHanna Bay Holdings LLC · Hayward, WIBuilt 1946 · S/N 12-819N7921HLloyd Chelsea M · Wasilla, AKS/N 12-823N7923HBarker Gerald E · Weymouth, MAS/N 12-829N7924HBourland Kenneth C · Waller, TXBuilt 1946 · S/N 12-830N7925HMedary Thomas A · Corpus Christi, TXBuilt 1946 · S/N 12-831N7929HBurt W Ackerman · Shakopee, MNS/N 12-826N7930HMorris Sidney H · Kenai, AKBuilt 1946 · S/N 12-834N7931HSale Reported · Palmer, AKSale reportedBuilt 1946 · S/N 12-839N7933HNeal Clarence W · Markham, TXBuilt 1946 · S/N 12-836N7941HLugten John B · Walnut Creek, CABuilt 1946 · S/N 12-845N7944HForsgren Kyle C · Wasilla, AKBuilt 1946 · S/N 12-847N7949Thermoking Of Fargo & Isuzu Diesel Midwest · Fargo, NDBuilt 1970 · S/N 18-8882N7949HButterfield Mike · Yakima, WAS/N 12-855N7954HSpidal Steven J Jr · Wasilla, AKBuilt 1946 · S/N 12-853N7955HHudson Tom J · Kasilof, AKBuilt 1946 · S/N 12-858N7958HHepler Joseph Gerald · Anchorage, AKBuilt 1946 · S/N 12-860N795AKFirn Line Aviation Inc · Wasilla, AKBuilt 1958 · S/N 18-6297N7961HCox James D Trustee · Maryville, MOBuilt 1946 · S/N 12-866N7964HParker Nathaniel C · Wasilla, AKS/N 12-869N7965HBedard Michael J Trustee · Madison, ALBuilt 1946 · S/N 12-870N7968HBlackie Christopher J · Old Town, MES/N 12-901N796ABDrake Aerial Enterprises LLC DBA · Genoa, OHBuilt 1955 · S/N 18-4529N7970HMcneill Steven H · Santa Fe, NMS/N 12-887N7972HAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1946 · S/N 12-875N7973HMessinger Donald C · Wasilla, AKBuilt 1946 · S/N 12-876N7977HMmwbc LLC · Hamilton, MTBuilt 1946 · S/N 12-873N7977VRanten Christopher D · Climax, MNBuilt 1982 · S/N 18-8209013N7979HDeuling Jarrett R · Haines, AKS/N 12-864N7982HSandoe Zachary M · Shalimar, FLS/N 12-874N7982KCarlson Jeffrey D · Ashville, NYS/N 18-6565N7983HThomas Ian C · Fairbanks, AKBuilt 1946 · S/N 12-877N7985HPolovitch Rex L · Crown Point, INBuilt 1946 · S/N 12-879N7986HBowe Walter C Trustee · Sonoma, CABuilt 1946 · S/N 12-857N7987HBrook Gary · Cocolalla, IDBuilt 1946 · S/N 12-900N7990HAbell Alan R · Elgin, ILS/N 12-898N7994HErickson David L · Anchorage, AKBuilt 1946 · S/N 12-1142N7996HLennarston Steven R · Duluth, MNBuilt 1946 · S/N 12-894N7998PEllis William C · Gakona, AKBuilt 1968 · S/N 18-7882N79991Dykstra Robert P · Sioux Falls, SDBuilt 1966 · S/N 18-8354N79HSherman John H · Lisle, NYS/N 4-748N79KHPralle Jeffory K · Wasilla, AKS/N 22-6778N79SBBlankenship John R · Weirsdale, FLS/N 18-7909004N7JSPeters Justin A · Pearce, AZBuilt 1943 · S/N 5-1435N7KATurner Tim R · San Angelo, TXBuilt 1978 · S/N 18-7809069N7LXSalish Flyers LLC · Medina, WABuilt 1947 · S/N 12-2687N7MYParis Enterprises LLC · Wilmington, DEBuilt 1959 · S/N 18-7242N7NMHulke Ted A · Pine River, MNS/N 54-2616N8000DSmith Craig E · Fillmore, NYBuilt 1957 · S/N 22-5525
Back to AD 99-01-05 R1