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.

N1871DTiehen James P · Huntington Beach, CABuilt 1952 · S/N D-3181N1873LJanzen Mark · Chico, CABuilt 1976 · S/N D-9892N1875DJohnson Clayton D · Desert Hot Springs, CAS/N D-3118N18760Twinfin LLC · Port Orange, FLBuilt 1977 · S/N D-10070N1880DAdams Marvin R · Peyton, COBuilt 1952 · S/N D-3151N1880LSouth Regional Aviation Enterprise · Boynton Beach, FLBuilt 1976 · S/N D-9894N1881DHerrell Lynn K · Wichita, KSS/N D-3153N1885WS35s LLC · Stevens Point, WIBuilt 1973 · S/N D-9485N1889DKish James D · Centennial, COBuilt 1952 · S/N D-3161N188RJWilliams Debbie C · Riverside, CABuilt 1963 · S/N D-7205N1890DBrott Edwin T · Cincinnati, OHBuilt 1952 · S/N D-3173N1891DDale Richard C · La Vernia, TXS/N D-3163N1892DLong Jory J · Lake Ozark, MOBuilt 1952 · S/N D-3164N1892LMcnair Craig · Dayton, TXBuilt 1976 · S/N D-9897N1894DAiken Wayne B Jr · Greenville, SCBuilt 1952 · S/N D-3166N1896DBrabender Michael R · Montevideo, MNBuilt 1952 · S/N D-3168N1897EThompson Loren Charles · Arlington, VABuilt 1966 · S/N D-8313N18998Duffer Management LLC · Carlsbad, CABuilt 1977 · S/N D-10073N189AAJungclaus Karl F · Piedmont, SDBuilt 1959 · S/N D-6024N18TUCheck Seven LLC · Champaign, ILBuilt 1967 · S/N D-8450N18WPPacker William M · Orchard Lake, MIBuilt 1966 · S/N D-8125N1901DSouder Kasey Wayne · Longview, TXS/N D-3178N1903DToby Aviation Inc · Pigeon Forge, TNBuilt 1952 · S/N D-3180N1903LN1903l LLC · Jacksonville, FLBuilt 1976 · S/N D-9900N1904Howard Stephen R · Augusta, GABuilt 1951 · S/N D-2914N1904DVaughn Ben E · Knoxville, TNBuilt 1952 · S/N D-3157N1904LJones William D · Argyle, TXBuilt 1963 · S/N D-7174N1906DHenning James N · Mc Daniels, KYBuilt 1952 · S/N D-3184N1909L52 Foxtrot Aviation LLC · Billings, MTBuilt 1976 · S/N D-9901N190QMcgilvray Saxon · Helena, MTBuilt 1964 · S/N D-7551N190RTChopper Aviation LLC · Cahokia Heights, ILBuilt 1954 · S/N D-3799N1912DHynes Ryan · Peoria, AZS/N D-3162N1914DAdams Lawrence H · Prescott, AZBuilt 1952 · S/N D-3143N1915DAtterberry Charlie G · Rockwall, TXBuilt 1952 · S/N D-3152N1919DWarren Wesley L · Coeur D Alene, IDBuilt 1952 · S/N D-3191N191AAPelz Thomas G · Boscobel, WIBuilt 1959 · S/N D-5914N191BCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1956 · S/N D-4517N191GA5056 Bonanza LLC · Tulsa, OKBuilt 1957 · S/N D-5056N191YPlatte Valley Air LLC · Columbus, NEBuilt 1966 · S/N D-8172N1920DHunt James W · Maryville, TNBuilt 1952 · S/N D-3192N1921DBrickhouse Aviation LLC · Franklin, TNS/N D-3193N1926DKoosmann Mark R · Corcoran, MNBuilt 1956 · S/N D-3198N1927DHawksworth Jeff · Laveen, AZS/N D-3199N192AAReardon Michael J · East Falmouth, MABuilt 1959 · S/N D-5964N192BSlater Patrick · Glasgow, KYS/N D-4790N1930DFletcher Ellexis L · Corpus Christi, TXBuilt 1952 · S/N D-3203N1935DCoppage Walter J · Wichita Falls, TXBuilt 1952 · S/N D-3209N1938DPlane Crazy Aviation LLC · Hickory, NCBuilt 1952 · S/N D-3214N1942DFrancis David L · Fort Worth, TXBuilt 1952 · S/N D-3219N1943DHartman Dylan · Avon, INBuilt 1952 · S/N D-3221
Back to AD 94-20-04 R2