OpenAirDocs.org
AD 99-26-05

Registered aircraft · 2,960

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:99-26-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-26-05')
  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.

N1004HSmtm Holdings Inc · Wilmington, DEBuilt 1976 · S/N 28-7715301N1008XSmith Dan V · Anchorage, AKBuilt 1975 · S/N 28-7515373N101GNGreat Northern Aircraft Inc · Griffith, INBuilt 1976 · S/N 28-7615214N101KWWiseman Ken L DBA · Calhoun, GABuilt 1980 · S/N 28-8016310N1024HBellville Timothy L · Toledo, OHS/N 28-7715302N1026XLopp Russell · Yukon, OKBuilt 1975 · S/N 28-7515375N102DEUniversal Aviators Academy Inc · El Monte, CABuilt 1976 · S/N 28-7615418N1033XHorizon Enterprises LLC · Kalispel, MTBuilt 1975 · S/N 28-7515376N1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079N103JKWise Charlie S · Norfolk, VABuilt 1974 · S/N 28-7415271N103SAHolman Steven R · Vero Beach, FLBuilt 1983 · S/N 28-8416012N1040XRacette Robert J Jr · Vienna, WVBuilt 1975 · S/N 28-7515377N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081N1047HMagel James · Fox River Grove, ILS/N 28-7715303N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286N104FGWilson Conrad · Bowdon Junction, GAS/N 28-7716292N104TBMclear Robert C · Rock Hill, SCBuilt 1973 · S/N 28-7415010N104VADulles Aviation Inc · Bristow, VABuilt 2001 · S/N 2842115N1053HKoehn Danny · Montezuma, KSBuilt 1976 · S/N 28-7715304N1064XActive Pilot Inc · Van Nuys, CABuilt 1975 · S/N 28-7515309N1067YMerino Anthony S · Springville, CABuilt 1974 · S/N 287415020N1068HJudd Gary F · Bend, ORBuilt 1976 · S/N 28-7715305N1076XMarston Lester J · Ukiah, CABuilt 1975 · S/N 28-7515383N107MRMeriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7816251N107NDN107nd LLC · Wilmington, DEBuilt 1989 · S/N 2841214N1080HAll2fly LLC · Atlanta, GAS/N 28-7715306N108AVDavis Robert S · Keystone Heights, FLBuilt 1974 · S/N 28-7415573N108NDMavity Michael D · Phoenix, AZBuilt 1990 · S/N 2841328N1093XRoseville Aviation LLC · Roxboro, NCBuilt 1975 · S/N 28-7515386N109GPCash Management Consulting LLC · Granite Springs, NYBuilt 1977 · S/N 28-7816287N1103XHolmgren Joel A · Chisago City, MNBuilt 1975 · S/N 28-7515388N1107HShurtz William W Jr · Medford, ORBuilt 1977 · S/N 28-7715308N1108HAdk Flying Club Inc · Ballston Spa, NYBuilt 1976 · S/N 28-7715309N1108XThompson Trisha L · Clearwater, KSBuilt 1975 · S/N 28-7515389N110JA3mw Farms Inc · Hallock, MNBuilt 1974 · S/N 28-7515135N110VPFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7716189N1118QAscend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716083N1121XCrosscheck Ftc LLC · Greeneville, TNBuilt 1975 · S/N 28-7515316N112TPHarper Gary B · Fitzgerald, GABuilt 1977 · S/N 28-7716289N113EJIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7715075N113KRIal Corp · Lewes, DEBuilt 1974 · S/N 28-7415211N1140QLuken Henry G III · Chattanooga, TNS/N 28-7716086N1150XVenture North Aviation LLC · Cloquet, MNBuilt 1975 · S/N 28-7515394N1158HOs Flight LLC · Double Springs, ALS/N 28-7715311N1161HEngert Armin L · Kahului, HIBuilt 1976 · S/N 28-7715312N1163XPerry Curtis · Klamath Falls, ORS/N 28-7515396N116AVValleortiz Hector J · Laurel Hill, NCBuilt 1984 · S/N 28-8416094N1181HAdams Dustan David Sr · Houma, LAS/N 28-7715313N1185HJcaviator LLC · Matthews, NCS/N 28-7715314N1190HBergman William George · Muskegon, MIBuilt 1977 · S/N 28-7716002
Back to AD 99-26-05