OpenAirDocs.org
AD 90-02-11

Registered aircraft · 36

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

N114BAAustin Bill DBA · Sparta, TNS/N 42-8001027N121LHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 425501049N141TCEhs Aircraft LLC · Wilmington, DEBuilt 1984 · S/N 42-5501021N190CAJag Air LLC · New Castle, DES/N 42-8001028N225MBCheyenne III Flyers LLC · New York, NYBuilt 1983 · S/N 42-8001102N242RAJohnston Properties LLC · Garden City, KSS/N 42-8001003N245JRAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501019N315WSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 425501015N3644BSeptember Bravo Enterprises LLC · West Olive, MIBuilt 1984 · S/N 425501014N395DRWings International II LLC · Wilmington, DEBuilt 1981 · S/N 42-8001065N396CTFlight Assets LLC · Dover, DEBuilt 1987 · S/N 42-5501044N396FWRoute 66 Aerostars LLC · Galena, KSBuilt 1980 · S/N 428001021N401JTN401jt LLC · Denver, COS/N 42-5501023N41182Piper Aircraft Inc · Vero Beach, FLBuilt 1985 · S/N 42-5501024N425RRValiair Lc Trustee · Casper, WYBuilt 1984 · S/N 42-5501008N42ZCCrest View Aero LLC · Rancho Cordova, CABuilt 1981 · S/N 428001039N440CACc Flight Company LLC · Columbia City, INBuilt 1985 · S/N 42-5501027N444CYShuman Farms Inc · Reidsville, GABuilt 1984 · S/N 42-5501025N5SYDialysis Clinic Inc · Nashville, TNBuilt 1981 · S/N 42-8001069N627PCAir First LLC · Kalispell, MTBuilt 1984 · S/N 425501010N690ECheyenne Development Associates 2 LLC · Dover, DEBuilt 1984 · S/N 42-5501020N69PCValiair Lc Trustee · Casper, WYBuilt 1981 · S/N 42-8001023N706JRDodson International Parts Inc · Rantoul, KSS/N 42-5501050N7139BNortheast Travel Corp · Brooklyn, NYBuilt 1980 · S/N 42-8001042N75AWSemper Blue Aviation LLC · New Braunfels, TXBuilt 1981 · S/N 42-8001046N778SGValiair Ltd Co Trustee · Casper, WYBuilt 1983 · S/N 42-5501006N82PGAugustus Air LLC · Mc Allister, MTBuilt 1981 · S/N 42-8001070N8RYAviation Sales & Charter LLC · Dover, DES/N 42-8001036N9091JDavis Aviation Inc · Brandon, MSBuilt 1986 · S/N 42-5501035N9115XPiper Aircraft Inc · Vero Beach, FLBuilt 1993 · S/N 42-5501060N9159YSouthern Arkansas University Tech · Camden, ARBuilt 1985 · S/N 42-5501028N92402Piper Aircraft Inc · Vero Beach, FLBuilt 1990 · S/N 42-5501052N92409Piper Aircraft Inc · Vero Beach, FLBuilt 1990 · S/N 425501054N9240QPiper Aircraft Inc · Vero Beach, FLS/N 42-5501051N945THTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 42-8001063N95VRHenry IV LLC · Wilmington, DES/N 428001049
Back to AD 90-02-11