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.

N7517EVanherck Glen D · Bonne Terre, MOBuilt 1958 · S/N 7FC-236N7518BMaxwell Richard H · Grove City, PABuilt 1957 · S/N 7FC-23N7518FKlassen Orvil H · Mountain Lake, MNS/N 200N7519FBohlman Todd L · Lemon Grove, CABuilt 1969 · S/N 201N751UGaines Charles C · Fernandina Beach, FLBuilt 2015 · S/N 1153-2014N7520BGreen William D · Fairbanks, AKBuilt 1957 · S/N 7EC-585N7521BBarnick Ryan E · Montpelier, NDBuilt 1957 · S/N 7EC-591N7522BTailwheelin LLC · Richland, WAS/N 7FC-25N7524EWaterbury Farms · Gridley, CABuilt 1958 · S/N 7EC-669N7524FRobinson Robert L Jr · Homer, AKBuilt 1969 · S/N 207N7525EJennings Shawn T · Chetek, WIBuilt 1958 · S/N 7EC-670N7526BTyree Chris L · Arley, ALBuilt 1957 · S/N 7FC-29N7526EKerlin Matthew D · Fredericksburg, VABuilt 1958 · S/N 7FC-238N7526FMikulich Joseph · Bovey, MNBuilt 1969 · S/N 271N7527FProtsman Bryan D · Anchorage, AKBuilt 1969 · S/N 208-70N7528BFairley Stephen M · Petal, MSBuilt 1957 · S/N 7FC-31N7528FRausch Bruce Thomas · Marysville, OHBuilt 1969 · S/N 212-70N7529BTeck Roger M · Mayfield, NYBuilt 1957 · S/N 7FC-32N752DEEwers C Donald Trustee · Batavia, OHBuilt 1998 · S/N 1368-98N7531FCanale Anthony · Friendswood, TXBuilt 1969 · S/N 286-70N7532BRimck Lloyd F · Maricopa, AZBuilt 1957 · S/N 7FC-35N7532FPrather Carl L · Gilroy, CABuilt 1969 · S/N 272-70N7533BJoe Dory Aviation LLC · Star, IDS/N 37-57N7534BMandan Enterprises LLC · Chester, CTBuilt 1957 · S/N 7FC-38N7534EMatta Figueroa Eduardo · Chapman, KSBuilt 1958 · S/N 7FC-243N75365Matthews John D · Land O Lakes, FLS/N 47-825N75369Parker Jeffrey D · Chelsea, ALBuilt 1947 · S/N 47-965N7536ECheslik Michael S · Columbus, OHBuilt 1958 · S/N 7FC-244N75373Prough Steve P · Des Moines, IAS/N 47-1239N7537BParker William Scott · Barnesville, GAS/N 7FC-41N7537EGallaway David P · Albany, ORS/N 7FC-245N7538FSwensen Nathan E · Winnemucca, NVS/N 209-70N7539EPierce Stephan L · Graham, TXBuilt 1958 · S/N 7FC-246N7539FHerkstroeter Caleb · Fairbanks, AKS/N 210-70N753RJMeyer Christopher R · Colchester, CTBuilt 1992 · S/N 693-92N7540ECottrell Mark C · Leitchfield, KYBuilt 1958 · S/N 7FC-247N7540FMeierotto Noah J · Two Rivers, AKBuilt 1969 · S/N 211-70N7541BWestfall James H · Bend, ORS/N 7FC-44N7542EBrasil John I · Lemon Grove, CAS/N 7FC-248N7543EHyde John · Fort Worth, TXBuilt 1958 · S/N 7FC-202N7544FGrundy James W · West Greenwich, RIBuilt 1969 · S/N 284-70N7545BLrh Equipment LLC · Pendleton, ORBuilt 1957 · S/N 7FC-48N7546ELanier Dennis A · Columbus, GABuilt 1958 · S/N 7FC-250N7546FPutman James G · Guntersville, ALBuilt 1969 · S/N 287-70N754ACWillis Norman R · Wilsonville, ORBuilt 1998 · S/N 819-98N7550BPomeroy Jess P · Redding, CAS/N 7FC-52N7551BMcvicker Matt G · Des Moines, IABuilt 1957 · S/N 7FC-53N7552EBouchard Scott A · Medford, WIBuilt 1958 · S/N 7FC-253N7554FJohnson Michael L · Jefferson, TXS/N 206-70N7555ERegistration Pending · Eagle River, AKRegistration pendingBuilt 1958 · S/N 7EC-674
Back to AD 2000-25-02 R1