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.

N640QSmythe John J III · Rancho Palos Verde, CABuilt 1959 · S/N D-5926N640TLaughridge Dave · Rugby, NDBuilt 1958 · S/N D-5784N641GWalrabenstein Eric S · Glendale, AZBuilt 1976 · S/N D-9896N641VKomarek Mark C · Stoddard, WIBuilt 1959 · S/N D-6117N6428SWickboldt Michael P · Woodland, CABuilt 1976 · S/N D-9842N642TBambey John J · San Leandro, CABuilt 1958 · S/N D-5466N643DPoole William R · Hilton Head Island, SCBuilt 1951 · S/N D-2908N643QGossett Harold D Jr · Granbury, TXBuilt 1957 · S/N D-5318N643VParis Kyle R · Amarillo, TXBuilt 1959 · S/N D-6261N644DBFolkner Thomas E R · Shelley, IDS/N D-7341N644RCBenkovich Thomas · Hammonton, NJBuilt 1956 · S/N D-4616N644TGier Roberta L · Bozeman, MTBuilt 1957 · S/N D-5380N645DRiggin Flight Service Inc · Madison, SDBuilt 1951 · S/N D-2910N645TWatercut Services Inc · Kilgore, TXBuilt 1958 · S/N D-5634N645VRegistered aircraftBuilt 1960 · S/N D-6276N646QPatrick Robert T · Dothan, ALBuilt 1959 · S/N D-5841N647DKSch Aviation Inc Trustee · Sporle Kings LynnBuilt 1967 · S/N D-8583N647VSparkman Joan F · Murrieta, CABuilt 1960 · S/N D-6280N648DAmberican Aviation Inc · Grand Forks, NDBuilt 1951 · S/N D-2977N648QWarfield Wilbur L · Chambersburg, PABuilt 1959 · S/N D-5879N6499CLux David J · Lamoure, NDBuilt 1956 · S/N D-2911N64CGRobinson James D · Spearfish, SDBuilt 1964 · S/N D-7674N64JWWeaver Joseph Daniel Trustee · Flower Mound, TXBuilt 1957 · S/N D-5014N64PHConklin Diana J · Kirksville, MOBuilt 1964 · S/N D-7496N64PKTom Eaton Consulting LLC · West Sacramento, CABuilt 1964 · S/N D-7526N64RESanocki Erika D · Phoenix, AZBuilt 1964 · S/N D-7670N64VTBonanza Aviation LLC · San Antonio, TXBuilt 1964 · S/N D-7640N650BAsher Mitchell · Senoia, GABuilt 1957 · S/N D-5100N650QSniezek Daniel E · Phoenix, AZBuilt 1958 · S/N D-5796N6525CRegistered aircraftBuilt 1961 · S/N D-6871N652DMob Aviation USA LLC · Kissimmee, FLBuilt 1951 · S/N D-2919N653DPrice Gary E · Cloverdale, CABuilt 1951 · S/N D-2920N654AJVintage Wings Aircraft LLC · Center Point, INBuilt 1964 · S/N D-7474N654DLinde Chase A · Sarasota, FLBuilt 1951 · S/N D-2921N654HRCoats James Michael · Murrieta, CAFirst renewal noticeBuilt 1959 · S/N D-5840N6551CChurch Thomas · Lenoir, NCS/N D-10402N6552VSatellite Airways Ltd · Pella, IABuilt 1967 · S/N D-8623N6553V44hw LLC · Shreveport, LABuilt 1967 · S/N D-8625N6554VXwgnfc LLC · Horsham, PABuilt 1967 · S/N D-8624N655DKhaled Zaky · Parker, COBuilt 1951 · S/N D-2923N655QNickson Ted B · Oneida, TNBuilt 1959 · S/N D-5862N656DBartlett Robert · Cleveland, TXBuilt 1951 · S/N D-2924N656PTSittig Frances M Trustee · Centennial, COBuilt 1959 · S/N D-5910N659QStennett Kevin · Lockney, TXBuilt 1959 · S/N D-5902N659TLucy Donald E III · Newbury Park, CABuilt 1972 · S/N D-9357N65AJAitkens Larry · Port Saint Lucie, FLBuilt 1966 · S/N D-8099N65BWBuzzard Max · Tulsa, OKS/N D-8294N65LVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1966 · S/N D-8238N65SBJarrett Airspray Inc · Jamestown, NDBuilt 1965 · S/N D-7905N65VBCollins Scott W · Upland, CABuilt 1965 · S/N D-7821
Back to AD 94-20-04 R2