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.

N808RKGoehl Jeffrey A · College Station, TXBuilt 1974 · S/N 28-7415225N808SJPiper Skylor B · Pls Vrds Est, CABuilt 2010 · S/N 81888N808TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881701N808TYRowberry Spencer D · Grantsville, UTBuilt 1965 · S/N 30-831N808UFMahoney Clinton D · Tecumseh, NEBuilt 1975 · S/N 17264869N808VRFrank Daniel W · Lees Summit, MOBuilt 2002 · S/N 80856N808VTInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 28R-7737051N808WDJones Colby C · Honolulu, HIBuilt 1972 · S/N 28R-7235270N808WTSchool Board Of Leon County Florida · Tallahassee, FLBuilt 2008 · S/N 1990N808ZStephens William C · Wilmington, NCBuilt 2004 · S/N 81471N808ZTDepartment Of Homeland Security · Washington, DCBuilt 2005 · S/N 20608236N80903Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1946 · S/N 306N80906Red Door Aviation LLC · Dover, DEBuilt 1976 · S/N 17266796N80908International Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 28-8016074N80909Kirkman Todd · Port Charlotte, FLBuilt 1946 · S/N 312N8090ELeslie H Mcelhany DBA · Watertown, SDBuilt 1979 · S/N 28-8016072N8090FDouglas Malik · Mcdonough, GABuilt 1976 · S/N 28-7790233N8090JWesellairplanes.Com Inc · Wilmington, DEBuilt 1978 · S/N 6005767961187N8090LWilliams Chris B · Reno, NVBuilt 1979 · S/N 28-8090092N8090YFlyin Gators LLC · New Smyrna Beach, FLBuilt 1979 · S/N 28-7911323N80912Bay Area Concrete LLC · Hayward, CABuilt 1976 · S/N 17266798N80914Cp Aviation Inc · Santa Paula, CABuilt 1976 · S/N 17266799N8091COlson Christian A · Hayward, WIBuilt 1954 · S/N 22-2237N8091DJohnston Zach H · Soldotna, AKS/N 18-6086N8091EChristiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 172-75486N8091GWood Kim W · Tucson, AZBuilt 1971 · S/N 177RG0091N8091PWaggoner Robert A · Decatur, TXBuilt 1962 · S/N 24-3340N8091RParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016077N8091WClement Timothy S · Skidmore, MOS/N 28-2182N8091XBlack Hunter F · Blanding, UTBuilt 1966 · S/N 28-21777N8091YStevens Charles R · Williamsburg, MIBuilt 1979 · S/N 28-8016079N80921Conerly Group LLC · Denham Springs, LABuilt 1976 · S/N 17266803N80926Flight Leasing Corp · Wilmington, DEBuilt 1979 · S/N 28-8090098N80928Bellingham Aviation Services LLC · Bellingham, WABuilt 1976 · S/N 17266804N8092ERaleigh Flying Club LLC · Chapel Hill, NCBuilt 1979 · S/N 28-8090093N8092GEarly Stephen · Sharpsburg, GABuilt 1979 · S/N 28-8090095N8092HUnited States Air Force Owner · Hanscom Afb, MABuilt 1979 · S/N 28-8016082N8092NCash Management Consulting LLC · Granite Springs, NYBuilt 1968 · S/N 28-25335N8092WDidea Aviation LLC · Orlando, FLBuilt 1965 · S/N 28-2183N8092YStoks Gary R · Canby, MNBuilt 1966 · S/N 30-1210N80931Augusta Aviation Inc · Augusta, GABuilt 1976 · S/N 17266806N80934Cogelia Joseph M · Winchester, VABuilt 1979 · S/N 28-8090105N80939Levin Joseph · Yukon, OKBuilt 2005 · S/N 60497N8093DSmith Ihler M · Fairbanks, AKBuilt 1957 · S/N 18-6084N8093GFargo Jet Center LLC · Fargo, NDBuilt 1979 · S/N 28-8090100N8093HSarraf Majid · Aliso Viejo, CABuilt 1979 · S/N 28-8090101N8093NSaraland High School · Saraland, ALS/N 28-25336N8093PFly Boyz LLC · Black Hawk, SDBuilt 1962 · S/N 24-3342N80941Holombo Ray J · Taylors, SCBuilt 1976 · S/N 17266810N8094AMuhlenberg Barry Vk · Pottstown, PABuilt 1982 · S/N 32R-8213030
Back to AD 81-18-04 R2