AD 98-21-21 R1

Registered aircraft · 85,620

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:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  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.

N19LLDsr-Cherokee 180 LLC · Dallas, TXBuilt 1970 · S/N E-224N19MAAvco Security Systems Inc · Jupiter, FLBuilt 1966 · S/N D-8173N19MBDg Aircraft LLC · Lemont Furnace, PAS/N 34-7970031N19MJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N U20605372N19MNShields Charles F · Gilberts, ILBuilt 1978 · S/N E-1347N19MTDaviation Inc · Willoughby, OHBuilt 1976 · S/N E798N19NSTurney Dwight C · Fort Worth, TXBuilt 1990 · S/N 24-1705-14N19PAAkradi Parviz Trustee · Laguna Niguel, CABuilt 1977 · S/N 28R-7803129N19PEN19pe LLC · Stone Mountain, GABuilt 1978 · S/N 32R-7885068N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44N19RDDennison Ronald Walton Trustee · San Jose, CABuilt 1966 · S/N 24-4597N19REEtcheverry Ray L · Bakersfield, CABuilt 1970 · S/N CE-299N19RFLynn Air Flying Club Inc · Woodinville, WABuilt 1974 · S/N E-627N19SASierra Aviation LLC · Hendersonville, TNBuilt 1980 · S/N E-1795N19SERegistered aircraftBuilt 1968 · S/N 28R-30525N19SLMifflin Enterprises LLC · Mansfield, OHBuilt 1976 · S/N D-9848N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629N19TPTwv Air LLC · Ewing, NJBuilt 1978 · S/N 34-7870383N19TWDougherty Peter I · Orchard Park, NYBuilt 1953 · S/N 30119N19VChoi Mark · Allentown, PABuilt 1977 · S/N E-1107N19VSGardner James R · League City, TXFirst renewal noticeBuilt 1963 · S/N 30-144N19VTBeauchamp James W · Corapeake, NCBuilt 1962 · S/N 28-400N19WWood Alton K · Bee Spring, KYS/N D-3734N19WBPacific Wildfire Enterprises LLC · Wilmington, DES/N P21000761N19WCV35a LLC · Beacon, NYBuilt 1969 · S/N D-8998N19WERlv Industries Inc · Westerly, RIBuilt 1997 · S/N 3449037N19WGCorpat Inc · Missoula, MTS/N 162821N19ZBBruton Kevin L · Roseburg, ORBuilt 1959 · S/N 55732N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478N1AVLeader Nicholas A · Billings, MTBuilt 1962 · S/N TC-366N1AWKoedam Robert E · Saint Louis, MOBuilt 1960 · S/N D-6617N1AXEdgerton Agency Inc · Galena, OHBuilt 1960 · S/N 47418N1BFRussell Kellum LLC · Saratoga, CABuilt 1973 · S/N TE-961N1BPPatton Ministries · Grand Rapids, MNBuilt 1961 · S/N 18253260N1BWMbs Ventures Inc · Wilmington, DEBuilt 1977 · S/N D-9963N1CKWilson Nick · Glenwood, ILBuilt 1966 · S/N CE-30N1CNNothing By Chance LLC · Jackson, WYBuilt 1967 · S/N TE-313N1DJOwyhee Air LLC · Murphy, IDBuilt 1987 · S/N CE-1116N1DNWarren Howard E · Cookeville, TNBuilt 1949 · S/N D-1967N1DUPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1960 · S/N DH-262N1DZXtreme Flying Services LLC · Gansevoort, NYBuilt 1961 · S/N 18253742N1EHandschiegel Robert J · Hampshire, ILBuilt 1976 · S/N 17267046N1EVGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1979 · S/N E-1463N1FHBuermann Henry · Brookfield, VTS/N 18052817N1FXTl Consulting LLC · Cadiz, KYBuilt 1963 · S/N TC-406N1GLSmith Alfred N D IV · Lake Wylie, SCBuilt 1967 · S/N 27-3826N1HBRye-Corp LLC · Lenoir City, TNBuilt 1968 · S/N TC-1069N1JDAero Aircraft 10 LLC · Jacksonville, FLBuilt 1972 · S/N 34-7250103N1JHHolden James E · Las Vegas, NVBuilt 1975 · S/N 17265723N1JJChrapczynski Daniel T · Sheffield Village, OHBuilt 1972 · S/N 30461
Back to AD 98-21-21 R1