OpenAirDocs.org
AD 67-26-04

Registered aircraft · 5,934

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

N10007Insko Matthew T · Papillion, NEBuilt 1966 · S/N 21058839N1000LWise Joe · Kilgore, TXBuilt 1966 · S/N TC-1000N1007F007 Aviation LLC · Wilmington, DEBuilt 1968 · S/N TC-1163N100DZSkydive Santa Barbara LLC · Lompoc, CABuilt 1966 · S/N U206-0693N100GMHuguenard Jefferson J · Alpharetta, GABuilt 1968 · S/N TC-1183N100KFAlbrecht Douglas D · Hobart, INBuilt 1966 · S/N 18257496N100MRCarlson Carl J II · Aledo, TXBuilt 1973 · S/N TC-1512N100SFSafe Flight Instrument LLC · White Plains, NYBuilt 1979 · S/N TC-2211N100VBKindlimann Charles T Jr · Trout Run, PABuilt 1966 · S/N 3552N100ZZArbuckle George A · Poolville, TXBuilt 1975 · S/N TC-1922N1010FHangar 10 Aviation LLC · Durant, OKS/N 1403-145N101TLojek Donald W · Boise, IDBuilt 1964 · S/N 2887N1021CRiener Clinton G · Cottonwood, IDBuilt 1966 · S/N 18257409N1028WArt Air Partners LLC · Louisburg, NCBuilt 1973 · S/N TC-1533N102JJGrose Christopher E · San Antonio, TXBuilt 1966 · S/N T210-0123N102RRMoyer Aviation Ll C · Katy, TXS/N 1477-5N102SHScotts Helicopter Services Inc · Le Sueur, MNBuilt 1971 · S/N 7762N1037VPulse Jeremy D · Moore, MTBuilt 1968 · S/N 18051989N103NJUsda Forest Service Fepp · Trenton, NJBuilt 1969 · S/N 361N1042RSale Reported · Los Angeles, CASale reportedBuilt 1971 · S/N TC-1414N1045WButler Richard S · Poplar Grove, ILBuilt 1973 · S/N TC-1535N1047W1047w LLC · Oakland, TNBuilt 1973 · S/N TC-1536N104JVPryor Michael C · Riverview, FLBuilt 1967 · S/N 15066392N104NRMiller Dale D · Eagle River, AKBuilt 1966 · S/N 18051693N104PBMountain Flight LLC · Missoula, MTBuilt 1974 · S/N 20-0035N104PMPats Offroad Inc · Mitchell, SDS/N 18258085N1050VState Of Wisconsin · Madison, WIBuilt 1968 · S/N 18051966N105RDSunny Slope Aviation LLC · Adams, TNBuilt 1967 · S/N 17256221N1060WHarvey Ara Jr · Hernando, MSBuilt 1973 · S/N TC-1539N106RGCadena Edward R Jr · Houston, TXBuilt 1966 · S/N 18257535N106ZZBrown Helicopter Inc · Pensacola, FLBuilt 1970 · S/N 508N1071TChambliss Aviation Services LLC · Greer, SCBuilt 1976 · S/N TC-2002N107VCLopez Hidaldo Vicente · San Juan, PRBuilt 1960 · S/N 893-1N108JHInternational Air Services Inc Trustee · Carson City, NVS/N TC-1530N1092WAmerican Aviation LLC · Waterville, MEBuilt 1973 · S/N TC-1549N10ADTeerlink Randall S · Hanover, VABuilt 1976 · S/N 20-1221N10ARK Airmotive LLC · St Helens, ORBuilt 1966 · S/N U206-0738N10GMAlo Aviation LLC · Titusville, FLS/N T210-0151N10RHGoodson David · Millbrook, ALBuilt 1967 · S/N 15066306N110FBElon Aviation LLC · Burlington, NCBuilt 1976 · S/N TC-2024N110WBFerrin Aviation LLC · Rome, GABuilt 1962 · S/N 500B-1203-98N11102Fly Right Aviation LLC · Anderson, SCBuilt 1965 · S/N 3351N1116TImg Management Services Corp · Wapwallopen, PABuilt 1968 · S/N TC-1127N1118TFriend Air Care Inc · Washington, PABuilt 1964 · S/N TC-813N111FGHahn Derrick J · Combine, TXS/N TC2026N111KFColorado Jet Solutions Inc · Conifer, COBuilt 1964 · S/N TC-633N111MJJohn D Chinchen Md Pa · Mountain Home, ARBuilt 1968 · S/N 680147N111PDN111pd LLC · Wilmington, NCBuilt 1978 · S/N TC-2176N111PQTriple Nickel Inc · Muleshoe, TXBuilt 1972 · S/N TC1427N111PWKilgore Eric M · Genoa, NVS/N T210-0066
Back to AD 67-26-04