AD 2000-25-02 R1

Registered aircraft · 7,563

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:2000-25-02-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:2000-25-02-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.

N4134EPierce David R · Reidsville, NCBuilt 1947 · S/N 11CC-42N4134YLandon Jeff · Quartz Hill, CAS/N 278-76N4135YMoore Steven J · West Ossipee, NHBuilt 1976 · S/N 953-76N4139EKrepfl Martin J · Colorado Springs, COBuilt 1947 · S/N 11CC-47N4139YPremier Management Co Inc · Mobridge, SDBuilt 1978 · S/N 1248-78N413WPKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1999 · S/N 1261-99N4140YBuckman Dean D · Monroe City, MOBuilt 1976 · S/N 1178-76N4141EEpmeier Bruce E · Newburgh, INBuilt 1947 · S/N 7AC-7131N4141YWells Kevin R · Elko, NVBuilt 1976 · S/N 1179-76N4142EBulldog Aviation LLC · Ely, MNBuilt 1947 · S/N 11CC-50N4142YRegistered aircraftBuilt 1976 · S/N 279-76N4143YHasenfus Heidi J · Green Cove Springs, FLBuilt 1977 · S/N 236-77N4145EMacgregor Wayne R · East Northport, NYBuilt 1947 · S/N 11CC-53N4147YReisdorf Steven R · Saint Cloud, MNBuilt 1976 · S/N 956-76N4148YTailwheel Flying LLC · Rochester, MNBuilt 1976 · S/N 280-76N4150EAnderson Kyle E · Palmer, AKS/N 11CC-57N4150YFlying Bullfrog LLC · Virginia Beach, VABuilt 1976 · S/N 597-76N4151EClark William · Easton, MOBuilt 1947 · S/N 11CC-58N4151YWarner Kenneth G · Granbury, TXBuilt 1976 · S/N 1181-77N4152ESchwend Brian · Forsyth, MTS/N 11CC59N4154RScheuerman Gary F · Athelstane, WIBuilt 1979 · S/N 1138-79N4156YCummings Amelia D · Delta Junction, AKS/N 962-77N4157YMclean Garrett Thomas · Soldotna, AKS/N 1183-77N4159EJohnson Lowell G · Trimble, MOBuilt 1947 · S/N 11CC-64N4159YBauer Aviation LLC · Reese, MIBuilt 1977 · S/N 23877N4160EWanda Collins Professional Pilot Services LLC · Madisonville, TXBuilt 1947 · S/N 7AC-7135N4161EMaki Duane G · Wirt, MNBuilt 1947 · S/N 7AC-7136N4161YWings Enterprizes Ltd Co · Yukon, OKBuilt 1977 · S/N 282-77N4162EGround Loopers Flight Club LLC · Gunnison, UTBuilt 1947 · S/N 11CC-65N4162YGarrels Gregory J · Salcha, AKBuilt 1977 · S/N 242-77N4163YWachter Bruce A · Maryville, TNS/N 959-77N4164EVitale Andrew R · Middletown, NYBuilt 1947 · S/N 11CC-67N4166EMpms Inc · Munford, TNBuilt 1947 · S/N 11CC-69N41677Northern Aviation LLC · Palmer, AKBuilt 1973 · S/N 585-73N41678Dodge Donald V · Newnan, GAS/N 586-73N41680Tailwheel Adventures LLC · Orlando, FLS/N 396-73N41681Ralston Michael J · Calhoun, GABuilt 1973 · S/N 397-73N41683Ferraro Jeffrey T · Mckinney, TXS/N 976-73N41684Nenahlo Thomas L · Anchorage, AKS/N 588-73N41686Atx Aero LLC · Austin, TXBuilt 1973 · S/N 398-73N41688Breunig Gerald S · Newark, ILBuilt 1973 · S/N 977-73N4168YThree Point LLC · Lacon, ILBuilt 1976 · S/N 1185-77N41691Whiteknucle Aerobatics Inc · Blacksburg, VABuilt 1973 · S/N 591-73N41693Glasford John T · Rapid City, SDBuilt 1973 · S/N 979-73N41694Damiano Charles J · Orcutt, CABuilt 1973 · S/N 400-73N41695Guilfoyle Robert J · Shepherd, MTBuilt 1973 · S/N 593-73N41696Aaa Aviation LLC · Donalsonville, GABuilt 1973 · S/N 116-73N41698Collier James R · Castle Rock, COBuilt 1973 · S/N 980-73N416SDTailwheel Adventures LLC · Celebration, FLBuilt 1968 · S/N 191N416SSChristie Ian A H · Limon, COBuilt 1974 · S/N 721-74
Back to AD 2000-25-02 R1