OpenAirDocs.org
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.

N236JNDickerson Bradley D · Jasonville, INBuilt 1979 · S/N 28-7911081N236JPLauderdale Thomas J · Bates City, MOBuilt 1970 · S/N E-211N236MGGeorgia Aviation Authority · Eastman, GABuilt 2025 · S/N 2881984N236MHMillion Air Aviation LLC · Queen Creek, AZBuilt 1981 · S/N 28-8211009N236MKAllford John · Mcalester, OKBuilt 1979 · S/N 28-7911321N236MMFunkhouser Robert Scott · The Woodlands, TXBuilt 2003 · S/N E-3514N236MTPiper Aircraft Inc · Vero Beach, FLS/N 4496659N236NCIal Corp · Lewes, DES/N 28-8311022N236NYCivil Air Patrol Inc · Maxwell Afb, ALS/N 17268975N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116N236PAGreene James · Hudson, SDBuilt 1978 · S/N 28-7816679N236PDHeitz Kenneth Joe · Boynton Beach, FLBuilt 1979 · S/N 28-8011029N236PMCummings Ralph L · Rmv, CABuilt 1982 · S/N 28-8211032N236PRConnecticut Flyers Inc · Madison, CTBuilt 1979 · S/N 28-7911272N236RCCarter Rodney D · Artesia, NMBuilt 1983 · S/N R18201963N236RMConrad Harold M · Sugar Grove, ILBuilt 1979 · S/N EA-43N236SRb Aviation Enterprise LLC · Palm City, FLBuilt 2004 · S/N E3555N236SHAir 2 Sea LLC · Martin, TNBuilt 1979 · S/N 28-7911169N236TCCka Investments LLC · Fernandina Beach, FLBuilt 1979 · S/N EA-23N236TTPoole Mark · Meriden, CTBuilt 1981 · S/N 32R-8113110N236WBt1 Air LLC · Grover Beach, CABuilt 2002 · S/N E-3432N236ZKMaximum Ceiling Aviation LLC · Farmingdale, NYS/N 2843401N2370DPoeppelman Philip W · Versailles, OHBuilt 1952 · S/N 20522N2370GJ H Nicklas Inc · Cartersville, GABuilt 1958 · S/N 51670N2370UWatts Keith R · Chapel Hill, TNBuilt 1963 · S/N 17249970N23714Dyk Aviation LLC · Williston, NDBuilt 1978 · S/N E-1206N23717Advanced Helicopter Services · Woodland, CABuilt 1978 · S/N E-1208N2371CMathers John R · Denton, TXBuilt 1953 · S/N 30671N2371ETmc Shooting Range Specialist Inc · Valencia, CAS/N 17271254N2371RBudell Stacey M · Caldwell, IDBuilt 1964 · S/N 18255471N2371TThomas Jacob W · Loris, SCS/N 28-7225056N2371XCouch Sue A · Dewy Rose, GABuilt 1965 · S/N 18256271N23723Kleck Wil · Victoria, TXBuilt 1978 · S/N D-10100N23724Zhang Harvest Land · Moraga, CABuilt 1978 · S/N E-1211N2372CMartin Land Improvement Inc · Elk Rapids, MIBuilt 1978 · S/N R18200164N2372DTucker Matthew T · Dillingham, AKS/N 20524N2372GJohnson David B · Santa Barbara, CABuilt 1958 · S/N 51672N2372USky View Aviation LLC · Lenoir, NCBuilt 1962 · S/N 17249972N2372XRegistered aircraftBuilt 1965 · S/N 18256272N2373CDs Flight Services LLC · Battle Ground, WABuilt 1978 · S/N R18200165N2373FRlo Aviation LLC · Double Springs, ALBuilt 1965 · S/N 21058573N2373TNeuharth Randall H · Norfolk, NEBuilt 1971 · S/N 28-7225003N2373UBeeline Aviation LLC · Austin, TXBuilt 1962 · S/N 17249973N2374CJackson Jeffrey D · Elk City, OKBuilt 1978 · S/N R18200166N2374GAirco International LLC · Everett, WAS/N 51674N2374TFlying High Investments LLC DBA · Winnemucca, NVBuilt 1971 · S/N 28-7225017N2374UEstes Kenneth · Benton, KSBuilt 1962 · S/N 17249974N2374XMorrison Aircraft · Harrisburg, ARS/N 18256274N23752Talton David S · Tupelo, MSBuilt 1978 · S/N E-1215N23753Lifestyle Aviation LLC · Dallas, TXBuilt 1978 · S/N CE-762
Back to AD 98-21-21 R1