OpenAirDocs.org
AD 94-18-04 R1

Registered aircraft · 1,310

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:94-18-04-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:94-18-04-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.

N3973CRegistration Pending · Independence, ORRegistration pendingBuilt 1953 · S/N 5040N3973HWilliam Shane Jones · Griffin, GAS/N 4674N3976HDubois William · Newtown, PABuilt 1947 · S/N 4677N3977HGaither David G Executor · Houston, TXBuilt 1947 · S/N 4678N3985HReese Jon O · Wichita Falls, TXBuilt 1947 · S/N 4686N3989HAllen Arlan R · Phoenix, AZBuilt 1947 · S/N 4690N3992HHaynes Roger M · Fremont, OHBuilt 1947 · S/N 4693N39TRRapp Timothy · Fairfield, MTBuilt 1947 · S/N 4770N4050JHampton Charles W · Marietta, OHS/N A101N412DPHultzapple Ted D · Farmington, NYBuilt 1946 · S/N 2057N4151Stapleton Halley S · Brownsville, TXS/N 3003N415AShemwell Carl R · Clinton, MIBuilt 1946 · S/N 321N415BZDaley Lige W · Carlinville, ILBuilt 1946 · S/N 693N415CDRoehm David L · Leesburg, OHBuilt 1947 · S/N 4523N415CPStrannard David L · Sacramento, CABuilt 1946 · S/N 1704N415DRHughes Keith A · Ormond Beach, FLBuilt 1946 · S/N 784N415FWMiller Frank · Statesboro, GABuilt 1946 · S/N 315N415GWebber Gregory W · Nyssa, ORBuilt 1949 · S/N 5052N415GPWebb David W · Jupiter, FLS/N 667N415JC1st Resources Unltd Inc · Houston, TXS/N 3728N415LLBawtinheimer Kris · Grand Rapids, MIBuilt 1946 · S/N 1221N415PTFlying Angel LLC · Bismarck, NDBuilt 1946 · S/N 1707N415RGGregory Vernon L · Swansea, SCBuilt 1961 · S/N 864N415SS1st Resources Unltd Inc · Houston, TXFirst renewal noticeBuilt 1947 · S/N 4776N415TBLeuthold Mike · Concord, CABuilt 1946 · S/N 1612N41889Bair Zach · Memphis, TNS/N 119N423LFChirtea John · Milton, DEBuilt 1965 · S/N A-15N433APetty Clifford C · Cedar Hill, TXS/N 4615N43832Knutson Wayne R · Thompson, NDS/N 178N43LEFlying Colors Air Parts Inc · Leesburg, FLBuilt 1946 · S/N 352N4500MBaty Russell L · Sheridan, MTBuilt 1946 · S/N 3708N464MEMaas Russell J · Gleason, WIBuilt 1946 · S/N 2977N48EStransky Theodore J · Newburgh, INBuilt 1946 · S/N 3328N499TTMackentepe Zandra Paige · Vinemont, ALS/N 4664N49GBloemker Edward L · Fremont, NEBuilt 1946 · S/N 426N500BKFriest Eric J · Menomonie, WIBuilt 1946 · S/N 442N505TFlaherty Patrick · Cincinnati, OHBuilt 1970 · S/N 700048N51DVBennett Gabriel J C · Hillsboro, ORBuilt 1946 · S/N 2024N525SLFlying Smiles LLC · Land O Lakes, FLBuilt 1946 · S/N 1374N529LMcclain Donald H · Pasadena, TXBuilt 1946 · S/N 498N52WTParks Stephen · Hollidaysburg, PABuilt 1970 · S/N 700045N5300MArnold Jackson E · San Diego, CAS/N A-201N5452FRients Randall T · Virginia Beach, VABuilt 1967 · S/N B-252N5455FHoye Charlie L · Rimrock, AZBuilt 1967 · S/N B-255N5457FWehrly Phoenix O · Elbow Lake, MNBuilt 1967 · S/N B-257N5458FMorgan Scott E · Allen, NEBuilt 1967 · S/N B-258N5459FDavis James A · Astoria, ORBuilt 1967 · S/N B-259N5461FMeade Larry G · Tallahassee, FLBuilt 1967 · S/N 690001N5464FTiger Flight Foundation Inc · Rome, GABuilt 1967 · S/N B-264N5473ESitta Donald C · Farmington, NMBuilt 1965 · S/N A-7
Back to AD 94-18-04 R1