OpenAirDocs.org
AD 81-18-08 R3

Registered aircraft · 41

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:81-18-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-08-R3')
  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.

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76N191WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U136N1924TUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-115N192WAAmeriflight LLC · Dallas, TXBuilt 1973 · S/N U152N197WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U-130N199CZN199cz LLC · Milwaukee, WIBuilt 1968 · S/N U-30N20FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-111N21FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-117N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135N34AKUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-105N390RHAlpine Aviation Inc · Provo, UTS/N U-39N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2N4299AUas Transervices Inc · Boca Raton, FLBuilt 1971 · S/N U-146N450NANational Aerotech Aviation Delaware · Wilmington, DES/N U-92N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81N599CZN599cz LLC · Milwaukee, WIBuilt 1969 · S/N U-89N699CZN699cz LLC · Milwaukee, WIBuilt 1968 · S/N U-10N70NPBemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U-14N7862RUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-85N799CZN799cz LLC · Milwaukee, WIBuilt 1969 · S/N U-68N802BAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-29N899CAAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-104N899CZN899cz LLC · Milwaukee, WIS/N U-96N950AAAlpine Aviation Inc · Provo, UTBuilt 1974 · S/N U-159N95WAAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U-6N994AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1970 · S/N U141N999CZN999cz LLC · Milwaukee, WIBuilt 1969 · S/N U116N999DZAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U70N99GHAlpine Aviation Inc · Provo, UTS/N U-112
Back to AD 81-18-08 R3