OpenAirDocs.org
AD 2000-25-02 R1

Registered aircraft · 7,561

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.

N247MAWanda Collins Professional Pilot Services LLC · College Station, TXBuilt 2003 · S/N 932-2003N2480EWhite Robert C · Naples, FLBuilt 1946 · S/N 7AC-6060N2481EBurtch Charles R · Phoenix, NYBuilt 1946 · S/N 7AC-6059N2482EWischt Paul J Jr · Medina, OHBuilt 1946 · S/N 7AC-6061N2483EStewart Emerson C Jr · Waynesville, OHBuilt 1946 · S/N 7AC-6062N2484ETbf Llp · Bismarck, NDBuilt 1946 · S/N 7AC-6063N2485EHar Glo Farms Inc · Anamosa, IABuilt 1946 · S/N 7AC-6064N2486EHopwood I D · Centre, ALBuilt 1946 · S/N 7AC-6065N2488EWhorton Garrettson W · Halstead, KSBuilt 1946 · S/N 7AC-6070N248MAStick Back Aviation Inc · Le Roy, NYS/N 9362003N2491EAero Applications Inc · Burley, IDBuilt 1946 · S/N 7AC-6073N2492ETomlinson John J · Kent, WABuilt 1946 · S/N 7AC-6074N2495EPetro Jerry R · Williamsburg, VAFirst renewal noticeS/N 7AC6077N2498CClark William · Easton, MOS/N 7BCM-240N2498EBarnhart Bruce · Gladys, VABuilt 1946 · S/N 7AC-6080N249MAQueen City Flying LLC · Helena, MTBuilt 2004 · S/N 943-2004N249MMBishop Harold · Bonners Ferry, IDBuilt 1946 · S/N 7AC-2877N249RAApel Thomas G · Edmond, OKBuilt 2004 · S/N 1371-2004N249SFCasarez David W · Carmel Valley, CABuilt 2000 · S/N 418-2000N24BYOur Sky LLC · Woodinville, WABuilt 2004 · S/N 946-2004N24MKPiispanen Norman C · Fairbanks, AKBuilt 1969 · S/N 151N24SDHall Mike · Houston, TXBuilt 2022 · S/N 624-2022N24SZJordan James David · Helena, ALBuilt 2010 · S/N 1097-2010N24TJNeilson Keith B · East Lyme, CTBuilt 1976 · S/N 579-76N24YHKoch Bernard L · Arriba, COBuilt 1974 · S/N 782-75N2500ZGuldi James E · Port Orange, FLBuilt 1977 · S/N 991-77N2501BGoodrich Jeffrey W · Slaton, TXS/N 7BCM-315N2501FAerowood Aviation LLC · Monroe, NCBuilt 1965 · S/N 7ECA140N2501GN2501g LLC · Columbia, CABuilt 1967 · S/N 112N2501ZSmith Glenn G Jr · Ardmore, OKBuilt 1977 · S/N 1219-77N2502BVink Jason M · Palmer, AKS/N 47-1170N2502FDexter Fred H · Live Oak, FLS/N 152N2502ZByrne Gary W DBA · Georgetown, INBuilt 1977 · S/N 328-77N2503EHigginson Carl R · Merrimack, NHBuilt 1946 · S/N 7AC-6085N2503FSuperior Food Distributors LLC · Naples, FLBuilt 1965 · S/N 153N2503ZAviation Financial Corp · Torrance, CABuilt 1977 · S/N 613-77N2504ECapra Salvatore O · Lakeland, FLBuilt 1946 · S/N 7AC-6086N2504FJohnson Scott W · Saline, MIBuilt 1965 · S/N 38N2505ETibbetts Larry E · Lee, NHBuilt 1946 · S/N 7AC-6087N2505FAcme Anvil LLC · Parker, COBuilt 1965 · S/N 127N2505ZStratton Robert Stephen · Boulder, COFirst renewal noticeBuilt 1977 · S/N 330-77N2506BRunway Champ LLC · Edwardsville, ILBuilt 1947 · S/N 47-1135N2506ZKisser Karl J · Anchorage, AKBuilt 1977 · S/N 614-77N2507EArave William L · Fresno, CARegistration revokedBuilt 1946 · S/N 7AC-6089N2507FMorley Thomas O · Emmett, IDS/N 122N2508BMiller David S · Mount Sterling, KYS/N 47-937N2508FBailey Joseph H · Port Saint Lucie, FLBuilt 1965 · S/N 7ECA-123N2508ZAmelia Reid Aviation LLC · San Jose, CABuilt 1978 · S/N 1249-78N2509ZKovach Kim A · Ocala, FLS/N 333-77N2510EFields Creek Flyers LLC · Clinton, MOBuilt 1946 · S/N 7AC-6092
Back to AD 2000-25-02 R1