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.

N6004Weller Steven C · Hummelstown, PAS/N 95N60046Lee John C · Marietta, OHBuilt 1992 · S/N 14546N6004QSmith Aviation Inc · Wilmington, DEBuilt 1965 · S/N 3224N6004WDorr Martin E · Strongsville, OHBuilt 1978 · S/N M-2121N60051Compass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283355N6005JTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 18283353N6005QBittle Gary D · Bald Knob, ARBuilt 1965 · S/N 861N6005SCompass Rose Aviation LLC · Derby, KSBuilt 2026 · S/N 18283354N6005UHaney William R · Pontotoc, MSBuilt 1970 · S/N 28-26906N6005ZMarstall Nancy T · Asheville, NCBuilt 1978 · S/N M-2127N6006DLedda Francesco · Canton, TXBuilt 1979 · S/N ME-133N6006WGreen William A · Memphis, TNBuilt 1964 · S/N 28-20006N6007CAdler Jeffrey S Trustee · Westminster, COBuilt 1978 · S/N R18200348N6007FMobley Barbara Alice · Kathleen, GABuilt 1979 · S/N WA-4N6007HPolice Facility Design Group Pa · Kansas City, KSBuilt 1993 · S/N 14593N6007QRegistration Pending · Tampa, FLRegistration pendingBuilt 1965 · S/N 3225N6007TMinton Richard D · Longville, LABuilt 1979 · S/N WA-5N6007USteele Tucker L · The Colony, TXFirst renewal noticeBuilt 1970 · S/N 28-26817N6007WMoore Merritt · Mcarthur, CAS/N 28-20007N6007YAudubon Air Of Louisiana LLC · Bossier City, LABuilt 1978 · S/N M-2130N6007ZSharkey John F III · Oswego, NYBuilt 1992 · S/N 14555N60083Kocik William J Jr · Shepherdstown, WVBuilt 1978 · S/N M-2083N60086Echo Bravo LLC · Helena, MTBuilt 1978 · S/N MC-617N6008DChristopher D Bock · Fishers, INBuilt 1979 · S/N MC-611N6008HSwartz Selden H Jr · Jacksonville, ORBuilt 1977 · S/N 28R-7837047N6008KShore Stephen · Longview, TXBuilt 1981 · S/N M-2086N6008LGawlik Leslie W · Reisterstown, MDBuilt 1978 · S/N M-2087N6008URasmussen John E · Seffner, FLBuilt 1978 · S/N MC-616N6008XMangum Gary W · Centreville, VABuilt 1969 · S/N 301836N60096Barto Jerrel · Kula, HIBuilt 1992 · S/N 14552N60097Ratliff Frank O · Palestine, TXBuilt 1978 · S/N MC-619N6009ACampbell Bryan P · Naples, FLBuilt 2009 · S/N 91170N6009DKirkendall James A · N Richland Hills, TXS/N 22-4661N6009MKd 172 Ventures I LLC · Bellevue, WABuilt 2006 · S/N 172S10134N6009POh Air LLC · Mentor, OHBuilt 2006 · S/N 172S10137N6009QDelone Charles P · Sarasota, FLBuilt 1965 · S/N 863N6009VMaui Aviators LLC · Pukalani, HIFirst renewal noticeBuilt 2006 · S/N 172S10138N6009WLowman Jeffrey L · Clarksburg, WVBuilt 1964 · S/N 28-20009N600AMid Atlantic Air Museum · Reading, PABuilt 1955 · S/N 22-3N600AABrauer Jason R · Winnebago, ILBuilt 1968 · S/N 28-25102N600APToombs Todd J · Peyton, COBuilt 2007 · S/N 72378N600AVMountain Top Aviation Inc · Ebensburg, PABuilt 1978 · S/N 28-7916229N600BAJacks Express LLC · Wilmington, DEBuilt 1982 · S/N 60-8265024N600BHBeaupre Harry R · Fallon, NVBuilt 2003 · S/N 2330N600CJPoly Plastics Inc · Owatonna, MNBuilt 1978 · S/N 32R-7885050N600CWWinn Kathy J · Spring, TXBuilt 1994 · S/N 20755N600DWDigital Production And Design LLC · San Mateo, CAS/N 00060022N600EZMoore Glenn C · Elkhart Lake, WIS/N 102N600FSHome Free Aviation LLC · New Port Richey, FLBuilt 1974 · S/N 22-0044N600GGNlh Aviation LLC · College Station, TXBuilt 1980 · S/N 394-80
Back to AD 81-18-04 R2