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.

N55094Remedy Aviation LLC · Langford, SDBuilt 1973 · S/N 28-7325322N55096Robinson Jeffrey M · Scottsboro, ALBuilt 1973 · S/N 28-7305311N5509FAhs Aero LLC · Leo, INS/N 28-24850N5509JJet Air Inc · Iowa City, IABuilt 1980 · S/N 17273810N5509QCarlson Jeremy Nathaniel · Arnold, CABuilt 1965 · S/N 2943N5509WKitts John L · New Braunfels, TXBuilt 1962 · S/N 28-597N550DBHarding Mason · Phoenix, AZBuilt 1992 · S/N 539N550DEJanay Jesse A · Charlottesville, VABuilt 1998 · S/N 2656N550EEEidal Peter M · Kent, WABuilt 2014 · S/N 82123N550ERCoco Aircraft Inc · Merritt Island, FLBuilt 2007 · S/N 172S10531N550FLKennedy Adam B · Des Moines, WAS/N 28-7125387N550JSBawk Aviation LLC · Xenia, OHBuilt 1977 · S/N R18200105N550LAOscar Tango LLC · Mesa, AZBuilt 2017 · S/N 172S12045N550NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10992N550PWhitmus Christopher A · Bowie, TXBuilt 2003 · S/N 3114N550PEHeller Ross S · Gig Harbor, WAS/N 550N550PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842106N550WHAlligator Inc · Lawrence, KSBuilt 1989 · S/N HAMSA/ROHDE0001N5510FHughes Arlen L · Saratoga, WYBuilt 1968 · S/N 28-24851N5510QN407ml LLC · Wilmington, DEBuilt 1965 · S/N 608N5510WMilius Douglas L · Oshkosh, WIBuilt 1962 · S/N 28-598N55115Gleason Ronald L · Willows, CAS/N 28-7305313N55116Stick And Rudder Aviation LLC · Hale, MOBuilt 1973 · S/N 28R-7335182N55117Smathers Jason R · Redwood City, CABuilt 1973 · S/N 28-7310116N5511ABuller Paul W · Laguna Hills, CABuilt 2002 · S/N 23076CN5511FSmith Jimmy A Jr · Albemarle, NCBuilt 1968 · S/N 28-24852N5511GQualitair LLC Trustee · MichelstadtBuilt 2001 · S/N 26014CN5511PGear Down Hangar LLC · Phoenix, AZBuilt 1958 · S/N 24-574N5511QJohnston Evan · Yakima, WABuilt 1965 · S/N 2944N55121Lifetime Adventures LLC · Bellevue, MIBuilt 1981 · S/N 17275114N55124Stroud Stephen D · Independence, MOS/N 28-7325329N55126Zing Aviation And Marine LLC · New Smyrna Beach, FLFirst renewal noticeBuilt 1981 · S/N 17275116N55127Lands James M · Stoutsville, OHBuilt 1973 · S/N 28-7305314N55129Bauer Roger · Saint Germain, WIBuilt 1973 · S/N 28-7305319N5512CGayle William G · Harpersville, ALBuilt 2001 · S/N 18076CN5512FWestergaard Wayne B · Craig, NEBuilt 1968 · S/N 28-24854N5512JWhitaker Robbie L · Brooklet, GABuilt 1968 · S/N 32-973N5512URegistration Pending · Smiths Station, ALRegistration pendingBuilt 1969 · S/N 28-26223N5512VCabaniss Tex P Jr · Cypress, TXBuilt 1977 · S/N 28-7725240N5512WMoy Jack M · Los Angeles, CABuilt 1962 · S/N 28-600N5512ZShadow Aviation Inc · Fairbanks, AKBuilt 1964 · S/N 18-7845N55131Sansone Gary A · Fort Laramie, WYBuilt 1973 · S/N 28R-7335184N55134Xin Han Aviation LLC · Atwater, CABuilt 1973 · S/N 34-7350177N55135Air Ventures Flying School LLC · Smithfield, RIBuilt 1973 · S/N 28-7325331N55136Alberio Angela E · Bloomington, MNBuilt 1973 · S/N 28-7325332N55139Hanson Mark A · Snelling, CABuilt 1973 · S/N 28-7305320N5513LCandice Alarned Enterprises Inc · Long Beach, CABuilt 1980 · S/N 15284326N5513UShi Yi · Walnut, CABuilt 1969 · S/N 28-26225N5513WJohnson Thomas D · Pilot Mountain, NCBuilt 1962 · S/N 28-601N55140Di Giorgio Thomas J Jr · Lopez Island, WABuilt 1973 · S/N 28-7305321
Back to AD 81-18-04 R2