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.

N2315CRegistered aircraftBuilt 1953 · S/N 30615N2315DFeher Eugene A · Greenwich, NYBuilt 1952 · S/N 20467N2315FRed Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1964 · S/N 21058515N2315GClark Jeffrey E · Tiburon, CABuilt 1958 · S/N 51615N2315TFaraone Nicholas Robert · Saint Petersburg, FLBuilt 1971 · S/N 28-7125499N2315XParker Ronald Lewis · Melissa, TXBuilt 1965 · S/N 18256215N2316CTwo Wings LLC · Anchorage, AKBuilt 1953 · S/N 30616N2316FTip Of The Tusk Aviation LLC · Siloam Springs, ARBuilt 1965 · S/N 210-58516N2316KAverett University · Danville, VABuilt 2010 · S/N 2843683N2317GOrion Aviation LLC · Edmond, OKS/N 21061485N2317MHilton Head Flyers LLC · Liberty, SCBuilt 1977 · S/N 28-7816277N2317SSokoloff James T · Cambridge, MAS/N E-3117N2317TShirley Aviation LLC · Alexandria, VABuilt 1971 · S/N 28R-7135208N2317VMay-Collier Aviation LLC · Atlanta, GABuilt 1998 · S/N E-3164N2317XSproul Wendell C · Hermon, MEBuilt 1965 · S/N 18256217N2318ATarpley Gary H · Seaford, VABuilt 1997 · S/N E-3118N2318CWebster Robert C · East Jordan, MIBuilt 1953 · S/N 30618N2318FBe Dozer LLC · Guy, ARS/N 21058518N2318GRedmond John R · Reno, NVS/N 51618N2318RJigamian Geoffrey T · Temecula, CABuilt 1964 · S/N 18255418N2318TBenedict James C II · Douglasville, GABuilt 1971 · S/N 28-7125567N2319FDelaney Patrick J · Marion, TXBuilt 1964 · S/N 21058519N2319GSkydive Co · Fairburn, GABuilt 1958 · S/N 51619N2319SHotel Whiskey Aviation LLC · San Antonio, TXBuilt 1976 · S/N 21061245N2319TJensen Betty K · Ithaca, NYBuilt 1971 · S/N 28-7105212N2319UGriffin Edward L · Bowling Green, KYBuilt 1962 · S/N 17249919N231ACHinsdale Jeffrey M · Ionia, NYBuilt 1979 · S/N 25-0043N231AEJda Properties LLC · Stillwater, MNBuilt 1979 · S/N 25-0054N231AFPistora Steven R Trustee · Lindsborg, KSBuilt 1979 · S/N 25-0064N231AGQualitair LLC Trustee · MichelstadtBuilt 1979 · S/N 25-0062N231AJFrimodig James P · San Diego, CABuilt 1979 · S/N 25-0082N231AKKab Flyers LLC · Greenville, ILBuilt 1979 · S/N 25-0085N231ALBaryon Aero LLC · Culver City, CABuilt 1979 · S/N 25-0089N231APHoneyland Inc · Wolf Point, MTBuilt 1979 · S/N 25-0093N231AQHenslee Christopher S · Grass Valley, CABuilt 1979 · S/N 25-0103N231ARMabry Danny W · Morehead, KYBuilt 1979 · S/N 25-0095N231ASSkousen Joel M · Spring City, UTBuilt 1979 · S/N 25-0106N231ATMuncy Donald A · Corinth, TXBuilt 1982 · S/N 25-0686N231AURouw Bruce · Leesburg, FLBuilt 1979 · S/N 25-0098N231AYDelgado Erick · Tucson, AZBuilt 1979 · S/N 25-0099N231AZSpirit Aviation N231az LLC · Austin, TXBuilt 1979 · S/N 25-0120N231BBlue River Holdings LLC · Hugo, OKBuilt 1956 · S/N D-4651N231BADykstra Darren J · Pacific Grove, CAFirst renewal noticeBuilt 1979 · S/N 25-0073N231BCFlying Elite Inc · Wilmington, DEBuilt 1979 · S/N 25-0112N231BDNicholls Samuel H · Brookfield, ILS/N 25-0180N231BGWojteczko Jason A · Derby, KSBuilt 1978 · S/N 25-0015N231BHStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1981 · S/N 25-0579N231BLSolethium Lc · Jonesboro, ARS/N 25-0117N231BMLee Judy K · Nashport, OHBuilt 1979 · S/N 25-0071N231BNTaylor Kent S · Watford City, NDBuilt 1979 · S/N 25-0083
Back to AD 98-21-21 R1