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.

N3580ARegistered aircraftS/N 22-1855N3580MHall Garrett J · Homer, AKS/N 12-2510N3580ZRoma Air Corp · Belle Glade, FLBuilt 1960 · S/N 18-7370N35811Scott Barry R · Florence, ALBuilt 1941 · S/N 5-773N35814Cook Mike R · Rye, COS/N 4-1442N35819Erickson Mark D · Valley Springs, SDS/N 5-781N3581ATriflyer Partners LLC · Garden Plain, KSS/N 22-1856N35822Mcrobie Roger L · Maryville, TNBuilt 1941 · S/N 5-786N35827Watkins Lawrence A · San Jose, CABuilt 1941 · S/N 5-798N3582ASindelar David C · Franklin, KYBuilt 1953 · S/N 22-1857N3582ZVan Winkle Randy M · Van Buren, MOBuilt 1960 · S/N 18-7372N35838Reusch Gerald Walter · Sebring, FLS/N 6608N35839Giles Forrest D · Springtown, TXS/N 6609N3583ZHanneman Logan L · Fairbanks, AKBuilt 1960 · S/N 18-7373N35848Semeraro Bart D · Austin, TXS/N 6314N3584MBurcham Aaron T · Soldotna, AKBuilt 1947 · S/N 12-2431N3584PWatson Frank D · Canton, PABuilt 1955 · S/N 18-4538N3584ZWildman Air LLC · Mckinney, TXBuilt 1960 · S/N 18-7374N35855Merritt Daniel D · Graham, WABuilt 1941 · S/N 6623N3585AClement Jeffrey A · Abilene, TXBuilt 1953 · S/N 20-1085N35862Rustad Scott K · Minot, NDBuilt 1941 · S/N 5801N3586MKoskovich Thomas D · Shakopee, MNBuilt 1947 · S/N 12-2509N35873Mcgraw Charles F · Reno, NVBuilt 1941 · S/N 6638N35878Cape May Aerial Advertising LLC · Rio Grande, NJBuilt 1941 · S/N 6633N35880Carstensen Ross J · Waterloo, NEBuilt 1941 · S/N 4-1415N35886Colvin Clu D DBA · Big Cabin, OKBuilt 1941 · S/N 4-1419N35887Rose Carl Warren · Westmoreland, TNBuilt 1941 · S/N 4-1420N3588PLewis' Flying & Maintenance Svc Inc · Morse, LABuilt 1955 · S/N 18-4543N35897Delavan Emery L Jr · Castroville, TXS/N 4-1427N3589PNewsom Bearden And Cobb Inc DBA · Lubbock, TXBuilt 1955 · S/N 18-4544N3589ZHart Gregory R · Eden Prairie, MNBuilt 1960 · S/N 18-7382N35901Wise Frederick W · Windsor, PABuilt 1941 · S/N 4-1432N35903Colvin Clu D DBA · Big Cabin, OKBuilt 1941 · S/N 4-1431N35906Geisler Mark C · Dallas, TXS/N 4-1436N35908Ashley Edward A · San Antonio, TXBuilt 1941 · S/N 4-1438N3590PSoyars Thomas E · San Marcos, TXBuilt 1955 · S/N 18-4545N35916Lindenschmidt Robert J · Evansville, INBuilt 1955 · S/N 4-1445N3591MScheibe Marvin E · Wooster, OHBuilt 1947 · S/N 12-2437N3591ZFoss Rick · Lemmon, SDBuilt 1960 · S/N 18-7384N35920Strickland Thomas M · Akron, ALFirst renewal noticeBuilt 1941 · S/N 4-1450N35927Fielding David J · Scarborough, MEBuilt 1941 · S/N 5-815N3592AKyle Allyn B · Snohomish, WABuilt 1953 · S/N 18-3022N3592PDengler Steven G · Lopez Island, WABuilt 1955 · S/N 18-4550N35931Kelley Joseph W · Helena, MTBuilt 1941 · S/N 5821N3594MThacker William E · Chenoa, ILS/N 12-2439N3594PPourcho William S · Bloomfield Hills, MIBuilt 1955 · S/N 18-4552N3594ZJuhan Crawford F Jr · Crawford, GABuilt 1960 · S/N 18-7387N3595PSchumacher Craig A · Fairbanks, AKBuilt 1955 · S/N 18-4553N3595ZJohnson Issac · Krugerville, TXBuilt 1960 · S/N 18-7388N35966Colin Tony Ray · Waunakee, WIS/N 6683
Back to AD 99-01-05 R1