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.

N85083Adkins Dwain L · Sycamore, ILBuilt 1946 · S/N 7AC-3813N85085Medicine Bow Management Fund LLC · Helena, MTS/N 7AC-3816N85086Blackstone Aircraft LLC · Hartselle, ALS/N 7AC-3815N85087Mathews Scott P · Draper, SDS/N 7AC-3818N85088Knowles Greg · Reidsville, NCBuilt 1946 · S/N 7AC-3817N85089Cattron Matthew · Webster, NYBuilt 1946 · S/N 7AC-3835N85091Brutlag Paul D · Wendell, MNBuilt 1946 · S/N 3833N85099Sale Reported · Belgrade, MTSale reportedBuilt 1946 · S/N 7AC-3829N85101Whitman David L Jr · Sarasota, FLS/N 7AC-3903N85107Rude Holdings LLC · Raleigh, NCBuilt 1946 · S/N 7AC-3840N85108Wilson Charles W · Mckinney, TXBuilt 1946 · S/N 7AC-3841N85109France Donald R · Marcellus, MIBuilt 1946 · S/N 7AC-3842N85114Richmond George H · Elkhorn, NEBuilt 1946 · S/N 7AC-3847N85118Dunshee Anette M · La Luz, NMBuilt 1946 · S/N 7AC-3851N8511ERichter Von E · Climax, GABuilt 1959 · S/N 7EC-700N85121Hubbard Brian · New Brighton, MNS/N 7AC-3854N85122Houck Mark J · Fredericksburg, PABuilt 1946 · S/N 7AC-3855N85130Mcdowell Charles T · Pittsgrove, NJBuilt 1946 · S/N 7AC-3766N85133Hanson Dirk Allen · Moorhead, MNS/N 7AC-3864N85138Acadiana Fixed Wing Rotor Wing Inc · Carencro, LABuilt 1946 · S/N 7AC-3869N8513ESessions Jaron B · Hemphill, TXBuilt 1959 · S/N 7FC-333N85141Talamo Robert F · Oswego, NYBuilt 1946 · S/N 7AC-3872N85142Politte Timothy Jay · Sainte Genevieve, MOBuilt 1946 · S/N 7AC-3873N85147Kieffer Thomas P III · Columbus, INBuilt 1946 · S/N 7AC-3878N85148Denys George A · Unadilla, NYS/N 7AC-3879N85151Wilson William L · Placerville, CABuilt 1946 · S/N 7AC-3882N8515ASale Reported · Cookson, OKSale reportedS/N 7AC-3363N8515ERegistered aircraftS/N 7GC-79N85161Amiot Gary · Valdosta, GABuilt 1946 · S/N 7AC-3893N85163Schifano Benedict S · Scottsville, NYBuilt 1946 · S/N 7AC-3895N85166Richardson Chasen M · Henderson, NVBuilt 1946 · S/N 7AC-3898N85168Schutze Eric D Trustee · Ojai, CAS/N 7AC-3900N85170Watson Bobby M · Hoxie, ARBuilt 1946 · S/N 7AC-3902N85173Ellis Jayson A · Benson, NCBuilt 1946 · S/N 7AC-3905N85179Philpott Stuart L · Taylorsville, KYBuilt 1946 · S/N 7AC-3911N85181Bas Part Sales LLC · Greeley, COBuilt 1946 · S/N 7AC-3913N85182Welton Doug · Fairbanks, AKBuilt 1946 · S/N 7AC-3914N85186Foley Ward · Westminster, CABuilt 1946 · S/N 7AC-3918N85188Hofeldt Jadrian B Trustee · Verona, WIBuilt 1946 · S/N 7AC-3920N85189Delp Thomas W · Rensselaerville, NYBuilt 1946 · S/N 7AC-3921N8518ELenbom Mark A · Cameron, WIBuilt 1959 · S/N 7FC-328N85191Fletcher John W · Burlison, TNBuilt 1946 · S/N 7AC-3923N85192Daphna Inc · Middletown, DEBuilt 1946 · S/N 7AC-3925N85194Gray Rex L · Palmer, AKBuilt 1946 · S/N 7AC-3927N85198Bootz Patrick C · Lemmon, SDBuilt 1946 · S/N 7AC-3931N85199Osprey Holding Company LLC · Foley, ALBuilt 1946 · S/N 7AC-3932N8519EBumblebee Aviation LLC · Dayton, OHBuilt 1959 · S/N 7FC-329N85204Corriher Ronald R · Mount Ulla, NCBuilt 1946 · S/N 7AC-3937N85207Blome Terry L · Pleasant Plains, ILS/N 7AC3940N85216Russell Christopher Nicholas · Everett, WAS/N 7AC-3949
Back to AD 2000-25-02 R1