AD 98-21-21 R1

Registered aircraft · 85,612

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.

N2580RFlight Club Academy LLC · Palmetto Bay, FLBuilt 1969 · S/N 28-5650N2580SArizona Production Machinery & Supply · Casa Grande, AZBuilt 1976 · S/N 21061333N2580WLewis Kyle Walker · Trenton, TXBuilt 1965 · S/N 937N2581CClepper Catherine M · Saegertown, PABuilt 1954 · S/N 26225N2581DMccullugh Jordon T · Idaho Falls, IDBuilt 1952 · S/N 20733N2581KYsc Inc · Harvard, MABuilt 1978 · S/N 18053002N2581WClay Shelli V · Savannah, GABuilt 1965 · S/N 938N2581YOverman Aviation LLC · Saint Louis, MOS/N 17249881N2582DFriesen Gary J · Mariposa, CABuilt 1952 · S/N 20734N2582KSherman David B · Readfield, MEBuilt 1978 · S/N 18053003N2582LRichardson Michael Todd · Wilkesboro, NCS/N 17255782N2582Q82q LLC · Glenwood, MDS/N 18257782N2582RBergmann Robert A · Lake Placid, FLBuilt 1967 · S/N 18258282N2582VThul Nathan Michael Trustee · Centralia, IABuilt 1948 · S/N 18087N2582WPetersen Bennett David · Ashland, OHBuilt 1965 · S/N 3277N2582ZChandler Air Service Inc · Chandler, AZBuilt 1980 · S/N 27-8154004N2583CWarner Mitchel K · Kodiak, AKS/N 26227N2583GN2583g LLC · Madison, KSBuilt 1959 · S/N 51883N2583LMontgomery Robert A · Hampstead, NCBuilt 1967 · S/N 17255783N2583RHigh Range Aviation Inc · Gooding, IDBuilt 1967 · S/N 18258283N2583SMackowiak Michael · Haines, AKBuilt 1973 · S/N 18502250N2583UUfly Vi LLC · St Thomas, VIBuilt 1963 · S/N 17250183N2583WRuckel Daniel A · Floyds Knobs, INBuilt 1965 · S/N 3278N2583XN2583x LLC · Oklahoma City, OKBuilt 1965 · S/N P206-0083N2584CMoreman Wiley E · Willcox, AZBuilt 1954 · S/N 26228N2584KEichorn Russell A · Grand Rapids, MNBuilt 1978 · S/N 18053005N2584URedd David C · Blanding, UTBuilt 1963 · S/N 17250184N2585CGillum Colton M · Ontario, ORBuilt 1954 · S/N 26229N2585GWilkinson Benjamin M · Anchorage, AKS/N 51885N2585LAerospace Quality LLC · Piggott, ARS/N 17255785N2585RChristie Bruce W · Wasilla, AKBuilt 1967 · S/N 18258285N2585ULionudakis Michael A · Scotts Valley, CABuilt 1963 · S/N 17250185N2585WClassic Mooney Nv LLC · Henderson, NVBuilt 1965 · S/N 940N2586LRuiz Edinson · Bakersfield, CABuilt 1967 · S/N 17255786N2586QErrington Aero LLC · Bellefontaine, OHBuilt 1966 · S/N 18257786N2586SCasey Aviation Inc · Mansfield, MAS/N 17252809N2586UMaynor Roy · Brazoria, TXS/N 17250186N2586WVizinat David C · Ragley, LABuilt 1965 · S/N 941N2586XPiper Kffc LLC · Peachtree City, GABuilt 1985 · S/N 28-8690003N2587UEt Flight LLC · Cedar Park, TXBuilt 1963 · S/N 17250187N2587WOrourke Timothy L · Laguna Niguel, CABuilt 1965 · S/N 3279N2588MN-J Aviation LLC · Forest, VAS/N 32R-7880066N2588QDlp Ventures LLC · North Platte, NEBuilt 1977 · S/N 28R-7703070N2588RPoplin Tristan · Frisco, TXBuilt 1967 · S/N 18258288N2588WJohnson Mitchell R · Bismarck, NDBuilt 1965 · S/N 3280N2588ZBindon Philip E · Wasilla, AKBuilt 1963 · S/N 185-0588N2589GPreisse Gene L Jr · Akron, OHBuilt 1959 · S/N 51889N2589QMolek Eugene · Warren, OHS/N 18257789N2589VGraveson John W · Uxbridge, MABuilt 1948 · S/N 18094N2589WHart Christian L · Highland Village, TXBuilt 1965 · S/N 942
Back to AD 98-21-21 R1