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.

N7249BBlack James A · Las Vegas, NVBuilt 1958 · S/N D-5577N724MCachorro Cattle Co · Granbury, TXBuilt 1962 · S/N D-7006N724SN724s LLC · Bloomsdale, MOBuilt 1962 · S/N D-7004N7250BBaird William B · Aurora, ILBuilt 1958 · S/N D-5586N7253BWateractive43 LLC · Auburn, CAS/N D-5583N725ADSisson David Brent · Lubbock, TXBuilt 1979 · S/N D-10281N725APSheets Douglas · Goodyear, AZS/N D-10178N725DAndrews Christopher · Parker, COBuilt 1951 · S/N D-2995N725YFiumara Joseph A · Lake Havasu City, AZBuilt 1962 · S/N D-7036N7260BWheatley Albert W · Wilmington, DEBuilt 1958 · S/N D-5601N7264BRutter David · Downers Grove, ILBuilt 1958 · S/N D-5613N7267BInnovative Aviation Services Inc · Newnan, GABuilt 1958 · S/N D-5641N726DRodriguez Gustavo · Pearland, TXS/N D-2996N7271BHanks Donald V · Camp Verde, AZBuilt 1958 · S/N D-5626N7272BD O K Aero Inc · Wayland, MIBuilt 1958 · S/N D-5621N7273BJ35 Aviation LLC · Wichita, KSBuilt 1958 · S/N D-5625N7274BWildingwood Grove LLC · West Bend, WIBuilt 1958 · S/N D-5643N7274RChastain Phillip L · St Louis, MOBuilt 1975 · S/N D-9721N7277BRoberts Nathan W · Cleveland, OHBuilt 1958 · S/N D-5631N7278BWilkins William B · Mayodan, NCBuilt 1958 · S/N D-5623N727CBDwr Aviation Enterprises LLC · Vero Beach, FLBuilt 1979 · S/N D-10313N727EGTalor Darrell T · Dawsonville, GAS/N D-9676N727QReinhard Ryan B · Hillsboro, TXBuilt 1956 · S/N D-4595N727VDli Aviation LLC · St George, UTBuilt 1958 · S/N D-5552N7280BClk Aviation LLC · Henderson, NVBuilt 1959 · S/N D-5635N7282BArsuf LLC · Missoula, MTS/N D-5644N7285BEasy Pz Aviation LLC · Monroe, GABuilt 1958 · S/N D-5647N7286RHulands Gregory G · Eagle Point, ORS/N D-9724N7289BMotown Inc · Fort Worth, TXBuilt 1958 · S/N D-5649N728HMSchott Brian M · Hayward, CABuilt 1951 · S/N D-2983N7293BBealmear Travis Lane · Fort Collins, COS/N D-5655N7294BKelley Robert D · Barstow, CAS/N D-5656N7295BBonanza Flyers Inc · Sioux City, IABuilt 1958 · S/N D-5658N7296BChaney Paul A · Oklahoma City, OKBuilt 1958 · S/N D-5659N729TJurskis Chester · Dallas, TXBuilt 1964 · S/N D-7690N7300UZimmerman Kyle A · Philadelphia, PABuilt 1953 · S/N D-3449N7301BFowler Kenneth R · Cleveland, ALBuilt 1954 · S/N D-3765N7302BDangberg Dennis · Wayne, NES/N D-3763N7303BRegistration Pending · Enterprise, ALRegistration pendingS/N D-3766N7305BDennerline Jeff · Fairview, ORS/N D-3768N7307BWatkins Todd Michael · Midland, TXBuilt 1954 · S/N D-3770N730SMStockmans Inc · Visalia, CAS/N D-10009N7310BDaniels Alfred K · League City, TXBuilt 1955 · S/N D-4166N7311BB A M N Air Inc · Naples, FLS/N D-4202N7312BKomishock Matthew A · Conyngham, PABuilt 1954 · S/N D-3775N7313BPena Edwin A · Mission Hills, CAS/N D-3776N7314BKuskie Donald D · Littleton, COBuilt 1954 · S/N D-3777N7315BKomon Antonio · Apple Valley, CABuilt 1954 · S/N D-3778N7316BVolkl Joseph E · Ava, MOBuilt 1954 · S/N D-3779N7318BGonzales Gabriel J · The Dalles, ORBuilt 1954 · S/N D-3781
Back to AD 94-20-04 R2