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.

N57777Thorsgard Keith A · Mcville, NDBuilt 1978 · S/N 18-7809094N5777LSessums David L · Seabrook, TXBuilt 1969 · S/N AA1-0177N5777UFossa Matthew A · Pensacola, FLBuilt 1969 · S/N 28-26601N5777VDe La Garza Jimmy · Granbury, TXBuilt 1966 · S/N MA-29N5777WMaschek Anothony Q · Killeen, TXBuilt 1964 · S/N 28-1585N57787Shoultys Shawn P · Denali Park, AKBuilt 1977 · S/N 18-7709131N5778PHunton Hugh R II · Midlothian, TXBuilt 1959 · S/N 24-857N5778QPars Avn Corp · Wilmington, DEBuilt 1965 · S/N 3091N5778VGlenn Larry D · Reynoldsburg, OHBuilt 1966 · S/N MA-37N5778ZWhelan Cynthia Vs · Seneca, SCBuilt 1963 · S/N 22-9623N57792Arizona Game & Fish Dept · Phoenix, AZBuilt 1977 · S/N 18-7709132N5779DAltenburg Scott J · Anchorage, AKBuilt 1956 · S/N 18-5295N5779FScheer Abraham · Milton, DEBuilt 1968 · S/N 28-25085N5779HKelly David L · Pendleton, ORBuilt 1949 · S/N 16-395N5779PLechner Kevin P · Wurtsboro, NYBuilt 1959 · S/N 24-858N5779ZSvec Adolph R · Marengo, ILBuilt 1963 · S/N 22-9624N577AUBeck Patrick · Algonquin, ILBuilt 2015 · S/N 18282370N577BASpitzer Helicopter LLC · Woodland Hills, CABuilt 2002 · S/N 1163N577CMEllison Ranching Co · Elko, NVBuilt 1977 · S/N 18-7709134N577DPLustfeldt Gordon L · Normal, ILBuilt 1959 · S/N 24-848N577EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13091N577FAN577fa LLC · Redondo Beach, CABuilt 2004 · S/N 172S9577N577FCFlight Club · Middle River, MDS/N WA-43N577FGRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S13079N577FLMorsi Sameh M · Pomona, CABuilt 1971 · S/N 28-7125428N577JLJaj Aviation LLC · Plano, TXS/N 577N577MBBlalock James M · Sheridan, ARBuilt 1988 · S/N MB-1N577NDAir Shares LLC · Casper, WYBuilt 2010 · S/N 172S10986N577SPTexas State Technical College · Waco, TXBuilt 2000 · S/N 172S8503N577TMoore Eric C · Cave Creek, AZBuilt 1988 · S/N 01N577TZWestbank Fishing LLC · Kiln, MSBuilt 2002 · S/N 18281123N577ZZRubey Arthur C · San Antonio, TXBuilt 2024 · S/N 4903N5780FAces Aviation LLC · Laurel, MTS/N 28-25087N5780HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1949 · S/N 16-393N5780PWall Scott · Franksville, WIBuilt 1959 · S/N 24-859N5780QMuegge Erik L · Keller, TXBuilt 1965 · S/N 3092N5780WSmoyer Justin L · Slatington, PABuilt 1964 · S/N 28-1657N5780ZBergstrom Robert L · Amelia Court House, VABuilt 1963 · S/N 22-9625N57816North Texas Dusters & Sprayers Inc · Gainesville, TXS/N 36-7660122N5781FRegistered aircraftBuilt 1968 · S/N 28-25088N5781QFranklin Mountain Group Corp · Nashville, TNBuilt 1965 · S/N 749N5781WPietras Aaron E · Franklin, INBuilt 1964 · S/N 28-1658N5782FMission Aviators LLC · Spring, TXBuilt 1968 · S/N 28-25089N5782HTomas Douglas J · East Troy, WIBuilt 1949 · S/N 16-397N5782JN5782j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273835N5782PPaviation LLC · Lewes, DEBuilt 1959 · S/N 24-861N5782QSkylions LLC · Wichita, KSBuilt 1965 · S/N 3093N5782VDave Sheets And Sons Contracting Inc · Columbia City, INBuilt 1966 · S/N MA-41N5782WDavis Clinton · Baldwin City, KSBuilt 1964 · S/N 28-1659N5783FBate Eric D · Vancouver BcBuilt 1976 · S/N 28-7725066
Back to AD 81-18-04 R2