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.

N6164DSeligson Andrew · Tuckahoe, NYBuilt 1957 · S/N 22-4811N6166DClb LLC · Boerne, TXBuilt 1957 · S/N 22-4813N6168DMadison James E · Concord, CABuilt 1957 · S/N 22-4815N616AMartin Andrew D · Odessa, FLBuilt 1951 · S/N 22-19N6173DArs Logistics LLC · Hackettstown, NJBuilt 1957 · S/N 22-4820N6174DOtoole Makena · Cordova, AKBuilt 1957 · S/N 22-4821N6175ZSpot-Air LLC · Burlington, TXBuilt 1959 · S/N 25-208N6176DSawyer Stephen W · Brigham City, UTBuilt 1957 · S/N 22-4823N617TCCamp Thomas H · Melbourne, FLBuilt 1974 · S/N 18-7409120N6181DNolta Christopher D · Corcoran, CABuilt 1957 · S/N 18-5468N6182DGr8daynevada LLC · Carson City, NVBuilt 1957 · S/N 18-5469N6185DOmega 1 Corp · Middletown, DEBuilt 1957 · S/N 18-5474N6189ZHall William B · Vincentown, NJBuilt 1960 · S/N 25-223N6191DBrookway Aviation LLC · Brookhaven, MSBuilt 1957 · S/N 18-5485N6195DTieszen Randal · Madison, ALBuilt 1957 · S/N 18-5491N6196ZH&H Ag-Aviation Inc · New Underwood, SDBuilt 1960 · S/N 25-230N619CCDarkhorse Aerospace Holdings LLC · Tampa, FLBuilt 1994 · S/N 1809111N61TPPalmer Blake A · Knoxville, TNBuilt 1961 · S/N 22-8162N6200ZAerial Banners Inc · Pembroke Pines, FLBuilt 1960 · S/N 25-234N6203ZKnutson Wayne R · Tioga, NDBuilt 1960 · S/N 25-241N62074Stoll Manufacturing Inc · Marysville, KSBuilt 1943 · S/N 5-1495N6208ZBenz Aviation LLC · Ionia, MIBuilt 1960 · S/N 25-246N621Palmer Robert M · Vanzant, MOS/N 16-489N62136Gist Sally R · Horseshoe Bay, TXBuilt 1947 · S/N 11-1439N6216XCentral Alabama Soaring Association · Birmingham, ALBuilt 1964 · S/N 25-3110N6218ZLorenzo Ag Air Inc DBA · Lorenzo, TXBuilt 1960 · S/N 25-258N621RBentley Aero Inc · Wilmington, DEBuilt 1951 · S/N 18-793N6222CHoefly Christopher S · Belleview, FLS/N 5860N6223YSeminole Flying & Soaring Inc · Clermont, FLFirst renewal noticeBuilt 1965 · S/N 25-3296N6225ZBriner Mark E · Utica, KYBuilt 1963 · S/N 25-273N622PPHyde Russell M · Rutherfordton, NCBuilt 1947 · S/N 12-2642N62367Nehl Seth M · Mandan, NDS/N 18-4334N6238ZDrake Aerial Enterprises LLC DBA · Genoa, OHBuilt 1960 · S/N 25-289N6239ZQuickflight LLC · Mazomanie, WIBuilt 1960 · S/N 25-290N623AFaught Jeffrey R · Bismarck, NDBuilt 1951 · S/N 22-24N623JEHanni Walter G · Anchorage, AKBuilt 1965 · S/N 18-8272N623MPKimball Duane A · Wasilla, AKBuilt 1964 · S/N 188090N6248RHewitt Chad R · Vernonia, ORS/N 188320N62491Registration Pending · Strawn, TXRegistration pendingS/N 18-7709037N624ATiffany Connor D · Naknek, AKBuilt 1951 · S/N 22-27N624BLBurril Casey J · Elba, ALS/N 16-205N624SEPrysi Mary H · Dundee, OHBuilt 1958 · S/N 186576N62572Bendock Terry · Grants Pass, ORBuilt 1978 · S/N 18-7809097N625DEGraham Andrew D · Edmonds, WABuilt 1953 · S/N 22-1679N625LALane Aviation Inc · Rosenberg, TXBuilt 1970 · S/N 18-8893N62606Rose Bryan S · Newberg, ORS/N 18-7809099N6260ZAerial Banners North Inc · Pembroke Pines, FLBuilt 1960 · S/N 25-321N62633Maloney Thomas P · Soldotna, AKBuilt 1978 · S/N 18-7809101N62634Oilar Nick L · Mcarthur, CAFirst renewal noticeBuilt 1978 · S/N 18-7809102N6264ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-326
Back to AD 99-01-05 R1