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.

N60156Shannon School Of Aeronautics LLC · Fredericksburg, VABuilt 1979 · S/N ME-147N6015FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020091N6015LWade Rolla R · Kingsport, TNBuilt 1972 · S/N AA5-0115N6015PWeeks Vaughan B · Racine, WIBuilt 1959 · S/N 24-1110N6015QBohlke LLC · Kingshill, VIBuilt 1979 · S/N ME-141N6015UN6015u LLC · Lakeview, NCS/N M-2135N6015ZOsorio Aviation Corp · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1979 · S/N ME-145N60165Caballero Arturo C · Clute, TXBuilt 1979 · S/N M-2145N6016DWells Roger M · Stratford, TXBuilt 1956 · S/N 22-4669N6016KRamsey Keith W · Morrison, TNS/N MC-646N6016LAssociated Aircraft LLC · San Diego, CABuilt 1975 · S/N 0710N6016PCorson Dana · Helena, MTBuilt 1959 · S/N 24-1111N6016QAbrahem Bishoy · Bakersfield, CABuilt 1965 · S/N 866N6016UAbbasi Babak · Escondido, CABuilt 1979 · S/N ME-156N6016XBeland Michael R · Maiden, NCS/N 1650N6016YClute Jack S · Valparaiso, INBuilt 1979 · S/N MC-650N6016ZPrestenbach Kyle A · Vacherie, LAS/N 25-19N60177Kelley Robert D · Barstow, CABuilt 1969 · S/N 15070126N6017LAviation Training LLC · Wilmington, DEBuilt 2006 · S/N 172S10170N6017NGood Dog Leasing LLC · Vienna, VABuilt 2006 · S/N 172S10171N6017WKarg James R · Paradise, TXBuilt 1964 · S/N 28-20017N6018DBader Ronald W · Montrose, MIBuilt 1956 · S/N 22-4671N6018FAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020092N6018KChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10174N6018QWilson Reed · Arlington, VABuilt 1965 · S/N 868N6018ZWarner Aviation Co · Council Bluffs, IABuilt 2006 · S/N 172S10175N60199Krystofiak Steven · Scottsdale, AZBuilt 1979 · S/N WA-12N6019DKuper Carl J II · Dalhart, TXBuilt 1956 · S/N 22-4672N6019PN6019p LLC · Washington, DCBuilt 1959 · S/N 24-1114N6019VChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 172S10177N6019XRuegg Charles E · Belfast, MEBuilt 2006 · S/N 18281812N601ABFdr601 LLC · Lewiston, IDBuilt 2012 · S/N 6-4994N601BSThird Coast Aircraft LLC · Mobile, ALBuilt 1970 · S/N 28R-35798N601CXRegistration Pending · Marion, TXRegistration pendingS/N 6-4842N601DGJackson Benjamin · Lagrange, GAS/N 63304N601DJMullen James J · Estero, FLBuilt 1980 · S/N 61P07798063392N601DQSilver Eagles Aviation Association · Mesa, AZS/N 60334N601EAExecutive Air Transport Inc · Norton Shores, MIBuilt 1978 · S/N 28-7916124N601FTSanson Paul H · Deland, FLBuilt 1989 · S/N 2841195N601HBPatrick Ronald A · Louisville, KYBuilt 1979 · S/N 61P06467963298N601HCJohnson Timothy R · Owatonna, MNS/N 006N601HHHerman Joseph D · Marion, ILBuilt 2020 · S/N 6-6307N601LANicely Juan · Mount Vernon, KYS/N 1473N601LPMorford Leon R · Rockford, ILS/N 6-5230N601LSM&G Aircraft Management LLC · Englewood, COBuilt 2022 · S/N 172S12853N601MLMahaney James C · Ellijay, GABuilt 2004 · S/N 6-3375N601NGBullard Aviation Services Inc · Ormond Beach, FLBuilt 1980 · S/N 61P07908063402N601NNJones Flying LLC · Helena, MTBuilt 1975 · S/N 61P-0242-039N601NTRegistration Pending · Winter Park, FLRegistration pendingBuilt 1980 · S/N 61P07668063381N601PAMendenhall Michael L · Douglasville, GABuilt 1977 · S/N 17269030
Back to AD 81-18-04 R2