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.

N7478LAmidon Gary S · Shady Cove, ORBuilt 1975 · S/N 18-7509073N747BHLj Bickford Companies LLC · Wasilla, AKBuilt 1947 · S/N 12-2740N747DCLiljegren Frederick A · Parkers Prairie, MNS/N 12-3266N7480DFawcett Brice A Jr · Olathe, KSBuilt 1957 · S/N 18-5815N7480LMinor Joseph H · Hyannis, NEBuilt 1975 · S/N 18-7609016N7481DRegistered aircraftS/N 18-5816N7481KSalvucci Pat · Anchorage, AKBuilt 1950 · S/N 20-396N7482LAshby Clark S · Pleasant Grove, UTBuilt 1975 · S/N 18-7509083N7483DYuknis Birch A · Wasilla, AKBuilt 1957 · S/N 18-5820N7483KCurrier Dustan A L · Fairbanks, AKS/N 20-397N7483LBlain Gerhart · Billings, MTBuilt 1975 · S/N 18-7509075N74843Sky Lines Aerial Ads LLC · North Hampton, NHBuilt 1955 · S/N 18-4085N7484LDurbano David L · Ogden, UTBuilt 1975 · S/N 18-7509078N7487DSouthern Cross Aviation Inc · Wilmington, DEBuilt 1957 · S/N 18-5826N7487KMesones Juan D · North Yarmouth, MEBuilt 1950 · S/N 20-401N7487ZTruckee Tahoe Soaring Assoc · Truckee, CABuilt 1965 · S/N 25-3502N7488DDust Devil Herefords Inc · Ingomar, MTBuilt 1957 · S/N 18-5827N7489DKelly Kevin M · Eagle River, AKBuilt 1957 · S/N 18-5828N7489LMills Randall J · Monroe, MIBuilt 1975 · S/N 18-7509076N74911Aerial Messages Leasing Co · Longwood, FLS/N 18-7509092N74912Sky Sailing Inc · Warner Springs, CABuilt 1975 · S/N 18-7509094N74913Street Raymond E Jr Trustee · Fort Worth, TXBuilt 1975 · S/N 18-7509095N74919Braden John H · Watseka, ILBuilt 1975 · S/N 18-7509096N7491KGidzinski Daniel P · Campbellsburg, KYBuilt 1950 · S/N 20-404N74922Sale Reported · Anchorage, AKSale reportedBuilt 1975 · S/N 18-7509097N74924Rs Specialties LLC · Anchorage, AKBuilt 1975 · S/N 18-7509098N74929Shadbolt George Q · Merriman, NES/N 18-7509101N74935Mcevoy Richard D Trustee · Anchorage, AKBuilt 1975 · S/N 18-7509100N74945Wright Sherry L · Buhl, IDBuilt 1975 · S/N 18-7509102N7494DBrown Stephen R · Chugiak, AKBuilt 1957 · S/N 18-5833N7494KWeaver Marvin Thomas · Kalispell, MTBuilt 1950 · S/N 20-409N74954Willis Andrew B · Wasilla, AKBuilt 1975 · S/N 18-7509103N74960Smith Wallace B · Fairbanks, AKBuilt 1975 · S/N 18-7509105N74964Air Dakota Flite Inc · Hettinger, NDBuilt 1975 · S/N 18-7509104N74967Owens Sara R · Casper, WYS/N 18-7509107N74968Niesen Isaac W · Nikiski, AKBuilt 1976 · S/N 18-7709045N7496DLeggett Brandon · Eola, TXBuilt 1957 · S/N 18-5837N74979Johnson Warren E · Kenai, AKBuilt 1975 · S/N 18-7509109N7497KMorris John A · Phoenix, AZS/N 20-411N7498CAerospace Trust Management LLC Trustee · Wilmington, DES/N 18-7498N74990Berry Stanley W · Reddick, FLBuilt 1975 · S/N 18-7509111N74996Seward Air Taxi LLC · Seward, AKBuilt 1975 · S/N 18-7509112N74998White Jacob E · Delta Junction, AKBuilt 1975 · S/N 18-7509106N7499KBarnes Darin L · Wasilla, AKS/N 20-413N749DWAntler Aviation And Wildlife Service LLC · Wasilla, AKBuilt 1946 · S/N 12-1403N74MRRubbert Jan Dale · Upham, NDBuilt 1974 · S/N 18-7409145N74WFWeber Stephen J · Hastings, MNBuilt 1965 · S/N 18-8302N7500DRiggin Flight Service Inc · Madison, SDBuilt 1957 · S/N 22-5227N7500HRobinson Eric C · Palmer, AKBuilt 1946 · S/N 12-361N7502DFlight Lead LLC · Casper, WYS/N 22-5229
Back to AD 99-01-05 R1