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.

N90462Manning Mark D · Wrenshall, MNBuilt 1959 · S/N 325N9047BBooker Lisa M · Coeur D Alene, IDBuilt 1958 · S/N 7EC-639N9047LDaniel Bryan G · Childress, TXS/N 217-70N9048BMark A Lenbom · Cameron, WIS/N 7FC-136N9048ECarlson Nicholas · Waco, TXBuilt 1946 · S/N 11AC-679N9049FMiller Glenn E · Selma, CAS/N 7EC 404N9049LOsborn Melissa L · Fairbanks, AKBuilt 1970 · S/N 764-70N904JBMitchell Thomas H · Batesville, MSFirst renewal noticeBuilt 1978 · S/N 417-78N9050BKarge Kent K · Quincy, CABuilt 1958 · S/N 7FC-138N9050EBroadwell Eric B · Woodstock, GAS/N 11AC-681N9050LOwen Alva A · Hilliard, FLBuilt 1970 · S/N 765-70N9051BFinished Work Aviation LLC · Redding, CAS/N 7FC-139N9051EDexter Fred H · Live Oak, FLBuilt 1946 · S/N 11AC-682N9052BLucas John C · Sutter Creek, CABuilt 1958 · S/N 7FC-140N9052LOlson Ronnie E · Palmer, AKBuilt 1970 · S/N 271-70N9053BKraken Aero LLC · Newport News, VAS/N 7FC-141N9054BOber John A · Candor, NYS/N 7FC-142N9054EStahl Carl L · Union Dale, PABuilt 1954 · S/N 11AC685N9055ERowletf Jeffrey D · Jonesville, VABuilt 1946 · S/N 11AC-686N9055LJavelin Citrus LLC · Erda, UTS/N 244-70N9056BPompeo John M · Gorham, MEBuilt 1958 · S/N 7FC-144N9057LKing Nathan A · Dunkirk, MDS/N 769-70N9058BHigh Daniel M · Houston, TXBuilt 1958 · S/N 7FC-146N9058LLucius William C · Moosic, PABuilt 1970 · S/N 220-70N905KTmd Enterprises LLC · Amarillo, TXBuilt 2006 · S/N 1020-2006N905NRState Of Minnesota · Grand Rapids, MNBuilt 2006 · S/N 479-2006N9060BWaite Myron A · Pawlet, VTBuilt 1958 · S/N 7FC-148N9060LShank Paul L · Gaithersburg, MDBuilt 1970 · S/N 275-70N9062LR & B Helicopters Inc · Calhoun, GABuilt 1970 · S/N 221-70N9063BPratt Patrick D · Martinisville, INBuilt 1958 · S/N 7EC-643N9063EDudley Shiloh W · Palatka, FLS/N 11AC694N9064BHogan Frederick D · Hamilton, OHBuilt 1958 · S/N 7FC-149N9064EWickenheiser John · Newport, MIBuilt 1946 · S/N 11BC-695N9064LHendrickson Don W · Helena, MTBuilt 1970 · S/N 247-70N9066LPasco Gary R · Brockport, NYBuilt 1970 · S/N 773-70N9067LGabriel Thomas G · Clinton, PABuilt 1970 · S/N 774-70N9068BTherriault Charles W · Auburn, NHBuilt 1958 · S/N 7EC-644N9068EMarsh Steven A · Eaton Rapids, MIBuilt 1946 · S/N 11AC-699N9069BDemello Michael B · Phoenix, ORBuilt 1958 · S/N 7FC-153N9069LCitabria Flyers LLC · North Salt Lake, UTBuilt 1970 · S/N 252-70N906NCactus Pilots LLC · Tulsa, OKBuilt 2022 · S/N 1203-2022N9070BDavis Hunter R · Morgan, TXBuilt 1958 · S/N 7FC-154N9071BLaney Kevin D · Maiden, NCBuilt 1958 · S/N 7FC-155N9071LWolfley Jody K · Mountain Home, IDS/N 276-70N9072CBerg Michael S · Eleva, WIS/N 7BCM-405N9073LRegistration Pending · Munford, TNRegistration pendingBuilt 1970 · S/N 776-70N9074BWasik Marvin B · Hernando, FLBuilt 1958 · S/N 7FC-158N9074LTillotson Bradley T · Loveland, OHBuilt 1970 · S/N 777-70N9075BLaney Charles A · Maiden, NCBuilt 1958 · S/N 7FC-159N9075LSibbernsen William · Omaha, NEBuilt 1970 · S/N 778-70
Back to AD 2000-25-02 R1