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.

N53758Trailing Edge Aviation LLC · Lancaster, PABuilt 1975 · S/N 540-75N53759Pacific Lease · Elk Grove, CABuilt 1981 · S/N 17274814N5375JDaviss Joseph A · Sylacauga, ALS/N 17273768N5375LDerose Kevin L · Janesville, CABuilt 1968 · S/N 28-4681N5375RArctic Flying Club · Fairbanks, AKBuilt 1974 · S/N 17263527N5375WOverly Christopher D · Williamsport, OHBuilt 1962 · S/N 28-440N53763Anderas Per R · Green Bay, WIBuilt 1975 · S/N 875-75N53764Push To Talk Aviation LLC · Burr Ridge, ILBuilt 1975 · S/N 1112-75N53769Holcomb Garry · Greenville, TXS/N 1113-75N5376HPires Fernando L · Hilmar, CAS/N 17265416N5376JTss Aviation LLC · Conyers, GAS/N 17273769N5376PDuffield Michael · Sorrento, FLS/N 24-426N5376WJenkins Walter J · Mayfield, UTS/N 28-441N53772Quale Scott M · New Town, NDBuilt 1975 · S/N 542-75N53773Brock Edwin G · Hawthorne, FLBuilt 1975 · S/N 1114-75N53777Bernabucci Christian J · Mapleton, NDBuilt 1975 · S/N 877-75N5377CAnderson Robert C · Zanesfield, OHBuilt 1977 · S/N 17702623N5377DDesantis Anthony · Memphis, TNBuilt 1979 · S/N 17272552N5377HSchmid Gerhard G · New Smyrna Beach, FLBuilt 1949 · S/N 16-183N5377PRegistration Pending · Litchfield Park, AZRegistration pendingBuilt 1958 · S/N 24-427N5377SHicks James S & Hicks Sally J Edgar Trustee · Oregon City, ORBuilt 1980 · S/N R18201560N5377VShoemake Stephen Sidney · Pine Mountain, GABuilt 1980 · S/N 172RG0517N5377WJackson Timothy J · Hartselle, ALBuilt 1962 · S/N 28-442N5377ZTurner Edward J III · Mokena, ILBuilt 1961 · S/N 22-9139N53781Hayden Aviation LLC · Rhome, TXBuilt 1975 · S/N 1116-75N53785Fox Business Advisors LLC · Mesa, AZBuilt 1975 · S/N 543-75N53787Jones Carl L Jr · Edmond, OKBuilt 1975 · S/N 183-75N5378BDraper Floyd L · El Paso, TXBuilt 1979 · S/N 15283855N5378DMustang Sally Aviation LLC · Camden, SCBuilt 1979 · S/N 17272553N5378ENuxoll Randy G · Eagle, IDBuilt 1978 · S/N 17271841N5378HFellman Peter A · North Chatham, MABuilt 1949 · S/N 16-185N5378KUnique Educational Experiences Inc · Signal Hill, CABuilt 1980 · S/N 17274087N5378LPeterson Dru J · Riverside, CABuilt 1968 · S/N 28-4684N5378WHargis Bookman LLC · Justin, TXBuilt 1962 · S/N 28-443N5378YRagwing Flyers LLC · Richmond, TXBuilt 1964 · S/N 18-8141N53791Maseman Paul A · Tucson, AZBuilt 1975 · S/N 887-76N53794Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274816N53797Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274819N5379SStevens Michael J Trustee · Park City, UTBuilt 1980 · S/N R18201561N5379YHandly William A · Arcola, MSBuilt 1964 · S/N 18-8142N5379ZMcelwee Glenda A · Lake City, FLS/N 22-9146N537APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843760N537ACMacmillan John Jr · Chevy Chase, MDBuilt 2005 · S/N 999-2005N537CCKincaid James B · Hamilton, MTBuilt 2013 · S/N CC18-0061N537CLAckerman Terry L · Brookings, SDBuilt 2001 · S/N 2176N537DMKrakoff Matthew · Massapequa, NYBuilt 1969 · S/N 30-1863N537EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2025 · S/N 172S13305N537FLHanson David Lawrence · Tucson, AZBuilt 1971 · S/N 28-7125367N537HPBarr Air Patrol LLC · Mesquite, TXS/N 18280031N537JHBuffington Matthew Hill · Highlands Ranch, COBuilt 1975 · S/N 533-75
Back to AD 81-18-04 R2