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.

N40696George Gary D · Humble, TXBuilt 1941 · S/N 4-1598N4069ZS&P Aviation LLC · Albuquerque, NMS/N 18-8079N40700Nelson Krista K · Cedar Falls, IABuilt 1941 · S/N 5-1132N4070ZN333bc LLC · Franktown, COS/N 18-8081N40713Engler William O · Filion, MIBuilt 1941 · S/N 5-1147N4071ELegends Airways LLC · Lakeland, FLBuilt 1977 · S/N 18-7809061N4071MHigh Exposure Inc · Wilmington, DEBuilt 1947 · S/N 12-2954N40720Luthe Carl E · Austin, MNBuilt 1941 · S/N 5-1152N40723Beaudry Charles F · Graham, NCS/N 5-1154N40727Aerial Sign North · Lakewood, NJS/N 5-1159N4072MBronner Lucian P · Chico, CABuilt 1947 · S/N 12-2960N4073EBenjamin Vince Lewis · Seward, AKBuilt 1977 · S/N 18-7809051N40744Scott Timothy E · West Danville, VTS/N 7458N40750Brown Jennifer L · Vancouver, WAS/N 7465N4075HWessel Paul Rinehardt · Honolulu, HIS/N 12-3506N4075TCms Land Co · Richmond, TXBuilt 1952 · S/N 18-1857N4076MBendza Matthew J · Bonner, MTBuilt 1947 · S/N 12-2958N4077MSummers Gary D · Rexburg, IDBuilt 1947 · S/N 12-2959N4077ZN4077z LLC · Wasilla, AKBuilt 1964 · S/N 18-8091N40782Rsd Aviation LLC · Pataskala, OHBuilt 1941 · S/N 7496N40791Porter David E · Woodstock, GAS/N 5-1168N40792Schulz Michael Alan · Upland, CABuilt 1941 · S/N 4-1602N40795Greycat Aviation LLC · Chesapeake, VABuilt 1941 · S/N 5-1180N4079ZNewton James K · Charles Town, WVBuilt 1963 · S/N 18-8093N407WBBad Dog Aviation LLC · Wasilla, AKBuilt 1963 · S/N 18-8085N407WYVerdoljak Corey · Homer, AKBuilt 1955 · S/N 18-4192N4080HEarle Brian S · Two Rivers, AKBuilt 1947 · S/N 12-3508N4080ZVan Dyke Brian S · Rio Oso, CABuilt 1964 · S/N 18-8094N40817Smith Brant P · Palmer, AKBuilt 1941 · S/N 7512N40819Habig Robert D · Sheridan, INBuilt 1941 · S/N 7517N40827A And W Aircraft Inc · Lake Geneva, WIBuilt 1941 · S/N 7531N4082MOdegaard Aviation LLC · Kindred, NDS/N 12-2964N40832Evans Johnny D · Wasilla, AKS/N 18-4468N40839Daniel John B · Indiana, PAS/N 7540N4083EHulsey Steven M · Chugiak, AKBuilt 1977 · S/N 18-7809056N4083ZRaymond Raphael T · Helix, ORBuilt 1964 · S/N 18-8098N4084EIngham Ben B · Sonora, TXS/N 18-7809058N4084MStempky John A · Anchorage, AKS/N 12-2967N4084ZHull Keath C · Wasilla, AKFirst renewal noticeBuilt 1964 · S/N 18-8099N40859Coffey James R Jr · Williams, AZBuilt 1941 · S/N 7574N4085EGrass Roots Flying Inc Trustee · Wilmington, DEBuilt 1978 · S/N 18-7809059N40867Stells Building Renovation And Management Inc · Lino Lakes, MNBuilt 1941 · S/N 51172N4086MBudak Mark · Melba, IDBuilt 1947 · S/N 12-2969N40870Braska Aviation LLC · Caro, MIBuilt 1941 · S/N 5-1175N40875Meidinger Timothy J · Klamath Falls, ORBuilt 1941 · S/N 5-1184N40877Cochrane Timothy A · Chippewa Lake, OHS/N 5-1182N4087ZNcsb LLC · Anchorage, AKBuilt 1964 · S/N 18-8102N40885Burns Joyce A · Sparta, MOBuilt 1941 · S/N 51194N40888Uhl Chmiel John Wyatt · Wausau, WIBuilt 1941 · S/N 5-1198N4088MRam Aviation LLC · Palmer, AKBuilt 1947 · S/N 12-3003S
Back to AD 99-01-05 R1