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.

N4259BRucker Paul D · Roanoke, VABuilt 1955 · S/N D-4236N425MGGrinnan Michael · Stafford, VAS/N D-7813N4260BWall Robert J Jr · Clanton, ALS/N D-4237N4260DBrownlee Craig · Knoxville, TNBuilt 1956 · S/N D-4474N4263DMartin Scott A · Lizton, INBuilt 1956 · S/N D-4477N4265BSmith Steven C · Orting, WABuilt 1955 · S/N D-4242N4266DCureton Tony G · Port Huron, MIBuilt 1956 · S/N D-4486N4268BKallhoff Mark · Canby, MNBuilt 1955 · S/N D-4241N4268DDangberg Dennis C · Wayne, NES/N D-4494N426KXCoulman Michael A · Highland Village, TXBuilt 1962 · S/N D-7067N426RWolff Phillip R · Highlands Ranch, COBuilt 1952 · S/N D-3188N4270DKliewer Silas M · Ulm, MTBuilt 1956 · S/N D-4490N4271DPc Aviators LLC · Oklahoma City, OKBuilt 1956 · S/N D-4496N4272SSchechter Stuart · Great Neck, NYBuilt 1976 · S/N D-9959N4275SEvergreen Aviation LLC · Franktown, COBuilt 1977 · S/N D-9961N4279DAlsaeed Mokhtar · Monroe, WAS/N D-4483N427PWLangford Stephen C · York, SCBuilt 1976 · S/N D-9850N427TCag Farms Inc · Angier, NCBuilt 1963 · S/N D-7232N42800Asbury William J · Fresno, CABuilt 1976 · S/N D-9934N4280SYoung Daniel R · Germantown, TNBuilt 1976 · S/N D-9969N4281DConnell Seth · Little Rock, ARBuilt 1956 · S/N D-4499N4282BYaws Larry · Amarillo, TXBuilt 1955 · S/N D-4345N4283BSale Reported · Oklahoma City, OKSale reported, pending cancellationBuilt 1955 · S/N D-4344N4284BPhilcox Kenneth J · Milton, DEBuilt 1955 · S/N D-4258N4285BChisum Robert · Lorenzo, TXS/N D-4262N4285DUrbina Mario A · Pacoima, CAS/N D-4512N4286DRegistration Pending · Kaplan, LARegistration pendingBuilt 1956 · S/N D-4505N4287BDeffner Gerhard Paul Heinrich · Mckinney, TXS/N D-4361N428KRLilly James D · Columbia, MDBuilt 1972 · S/N D-9306N428TLJoe Rushing Plumbing Co Inc · Lubbock, TXBuilt 1967 · S/N D-8632N4290BDelyser Dwight G · Upland, CABuilt 1955 · S/N D-4253N4291BElk River Equipment LLC · Elkview, WVS/N D-4249N4292BFreeman Bobby Keith · Grove, OKBuilt 1955 · S/N D-4354N4293BSima Bary J · Salome, AZBuilt 1955 · S/N D-4355N4294BFull Stop Aviation LLC · Union City, TNBuilt 1955 · S/N D-4356N4294DPreisse Gene L · Akron, OHS/N D-4503N4295BHanna Ryan Dale · Berthold, NDBuilt 1955 · S/N D-4362N4295DRutherford Albert II · Baker, LABuilt 1956 · S/N D-4514N4297BBass Steven W · Elbert, COBuilt 1955 · S/N D-4245N4298DKumle Kreations LLC · Libby, MTS/N D-4541N4299BBorger Jimmy L · Lafayette, LABuilt 1955 · S/N D-4261N4299DOverseas Aviation Inc · Wilmington, DEBuilt 1956 · S/N D-4521N42ABGallaway Michael T · Dallas, TXBuilt 1965 · S/N D-7935N42LBRigney Timothy D · Troy, VABuilt 1970 · S/N D-9140N42WKMariash Cary Norman · Indianapolis, INBuilt 1964 · S/N D-7390N42XRegistration Pending · Grandfield, OKRegistration pendingBuilt 1951 · S/N D-2825N4301WNash Matthew · Edmonds, WABuilt 1974 · S/N D-9578N4302WDagenhart Ronald Jason · Westerville, OHBuilt 1974 · S/N D-9582N4310SVelk Vincent F · Havre, MTBuilt 1975 · S/N D-9773N4312WBreitbarth Brian · Canby, ORBuilt 1974 · S/N D-9585
Back to AD 94-20-04 R2