OpenAirDocs.org
AD 67-31-04

Registered aircraft · 1,732

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-31-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-31-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.

N1016JRoberts Nettie R · Bowling Green, KYBuilt 1968 · S/N 15068595N101DPStancy Marc A · Crystal Lake, ILBuilt 1967 · S/N 15067860N104FDDippolito Michael M · Norristown, PABuilt 1968 · S/N 15068727N104JVPryor Michael C · Riverview, FLBuilt 1967 · S/N 15066392N105DPPulscher Brian J · Sand Springs, OKBuilt 1968 · S/N 15068960N10FPLoves Park Air LLC · Loves Park, ILS/N 15068636N10RHGoodson David · Millbrook, ALBuilt 1967 · S/N 15066306N113NDFox Flight Instruction LLC · Jacksonville, FLBuilt 1967 · S/N 15067823N11YSBonanza N5745v LLC · Colorado Springs, COBuilt 1968 · S/N 15068608N1213RMorgan Robert · Ozark, MOBuilt 1967 · S/N 15064627N125AWWaterwings Seaplanes LLC · Hoover, ALBuilt 1967 · S/N 15066417N1308UCarson Danny L · Oneida, TNBuilt 1966 · S/N 15065444N130HJJaynes Grayson V · Burnet, TXS/N 15068617N137ESWhobrey Andrew T · Bee Spring, KYBuilt 1967 · S/N 15067212N13DRSchuler Edward A Jr · Hamden, CTBuilt 1966 · S/N 15064816N146JHGodinez Mauricio U · San Diego, CAS/N 15066426N14AUBazzo Richard J · Broadview Heights, OHBuilt 1967 · S/N 15064814N150CGRomano Brian P · Terryville, CTBuilt 1967 · S/N 15066615N150CMDunn James W · Otis, MES/N 15066599N150CVMmdt Aero LLC · Worthington, OHBuilt 1966 · S/N 15065496N150ETjelta Peter A · Sheyenne, NDBuilt 1967 · S/N 15066502N150EMArman Michael P · Oak Hill, FLBuilt 1967 · S/N 15066362N150EWGlazier Matthew S · Presque Isle, MEBuilt 1968 · S/N 15068457N150FTLevine Albert E · Bloomfield, CTS/N 15065352N150GRSoaring For Christ LLC · Big Lake, AKS/N 15066875N150HRFeliciano Carlos A · Adjuntas, PRBuilt 1967 · S/N 15067248N150HVExperimental Aircraft Association Inc · Oshkosh, WIS/N 15066657N150JWSheely Kevin L · Lima, OHBuilt 1966 · S/N 15065680N150KNMiller Kirk E · Ellendale, NDS/N 15066897N150KPRegester Stephen J · Roan Mountain, TNBuilt 1966 · S/N 15065795N150LK92nd West Aviation Inc · Lonoke, ARBuilt 1966 · S/N 15065029N150NVAltom Chase S · Medford, ORBuilt 1968 · S/N 15069140N150PCMills Timothy L · Powell, OHBuilt 1967 · S/N 15066257N150PEAviator Air Flight School LLC · Grand Prairie, TXBuilt 1966 · S/N 15065823N150SWN W Aviators Inc · Troutdale, ORBuilt 1968 · S/N 15068868N150WTJenson Greg R · Pueblo, COS/N 15065949N163LASimeon Sound LLC · Aguilares, TXBuilt 1967 · S/N 15067645N165FCPocono Mountains Flying Club Inc · Tobyhanna, PAS/N 15064575N165LADicairano Gerard J · Salisbury, MDBuilt 1967 · S/N 15066156N16771Tintman Inc · Spokane, WAS/N 15066452N181VVScriva Jennifer L · Sherwood, ARBuilt 1966 · S/N 15065010N192PMScheib Michael A · Dauphin, PABuilt 1967 · S/N 15067467N1KBThibault Ryan D · Anchorage, AKBuilt 1967 · S/N 15067470N200RXAndrews Laral B · Portland, ORS/N 15067073N209TOnele Dennis E · Central City, NES/N 15068531N22001Fisher Robert G Jr · Hodges, SCBuilt 1967 · S/N 15068000N22003Hall David D · Des Moines, WAS/N 15068002N22009Dundon Nick · Bozeman, MTBuilt 1967 · S/N 15068006N22014Sun Valley Aviation Inc · Harlingen, TXBuilt 1967 · S/N 15068010N22016Kiehle Ingrid E · Anchorage, AKS/N 15068012
Back to AD 67-31-04