AD 81-18-04 R2

Registered aircraft · 81,733

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:81-18-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:81-18-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.

N9910LClingan Charles F · Huddleston, VABuilt 1973 · S/N AA1B-0210N9910QTevebaugh Dennis J · Elkhart, KSBuilt 1975 · S/N 17265854N9910USky West Aviation Inc Trustee · Albuquerque, NMS/N AA5A0310N9910YBaumgartner Larry C · Roseau, MNBuilt 1962 · S/N 7GCB126N9911QAeronautical Technical Service Inc · Collierville, TNS/N 17265855N9911RMatijas Robert J Jr · Homer, NYBuilt 1960 · S/N TD-390N9911USandlapper Venutures Inc · Walhalla, SCBuilt 1977 · S/N AA5A0311N9911WCategory One Aviation LLC · Atascadero, CABuilt 1967 · S/N 28-23433N9911YTyrrell Luke L · Fairbanks, AKS/N 120N9912DAssociated Property And Business Services LLC · Myrtle Beach, SCS/N 16001CN9912LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276648N9912QKd Aviation LLC · Sheridan, WYBuilt 1975 · S/N 17265856N9912TLang Robert H · Pittsburgh, PABuilt 1978 · S/N 38-78A0241N9913UThomason David F · Poplar Grove, ILBuilt 1977 · S/N AA5A0313N9913WJcl Equipment Rental · Coleta, ILBuilt 1967 · S/N 28-23434N9913XReinhardt Brent · Collierville, TNS/N 3RX117N99141Airgo Inc · Centralia, ILBuilt 1985 · S/N 17276409N9914ESimica Charles A · Marietta, GABuilt 1979 · S/N 17272288N9914LFlex Air Holdings Inc · Manhattan, KSBuilt 1986 · S/N 17276649N9914QVictor Aviators Inc · Kernersville, NCBuilt 1975 · S/N 17265858N9914SSheffield Robert A · Mooresville, NCBuilt 1967 · S/N 28-23672N9914UBroderick James Edward · Baltimore, MDBuilt 1977 · S/N AA5A0314N9914WYellow Bird Flying Club · Toledo, OHBuilt 1967 · S/N 28-23435N9914YKnapper Jack A · Hibbing, MNBuilt 1961 · S/N 7GCB-112N99157Hess Garrett J · Fullerton, CABuilt 1985 · S/N 17276412N9915BTaro Investment LLC · Doral, FLBuilt 1982 · S/N 172RG1078N9915LHelton James A · Loudon, TNS/N AA1B-0215N9915TRobinson Christopher Cody · Richmond, KYBuilt 1978 · S/N 38-78A0245N9915UBest Oren · Sunfield, MIBuilt 1977 · S/N AA5A0315N9915WAlimardani Shahrakh · Aguanga, CABuilt 1967 · S/N 28-23436N9916DUeeck Brett · Anchorage, AKBuilt 1959 · S/N 18-6958N9916LMauppins Braden · West Memphis, ARBuilt 1973 · S/N AA1B-0216N9916TRogers Greg · Las Vegas, NVBuilt 1978 · S/N 38-78A0246N9916WCulp Mason J · Bonney Lake, WABuilt 1967 · S/N 28-23438N99171Airlake Aero Inc · Lakeville, MNBuilt 1985 · S/N 17276414N9917QStill Flying LLC · Gibsland, LABuilt 1975 · S/N 17265861N9917WFlydunn.Com Inc · Jacksonville, FLBuilt 1967 · S/N 28-23439N9918DSnow Peter T Jr · Mcgrath, AKBuilt 1959 · S/N 18-6960N9918EByrne Evan A · Mountain Lake Park, MDBuilt 1979 · S/N 17272289N9918FChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 17280194N9918LMeggitt Daniel J · Beaufort, NCBuilt 1973 · S/N AA1B-0218N9918QCerqueira Luiz Fernando · Orem, UTBuilt 1975 · S/N 17265862N9918TBertrand Jeff J Trustee · Willow, AKBuilt 1987 · S/N 7491CN9918USpencer Robert E · Independence, ORBuilt 1977 · S/N AA5A0318N9919BPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N 172RG1080N9919QBlomstrom Andrew R · Oregon, WIBuilt 1975 · S/N 17265863N9919TFour M Aviation LLC · Saint Petersburg, FLBuilt 1994 · S/N 3213075N9919UFuller Michael D · Columbia, MDBuilt 1977 · S/N AA5A0319N991AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843807N991ABSand Benjamin P · Koloa, HIBuilt 1980 · S/N WA-79
Back to AD 81-18-04 R2