OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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-20-04-R2')
    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-20-04-R2')
  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.

N5394ERusak Robert J · Paris, TXBuilt 1959 · S/N D-5898N5397ECasella David A · Sonoma, CABuilt 1959 · S/N D-5896N53CBCasper Scott A · Middlebury Center, PABuilt 1954 · S/N D-3822N53CMHeath Larry A · Shawnee, OKBuilt 1953 · S/N D-3448N53GMOnawa Flying Service Inc · Sioux City, IABuilt 1968 · S/N D-8793N5400DNablo Dustin · Haddam Neck, CTS/N D-4881N5404DRegistration Pending · Billings, MTRegistration pendingBuilt 1956 · S/N D-4887N5404UHubbard James E · Dover, OHBuilt 1967 · S/N D-8543N5405DKelln David R · Lawton, OKS/N D-4913N5405URyan Good Aviation LLC · Sioux Falls, SDS/N D-8493N5409DDay William L · Seguin, TXBuilt 1957 · S/N D-4912N5410UN5410u LLC · West Babylon, NYBuilt 1967 · S/N D-8531N5411DFellows David O · Mc Alpin, FLS/N D-4903N5413USleigh James E · Palm City, FLBuilt 1967 · S/N D-8498N5414DGlobal Flights LLC · Polk City, IABuilt 1957 · S/N D-4921N5416DCook Clay B · Murfreesboro, TNBuilt 1957 · S/N D-4926N5418DBriggs Larry E · Oklahoma City, OKBuilt 1957 · S/N D-4917N541DBKing Mark R · Oxnard, CABuilt 1964 · S/N D-7333N5420UJohnson Michele J · Buena Vista, COBuilt 1967 · S/N D-8505N5421DFly First LLC · West Memphis, ARBuilt 1957 · S/N D-4932N5422DJohnson Benjamin Keith · Dayton, OHBuilt 1957 · S/N D-4937N542DSFox James R DBA · Saint Paul, MNBuilt 1966 · S/N D-8048N542THoel Erik Gerhard · Redlands, CABuilt 1961 · S/N D-6718N543Onnoh Fred · Oak Harbor, WABuilt 1953 · S/N D-3686N5430DClark Stephen N · Walnut Cove, NCBuilt 1957 · S/N D-4945N5431UBrown David G · Knoxville, TNBuilt 1967 · S/N D-8515N5433DWatkins Lawrence A · San Jose, CABuilt 1957 · S/N D-4946N5433UHynes Kevin P · Wichita Falls, TXBuilt 1967 · S/N D-8512N5434UVance Daniel · Bend, ORBuilt 1967 · S/N D-8520N5435DGoheen Robert Grant · Saint Petersburg, FLBuilt 1957 · S/N D-4944N5436DSeitz Aviation LLC · Hayden, IDBuilt 1957 · S/N D-4964N5438DGanter Lewis C · Sherman, TXBuilt 1957 · S/N D-5016N543TZulu LLC · Hattiesburg, MSBuilt 1961 · S/N D-6737N5442UMorisseau Walner · Tampa, FLBuilt 1967 · S/N D-8516N5444UBooze Gregory Trustee · Punta Gorda, FLBuilt 1967 · S/N D-8518N5445DLabtech Expert LLC · Waycross, GABuilt 1957 · S/N D-4924N5447DN5447d LLC · Seminole, OKS/N D-5001N5449DDavis Roger T · Lakeland, FLBuilt 1957 · S/N D-4935N544VIngle Maurice O III · Claremore, OKBuilt 1965 · S/N D-7904N5450DAirline Holding Co Inc · Wilmington, DEBuilt 1957 · S/N D-4978N5450UStay Air Borne LLC · Wilmington, DEBuilt 1967 · S/N D-8529N5451DRestoration Ministry Inc · Allentown, PAS/N D-5252N5454DLelouis Michael P · Sacramento, CABuilt 1957 · S/N D-4942N545GMInternational Air Services Inc Trustee · Carson City, NVBuilt 1972 · S/N D-9318N545HBeechcraft Heritage Museum Inc · Tullahoma, TNS/N D-4982N545TYoung Trinity D · Mena, ARS/N D-6599N545VSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N D-6321N5461DCenter For Endodontics Inc · Fresno, CABuilt 1957 · S/N D-4966N5463DBlanco Austin · Newcastle, CABuilt 1957 · S/N D-4959N5465DPatten Sarah F · Catlett, VABuilt 1957 · S/N D-4976
Back to AD 94-20-04 R2