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.

N7579ZRotor And Wing · Tioga, NDBuilt 1965 · S/N 25-3653N757AKSloan Kyle C · Anchorage, AKBuilt 1950 · S/N 18-278N757DSCummings Scott A · Monitor, WABuilt 1947 · S/N 12-2745N757JVVocell James J · Moultonborough, NHS/N 18-4038N757TMMayeur Terri-Jo · Wasilla, AKBuilt 1950 · S/N 18-336N7580HFurjesi Steve J · Chehalis, WABuilt 1946 · S/N 12-460N7580KCrop Care By Air Inc · Lantry, SDBuilt 1950 · S/N 18-297N7580YMeekin Michael · Sutton, AKBuilt 1965 · S/N 18-8300N7581DAllen Stephen W · Fredericksburg, TXBuilt 1957 · S/N 18-5875N7581HMartinez Anthony III · Great Bend, KSBuilt 1946 · S/N 12-451N7581KU Lazy S Ranch · Post, TXBuilt 1950 · S/N 18-298N7581LPruitt Kerry P · Nacogdoches, TXBuilt 1975 · S/N 18-7509079N7583DCulver Deborah M · Anchorage, AKBuilt 1957 · S/N 18-5879N7585DSelf Defense Of New England LLC DBA · Bedford, NHBuilt 1957 · S/N 18-5881N7585HJordan Don T · Midlothian, TXBuilt 1946 · S/N 12-465N7585KHolmberg Eric G · Eagle River, AKBuilt 1950 · S/N 18-302N75884A-Z Aviation LLC · Bay City, MIBuilt 1956 · S/N 20-811N7588EGross Barbara J · Timber Lake, SDBuilt 1950 · S/N 18-305N7588HEagy Gregory L · Boise, IDBuilt 1946 · S/N 12-450N7590KByers Steven J · San Diego, CABuilt 1950 · S/N 18-307N7592HClaypool Kimberly A · Ottumwa, IABuilt 1946 · S/N 12-466N7592ZBrain Paul W · Webster City, IABuilt 1965 · S/N 25-3677N7593HFricks Philip B · Piedmont, SCBuilt 1946 · S/N 12-467N7595HKnutson Daniel T · Lodi, WIBuilt 1946 · S/N 12-469N7597KGuptill Patrick · Quinn, SDFirst renewal noticeBuilt 1950 · S/N 18-314N7599HMorris Sid · Kenai, AKBuilt 1946 · S/N 12-473N7599KSimmons Dawson L Jr · Council, NCBuilt 1950 · S/N 18-316N759AKMichael Michael D · Soldotna, AKBuilt 1956 · S/N 18-2492N75MPAniol Ashley · Glendale, AZS/N 22-8702N75PCWillard Raymond C · Wasilla, AKBuilt 1976 · S/N 18-7609133N75VYRevell Ricki A Trustee · Monument, COBuilt 1979 · S/N 188009021N7600DMangos Charles A · Rochester, NYBuilt 1957 · S/N 22-5301N7601PVictory Holdings LLC · Anacortes, WABuilt 1962 · S/N 18-7792N7603HRegistered aircraftN-number assigned, not yet registeredS/N 12-478N7604HMorehouse Brett A · Fairbanks, AKBuilt 1946 · S/N 12-479N7606KAmmons Curtis D · Hernando, MSBuilt 1950 · S/N 20-421N7608HKavanagh Preston B · Tarpon Springs, FLBuilt 1946 · S/N 12-483N7609DBraden James L · Hillsboro, KSBuilt 1957 · S/N 22-5311N7609KShrode Rafe C · Jewett, TXS/N 20-512N7610DBug Smashers LLC · Winfield, KSS/N 22-5312N7610HOne Zero Hotel LLC · Waunakee, WIS/N 18-917N7611DLazare Luke B · Merrill, WIS/N 22-5313N7611HVezina Robert J · Rockford, MIBuilt 1946 · S/N 12-487N7611ZKnutson Wayne R · Tioga, NDBuilt 1965 · S/N 25-3716N7613DHendrickson Aaron C · Mazomanie, WIBuilt 1957 · S/N 22-5317N7613KSchramm Harold G · Utica, SDBuilt 1950 · S/N 20-429N7614DBig Bend Community College Foundation · Moses Lake, WABuilt 1957 · S/N 22-5318N7614HCommand Aire LLC · Sitka, AKBuilt 1946 · S/N 12-489N7614KGoering Rodney · Hutchinson, KSBuilt 1950 · S/N 20-430N7615KHardin Donald D · Kirkwood, MOBuilt 1952 · S/N 22-821
Back to AD 99-01-05 R1