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.

N3322AJohnson Ezra M · Rhinelander, WIS/N 22-1598N33233Red Oak Airpark Flying Club · Cabot, ARS/N 5947N33236Smith Ernest C · Cato, NYBuilt 1940 · S/N 5911N3323BCenterville Air Techs LLC · Centerville, IABuilt 1954 · S/N 22-2138N33240Weber Stephen J · Hastings, MNBuilt 1940 · S/N 5915N33242Hargrave Bobby P · Lillian, ALBuilt 1940 · S/N 5940N3324MBush Pilot Inc · Soldotna, AKBuilt 1947 · S/N 12-2183N33252N33252 LLC · Jupiter, FLBuilt 1940 · S/N 5927N33256Kourtis Vintage Aviation LLC · Owasso, OKBuilt 1940 · S/N 5930N3325AAustin James M · Ft Worth, TXBuilt 1953 · S/N 22-1609N3325MBronson David W · Anchorage, AKBuilt 1947 · S/N 12-2182N33265Sigler Daniel E · Canby, ORBuilt 1940 · S/N 5466N33269Bender Evan D H · Linville, VABuilt 1940 · S/N 5-470N33271Brock Timothy S · Cullman, ALBuilt 1940 · S/N 5-472N33279Daniel Kass · Simi Valley, CABuilt 1940 · S/N 5-480N3327BHilgendorf Douglas A · Welcome, MNBuilt 1954 · S/N 22-2142N3327ZMessinger Donald C · Wasilla, AKBuilt 1960 · S/N 22-7264N33282Guerin Michael A · Woodville, ALBuilt 1940 · S/N 5-482N33288Aviation 4031 LLC · Pasadena, TXS/N 4-1360N3328ATulis David · Frederick, MDBuilt 1953 · S/N 22-1603N3328BHarper Ken C · Kenai, AKBuilt 1954 · S/N 22-2143N33295Aspinwall David · Soquel, CABuilt 1940 · S/N 5485N3330AJordan Don T · Midlothian, TXBuilt 1953 · S/N 22-1605N3331ABurgess Roy S · Lincoln, NEBuilt 1953 · S/N 22-1607N3332AMarinan Steve · Sanger, TXS/N 22-1606N3332MFlaugher Jeffrey R · Lake Orion, MIBuilt 1947 · S/N 12-2190N3332ZWeisenburger Adam A · Seeley Lake, MTS/N 22-7269N3333BNorlin Lary G · Indianola, IAS/N 22-2148N3333LHatbox LLC · Snohomish, WABuilt 1950 · S/N 4609N3333RBuck Joseph M · Copper Center, AKBuilt 1960 · S/N 18-7565N3335ATwotards Aviation LLC · Moses Lake, WABuilt 1953 · S/N 22-1612N3335BHutsell James M · Miamisburg, OHBuilt 1954 · S/N 22-2150N3335MRiggin Flight Service Inc · Madison, SDS/N 12-2193N3335PHill Silas W Trustee · Delta Junction, AKBuilt 1958 · S/N 18-6770N3335ZGreen Francis E III · Frankfort, NYBuilt 1960 · S/N 22-7275N3336BNelson Morales · Hendersonville, NCBuilt 1954 · S/N 22-2151N3336MStevens Matthew Joel · Millersburg, MIBuilt 1947 · S/N 12-2194N3336ZCedar Mark P · Cherokee, IABuilt 1960 · S/N 22-7276N3337BJohnson Rader · Cedar City, UTBuilt 1954 · S/N 22-2152N3338BLvft Aviation Inc · Wilmington, DEBuilt 1954 · S/N 22-2153N3338MSyverson Rodney E · Ada, MNBuilt 1947 · S/N 12-2196N3338ZKeil Lawrence L · Anchorage, AKBuilt 1960 · S/N 22-7278N3339BStraub Kerry D · Grants Pass, ORBuilt 1954 · S/N 22-2154N333CPPrice Carol · Sonoma, CAS/N 18-7709189N333GHRieken Alyson V · Reno, NVBuilt 1953 · S/N 18-2447N333GPBarnes Thomas J · Anchorage, AKBuilt 1948 · S/N 11-446N333HVCli Aerospace LLC · Appleton, WIS/N 18-7922N333LWells Kris G · Barron, WIS/N 18-2135N333SWatson Joseph Daniel · Middleburg, VABuilt 1955 · S/N 18-4309N333TMSkywagon Aero LLC · Wilmington, DEBuilt 1971 · S/N 18-8939
Back to AD 99-01-05 R1