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.

N4316DPaulsen James · Lafayette, INBuilt 1956 · S/N D-4712N4317WMurray Patrick G · Moraga, CABuilt 1974 · S/N D-9587N431SPMoreno Jose J · Irvine, CABuilt 1961 · S/N D-6799N4321EHarper Henry Jr · Mesquite, NVS/N D-8868N4321SBeech Peak Aviation LLC · Boulder, COBuilt 1964 · S/N D-7512N4322WSnell Steve · Scotts Valley, CABuilt 1974 · S/N D-9589N4325DRegistered aircraftBuilt 1956 · S/N D-4565N433DReyenga Steven G · Shreveport, LABuilt 1966 · S/N D-8094N433LCarolina Warbirds LLC · Patuxent River, MDBuilt 1961 · S/N D-6850N433SBesedin Thomas E · Islandia, NYBuilt 1965 · S/N D-8006N4340WHanger Aviation Inc · Charleston, SCBuilt 1974 · S/N D-9577N4342AR&B Air LLC · Clayton, MOBuilt 1970 · S/N D-9133N434LQualitair LLC Trustee · MichelstadtS/N D-8694N435RMBryant Lyle W · Ellinwood, KSBuilt 1963 · S/N D-7258N435WMSewell David E · Humble, TXS/N D-4350N4366WPrentice Chris · Independence, ORBuilt 1974 · S/N D-9620N436EButcher Gregory E · Pensacola, FLBuilt 1964 · S/N D-7532N436JB700p LLC · Lewes, DEBuilt 1976 · S/N D-9884N436TYoung Robson Terry · Kirkland, ILBuilt 1963 · S/N D-7240N4376WSmith Ryan · Canby, ORBuilt 1974 · S/N D-9626N437EMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1966 · S/N D-8179N4388WNiezen Henry J · San Luis Obispo, CABuilt 1974 · S/N D-9600N438TBluhm Raymond M · Waxhaw, NCBuilt 1971 · S/N D-9256N439RRRandel Ron L · Greeley, COBuilt 1958 · S/N D-5389N43ABV Tail Flyers Llp · South Lyon, MIBuilt 1959 · S/N D-5838N4405AJohnson Marvin E · Garfield, WABuilt 1970 · S/N D-9141N4405DTorea Alex C · Hastings On Hudson, NYBuilt 1956 · S/N D-4519N4407DLessley Aviation LLC · Carrollton, MSBuilt 1956 · S/N D-4537N4408DMurphy Michael L · Sylvia, KSBuilt 1956 · S/N D-4554N440DDeeble Kenneth M · Dayton, MTBuilt 1964 · S/N D-7461N440GVon Pasecky Ronald · Gilbert, AZBuilt 1976 · S/N D-9911N440LAParks David W · Ithaca, NYBuilt 1957 · S/N D-5257N440QB&T Aviation LLC · Columbia, SCBuilt 1964 · S/N D-7410N4410DHunt James W · Maryville, TNBuilt 1956 · S/N D-4572N4418ABorchert Pete · Prescott, AZBuilt 1970 · S/N D-9142N4418DRam Air Inc · Presque Isle, MIBuilt 1956 · S/N D-4545N4419AMccants Robley D · Mesa, AZS/N D-9147N4419DSzostak Edward M · San Diego, CABuilt 1956 · S/N D-4558N4420DEyre Matthew R · Prescott, AZBuilt 1956 · S/N D-4592N4423DHowell Richard M · Boone, IAS/N D-4524N4426DSmith Glen R · Tracy, MNBuilt 1956 · S/N D-4526N4427DThomas Albuzat Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1956 · S/N D-4568N4427WRockwall LLC · Wye Mills, MDBuilt 1974 · S/N D-9605N4429DReeves Thomas W · Issaquah, WABuilt 1956 · S/N D-4550N4430WMagerit Aviation Inc · South Boston, MABuilt 1974 · S/N D-9609N4431WUnited Roofing Of Central Florida Inc · Ocala, FLBuilt 1974 · S/N D-9606N4432ABrown David L · Gold Hill, NCBuilt 1970 · S/N D-9144N4432DRalston Michael J · Calhoun, GABuilt 1956 · S/N D-4561N4434LMarr Geoffrey M · Colorado Springs, COBuilt 1956 · S/N D-4600N4435DHelfrich Jeffrey A · Hood River, ORBuilt 1956 · S/N D-4577
Back to AD 94-20-04 R2