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.

N234WBDrake Colin · Mendocino, CABuilt 1969 · S/N D-8952N23542Mrj Aviation LLC · Attica, NYBuilt 1977 · S/N D-10085N2354BHigh Sky LLC · Rogers, ARBuilt 1968 · S/N D-8831N23583Ingersoll David K · Trinity, ALBuilt 1978 · S/N D-10087N235AADifferent Auto LLC · Twin Falls, IDBuilt 1959 · S/N D-5967N235EMcfarland Joel Cable · East Earl, PABuilt 1963 · S/N D-7162N235RRegistered aircraftBuilt 1966 · S/N D-8360N235RDGrady Fun Flying LLC · Grady, OKBuilt 1973 · S/N D-9446N235SLifetime Aviation LLC · Lewes, DEBuilt 1964 · S/N D-7326N23607Green P Stephen · Steamboat Springs, COBuilt 1977 · S/N D-10088N23609Wiebelhaus John J · Strasburg, COBuilt 1978 · S/N D-10089N23674Siebenhaar Harold J · Los Altos, CAS/N D-10146N23685Clements Dennis · Chapel Hill, NCBuilt 1978 · S/N D-10099N23723Kleck Wil · Victoria, TXBuilt 1978 · S/N D-10100N237SColey Douglas E · Mchenry, ILBuilt 1965 · S/N D-7841N2383AAero Traveler Ltd · Warminster, PABuilt 1969 · S/N D-9034N239AASlabach Jason M · Winston Salem, NCBuilt 1961 · S/N D-6763N239SMelton Michael D · Afton, VABuilt 1965 · S/N D-7893N23AGParker Robert B · Trussville, ALBuilt 1975 · S/N D-9834N23DLKnight Robert T · Baton Rouge, LAS/N D-7363N23EPErid Air LLC · Blackfoot, IDBuilt 1954 · S/N D-3858N23RMMurray Michael G · Olathe, KSBuilt 1964 · S/N D-7311N240MBail Air LLC · Port Saint Lucie, FLBuilt 1970 · S/N D-9211N2411Custom Flight Rnh · New Richmond, WIBuilt 1955 · S/N D-4282N24131Hicks Chad A · Dalhart, TXBuilt 1978 · S/N D-10117N24161Diamond Scenery LLC · Red Oak, TXBuilt 1978 · S/N D-10103N24183Smither Tom M · Marietta, GABuilt 1978 · S/N D-10107N24195Barrett Group LLC · Farwell, TXBuilt 1978 · S/N D-10110N242FFThomas Leslie R · Kosse, TXBuilt 1971 · S/N D-9220N242HARounds Agronomy LLC · Pierre, SDBuilt 1961 · S/N D-6626N242MFerrell Alan · Arlington, OHBuilt 1963 · S/N D-7112N242SFCurtin Christopher C · Ashburn, VABuilt 1977 · S/N D-10064N2435ACooper Timothy J · Spearman, TXBuilt 1969 · S/N D-9036N243HEason Michael P · Murfreesboro, TNBuilt 1952 · S/N D-3272N244JNShepherd Jacob · Lake Havasu City, AZBuilt 1964 · S/N D-7698N244LAcevedo Jesus · North Branford, CTS/N D-2747N2458ALeger Bryan · Gulf Breeze, FLBuilt 1969 · S/N D-9038N246EEBaldwin Alexander L · Saint Charles, MOS/N D-6797N246WBToavs Brent J · Wolf Point, MTBuilt 1969 · S/N D-8951N247AAN247aa LLC · Benton, KSBuilt 1959 · S/N D-6034N247BAArizona Wings LLC · Cave Creek, AZBuilt 1960 · S/N D-6391N249BB42m Aviation LLC · Shady Shores, TXBuilt 1979 · S/N D-10318N249EABertsch Paul J · Houston, TXBuilt 1962 · S/N D-7051N24AAGentry Robert L · Tyler, TXBuilt 1955 · S/N D-4285N24AGAegis Air LLC · Columbia City, INBuilt 1979 · S/N D-10293N24JVVan Blarcom John C II · Highland, CABuilt 1972 · S/N D-9337N24LSickels Henry C · El Cajon, CABuilt 1964 · S/N D-7503N24RMTittlemier Warren L · Ventura, CABuilt 1959 · S/N D-5805N24WKCannizzaro Charles DBA · North Syracuse, NYBuilt 1967 · S/N D-8431N250GWasalo And Luby Air LLC · La Fayette, GABuilt 1967 · S/N D-8600
Back to AD 94-20-04 R2