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.

N66977Unique Educational Experiences · Signal Hill, CABuilt 1978 · S/N 15281699N6697DAtlanta Aviation Academy Inc · Lawrenceville, GABuilt 1979 · S/N ME-264N6697JGlenn Larry W · Bunn, NCBuilt 1968 · S/N 28-24390N6697PTri County Air Courier LLC · Prosper, TXBuilt 1960 · S/N 24-1822N6697RJ Bar Ranch LLC · Downey, IDBuilt 1964 · S/N 440N66985Reid Robert W III · Independence, ORBuilt 1942 · S/N 8272N6698HNational Test Pilot School · Mojave, CABuilt 1979 · S/N ME-273N6698QBrager Robert L · Oxnard, CABuilt 1983 · S/N M-2391N6699Jcmc Inc · Junction City, KSBuilt 2005 · S/N 90512N6699JRegistration Pending · Loup City, NERegistration pendingBuilt 1968 · S/N 28-24393N6699LPierce Jeffrey D · Woodinville, WABuilt 1971 · S/N 462N6699SBeach Coleen W · Moncks Corner, SCS/N M-2225N6699UGuy Carlo A · Ramona, CABuilt 1963 · S/N 2426N669ALeppert James J · Dickey, NDBuilt 1951 · S/N 22-71N669AKRegistered aircraftBuilt 1954 · S/N 18-3324N669AMForry Anthony · Athens, TNBuilt 2003 · S/N 20-1025N669BCPhantom Holdings LLC · Lexington, NEBuilt 2007 · S/N 103N669CEOne Pft LLC · Denton, MTBuilt 1992 · S/N 787N669CPEmerald Isle Apartments LLC · Los Angeles, CABuilt 2021 · S/N 1481-2021N669CRIrizarry Betsy M · Mayaguez, PRBuilt 1966 · S/N 32-349N669DKBrunner Matthew W · Bellingham, WAS/N 21076CN669EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12554N669FGMustang Sally Aviation LLC · Camden, SCBuilt 2007 · S/N 172S10616N669GBBernardi Gary R · New Cumberland, PABuilt 1982 · S/N 28-8211031N669KPClink Andrew D · Phoenix, AZBuilt 1978 · S/N AA5A0701N669NEAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1981 · S/N 15285368N669PMKohl Rex · Eden Prairie, MNBuilt 2015 · S/N 1161N669RVN669rv LLC · New Albany, INBuilt 2025 · S/N 91055N669RWRhodes Brian W · Valdez, AKS/N 001N669SHulick Kent · Houston, TXBuilt 1996 · S/N 7095N669SMClearance Clarence Aviation LLC · Hallsville, TXBuilt 2003 · S/N 21245N669SNKajans Douglas L · Reno, NVBuilt 2014 · S/N 91844N669TJBouyea John M · Hillsboro, ORBuilt 2004 · S/N 90749N669TMDirty Bird Helicopters LLC · Boerne, TXBuilt 2002 · S/N 1233N669TWAlmanor Express LLC · Palo Alto, CABuilt 2002 · S/N 172S9066N669UShartle Austin W · Fredericksburg, PABuilt 1982 · S/N 2265N669WBBailey Donnie W Jr · Tyronza, ARBuilt 2026 · S/N 93356N669XDiehl Steven K · Homestead, FLBuilt 1966 · S/N 68N66AALift Aviation LLC · Kingston, MABuilt 1977 · S/N 17270025N66AJPalmer Paul H · Minden, LAS/N 555AN66AKDomke Daniel C · Fairbanks, AKBuilt 1981 · S/N 1017N66ALXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 44-7995200N66APPeterson Alex A · Ottertail, MNBuilt 2001 · S/N 23209N66AUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2010 · S/N 20119N66AWSg Aviation Inc · Clearwater, FLBuilt 2001 · S/N 3200N66AZVia International Inc · Reunion, FLBuilt 1995 · S/N 11221N66BHLj Air LLC · Ada, MIBuilt 1979 · S/N 32-7940067N66BRPierce Stephan L · Graham, TXBuilt 1978 · S/N 983N66CDKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1996 · S/N 1215-96N66CFFuller Leonard C · Mattawa, WABuilt 2020 · S/N 21566
Back to AD 81-18-04 R2