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.

N1SETin Cup Aviation LLC · Lakeland, FLBuilt 1947 · S/N 12-2036N1ZAEisaguirre Joseph M · Anchorage, AKBuilt 1959 · S/N 18-7002N2014PAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-4602N2025SBush Pilot Inc · Soldotna, AKBuilt 1976 · S/N 18-7609097N20284Schulz Gerald · Appleton, WIBuilt 1938 · S/N 2084N202BZBraatz Ronald W · Bend, ORBuilt 1976 · S/N 18-7609073N202MBRichardson Jane S · San Angelo, TXBuilt 1960 · S/N 18-7305N202TMurray James A · Wasilla, AKBuilt 1953 · S/N 18-2316N203TProfota Don L · Bozeman, MTBuilt 1953 · S/N 18-2317N2045NChristensen Tyler R · Red Bluff, CABuilt 1958 · S/N 186771N204TTFalkenberg Randy J · Edmonson, TXBuilt 1952 · S/N 18-2318N2054JJohnston Dwight D · Rawlins, WYBuilt 1965 · S/N 18-8218N205TClark Stephen N · Walnut Cove, NCBuilt 1953 · S/N 18-2319N206TSchou Brice N · Thomas, OKBuilt 1953 · S/N 18-2320N20815Barnett Bryan C · Rch Palos Vrd, CABuilt 1938 · S/N 2115N20821Danielson Robert DBA Conventional Air · Decatur, MIBuilt 1954 · S/N 183547N2087CLarkin Marion J · Salome, AZS/N 12-3497N208CKKarel Craig F · Filer, IDBuilt 1946 · S/N 12-569N209SAInternational Air Services Inc Owner Trustee · Carson City, NVS/N 22-8448N20JCJcmc Inc · Junction City, KSBuilt 1955 · S/N 22-2879N20LEQuality Leasing Inc · Niceville, FLBuilt 1994 · S/N 1809080N20PPTullgren Michael · Lincoln, CABuilt 1956 · S/N 22-4554N20PRGunther Randell L · Chandler, AZBuilt 1950 · S/N 20-136N2101AYork Harrison E · Aurora, COS/N 22-561N2102VGiovanini Terry L · Bozeman, MTBuilt 1954 · S/N 182663N2103ARooftop Aviation LLC · Westminster, MDS/N 20-884N2104APittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1952 · S/N 22-560N2105AStanistreet Ben · Anchorage, AKS/N 20-889N2107AArcher Shafford R Jr · Norcross, GABuilt 1952 · S/N 20-887N2113ASale Reported · Glasgow, MTSale reportedS/N 18-1844N2115AJj Ventures LLC · Billings, MTBuilt 1952 · S/N 18-1846N211FHHelm Flying Service Inc · Casselton, NDBuilt 1946 · S/N 19044N2121AGitre Daniel J · Lakeview, MIFirst renewal noticeBuilt 1952 · S/N 22-564N2122AGubler Joseph A · Fairhaven, MABuilt 1952 · S/N 22-563N2124NLivestock Service Inc · Douglas, AZBuilt 1951 · S/N 18-259N2128ANull Clifford M · Punxsutawney, PABuilt 1952 · S/N 22-570N212CANichols Larry W · Leavenworth, WAS/N 18-7809133N2138AKingdom Air Corp · Sutton, AKBuilt 1952 · S/N 18-1859N2139AAero Seat Inc · Sterling, COBuilt 1952 · S/N 18-1861N213TFlemmer Richard W · Park City, MTBuilt 1953 · S/N 18-2327N2140ALloyd Davis Inc · Brackettville, TXBuilt 1952 · S/N 22-572N2144AWhite James O · Bim, WVBuilt 1952 · S/N 22-582N21478Parker Daniel C · Stillwater, MNBuilt 1938 · S/N 2502N2147AHosmer Richard Alan · Cedartown, GABuilt 1952 · S/N 22-578N2150AAerial Sign North · Lakewood, NJBuilt 1956 · S/N 18-1862N2151AMichaud Shawn R · Glenburn, MES/N 18-1863N21528Palmenteri Louis J · Rhome, TXBuilt 1938 · S/N 2380N21531Hans Nelson & Sons Nursery Inc · Boring, ORBuilt 1957 · S/N 18-5496N2154ANoska Frank S IV · Wasilla, AKBuilt 1952 · S/N 18-1864N2156AIberlin Ranch · Gillette, WYBuilt 1952 · S/N 18-1870
Back to AD 99-01-05 R1